May 19, 2012  
   Login  
Forum  
 
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Intermittent execution error -- Namespace?Intermittent execution error -- Namespace?
Previous Previous
 
Next Next
New Post
 6/5/2008 5:54 PM
 
Hi

I did a quick search for this error on the forum but was unable to find anything referencing the issue (other than a KB article that looked promising in the summary but which just re-routed me to the sales page).

I have a report (actually many reports) that works fine in VSS and that works most of the time on the report server.  However, intermittently, users get the error


* An error has occurred during report processing. (rsProcessingAborted)

* Query execution failed for data set 'dataset'. (rsErrorExecutingCommand)

There isn't any consistency to the errors, but when I look at the reportserver logs I see a stack track culminating in

"Namespace prefix 'en' is not defined."

We're using 2.1, and I have the config files on both the sql server and vss box set up as directed with our correct license keys.

I have the xmlns specified as below (from the instructions pdf)




would someone be able to tell me what I'm missing please? I don't have intellisense set up on the project because although I dropped the schema files, I'm just creating a reporting services project and don't have an option to add an xml file (other than just importing an existing one). Please let me know if it's required to use intellisense.

I don't quite understand why the error would be intermittent. Most of the time it works just fine, it does not appear to be browser dependent, I've seen the issue on IE or Firefox. I can post the entire stack trace but it's messy and essentially just a failure looking up the namespace.

Thanks!

Caroline
New Post
 6/5/2008 9:27 PM
 

Hi,

Could you check that you have exactly the same dll version on both the server and your development environment?

We have included in the samples a report for displaying version information.

Could you add this report to your report solution and run it from your VSS after having changed the datasource to some existing datasource (even though the report will not retrieve any data from SharePoint).

After having run this report properly from your vss, please deploy the report to your report server and run the report once again from your report server.

Can you confirm that both reports execution returns exactly the same version information?

The schema files are provided as an helper tool for writing queries using an xml file.

The overall idea is to add an xml file to your project, to specify ERSDE.xsd as the associated schema for the xml file, write your queries using the xml file so that you can benefit from intellisense, copy the query into the data view's generic query designer when you are finished. You don't need to keep all your queries into an xml file. When you want to modify a query, you can just copy and paste the query from the data view's query designer into your xml file and make your modifications before copying it back to your report.

Let me know about your version information. You can send me an email as well to our support address if you would like to provide some screen shots. Our support address is available in the documentation.

Regards,


Frederic LATOUR
ENESYS
New Post
 6/6/2008 1:07 AM
 
Hi, thanks for replying.

I ran the report and looked at the .dll directly and both the report server and my local machine are running

Edition Version
Standard Edition - Server License 2.1.0.28200
New Post
 6/6/2008 9:34 AM
 

Hi,

Could you possibly send me some logs (or part of some logs) by email so that I can have a look and try to find some possible direction to look into?

Regards,


Frederic LATOUR
ENESYS
New Post
 6/6/2008 8:13 PM
 
Thanks! I sent you the logs in email.
New Post
 6/20/2008 11:24 PM
 

Hello,

I'm getting a similar error when continually refreshing a report that works about 95% of the time. 

I have the following setup:
Master Report -> Sub Report -> Sub Report

Since that final Subreport fails about 5% of the time, the Master report outputs:
Error: Subreport could not be shown.

Hitting Refresh on the Master Report will just have the Error appear in different Rows as it seems completely random.  I only suspect that "Namespace prefix 'en' is not defined." is happening on one of the subreports is causing the Master Report to show the error for that row.

I would really appreciate some help in solving this as it's not something we can just hit refresh until it gets every row correct.  The report takes about 1 minute to generate because of the complexity.

Thanks!

 

New Post
 6/23/2008 6:17 PM
 

I think I solved the Namespace prefix issue.  Each report had their language being the default one: English(US), I changed it to English (Canada) to match the regional settings on our server.  However, that didn't fix everything.  I'm now getting the follow errors:

[rsWarningExecutingSubreport] Warnings occurred while executing the subreport ‘RelationshipsSubReport’.
    [rsErrorExecutingSubreport] An error occurred while executing the subreport ‘SubReport3AddressSingle’: An error has occurred during report processing.
        [rsNone] Query execution failed for data set 'Person2'.

Preview complete -- 0 errors, 1 warnings

I've checked that parameters that each sub report is given and they shouldn't ever be None.  Sometimes the report doesn't have any problems and displays properly, I'm down to about a 2% error rate.

New Post
 8/26/2008 4:05 AM
 
We continue to have this problem. I've gone over all our datasets carefully and checked against the schema. I can't seem to find what's wrong with the reports, but the error intermittently happens. Refreshing fixes the issue temporarily which is fine when it's just me viewing the reports, but it's not realistic for when we're presenting them.

The only consistent thing I see in the error logs is, regardless of which dataset was being called, one of the datasets for a report will fail repeatedly for a given session. If I re load or start a new session for the same report it will work again, and if it runs into a failure, it usually trips up on another datasource, but continues to complain about that dataset for the rest of that session. Any processing failures will blame the dataset it believes failed first even if it was presenting a table that called a different dataset.

Again, it always says fails with " System.Xml.XPath.XPathException: Namespace prefix 'en' is not defined" No such prefix is being used in the rdl . The only prefix I see being used explicitly in the rdl is rd:

Although the error is hard to reproduce reliably, it definitely only occurs in reports with multiple datasets. I don't know if that's due to complexity, or some other issue.

Thanks, and let me know if I can provide further information.

New Post
 8/26/2008 3:56 PM
 

Caroline,

It looks like I can't reach you by email (I've received yours).

Could you see if there is anything you can do and possibly authorize our domain (enesyssoftware.com) to send emails?

Regards,


Frederic LATOUR
ENESYS
New Post
 9/4/2008 11:18 PM
 

I have the same problem.

Anyone found the solution?

New Post
 9/4/2008 11:43 PM
 
 Modified By Frédéric LATOUR  on 9/4/2008 11:44:27 PM

Hi,

We have worked with a customer on the problem without being able to reproduce this intermittent problem when running the report on our side accessing SharePoint data on their side.

Would it be possible for you to give a try to ERSDE version 3 and see if you still get those problems.

With have included a logging framework with the newer version that makes it possible (when necessary by just modifying logging configuration) to trace more accurately ERSDE execution.

I have given you an access to the preview downlads page where you can get the newer version which can be installed side by side with the current version.

Let me know,

 


Frederic LATOUR
ENESYS
Previous Previous
 
Next Next
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Intermittent execution error -- Namespace?Intermittent execution error -- Namespace?

 
You need to login for posting to the forums.
If you don't have a login, click here to register.
You need to login for posting to the forums.
If you don't have a login, click here to register.
 
Copyright 2010 Enesys - All rights reserved Terms Of UsePrivacy Statement