February 9, 2012  
   Login  
Forum  
 
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Query execution failedQuery execution failed
Previous Previous
 
Next Next
New Post
 7/9/2009 9:43 PM
 
 Modified By anonymous  on 7/9/2009 11:22:00 PM

I have some SSRS 2005 reports with several enesys datasets. Each dataset is pulling one, small list (0 to 10 items).

I am using 1 parameter (@siteURL) for the relativeSiteUrl of the list in each DS.

I randomly get this error message - if I run it again, I get the same error, but on a different DS.  The more datasets I have, the more often this error appears.

When I execute each DS in the Data tab, I don't get an error.

I am using version 3.1, Windows Integrated Security.

 

Thanks!

New Post
 7/10/2009 10:22 AM
 

Hi atarvin,

It seems like you forgot to paste the error message. It is difficult to help you without any error message.

A common problem when using parameters in the relativeSiteUrl attribute is explained in this KB article:
http://www.enesyssoftware.com/Products/EnesysRSDataExtension/KBandSamples/tabid/93/EntryID/59/language/en-US/Default.aspx

If it doesn't help, please provide us your error message so we can be more accurate.

Regards,
Marien Monnier
Enesys

New Post
 7/10/2009 7:03 PM
 

Marien Monnier wrote

Hi atarvin,

It seems like you forgot to paste the error message. It is difficult to help you without any error message.

A common problem when using parameters in the relativeSiteUrl attribute is explained in this KB article:
http://www.enesyssoftware.com/Products/EnesysRSDataExtension/KBandSamples/tabid/93/EntryID/59/language/en-US/Default.aspx

If it doesn't help, please provide us your error message so we can be more accurate.

Regards,
Marien Monnier
Enesys

 

Thanks Marien.  I put the main part of the error message in the subject, but here is the entirety:

An error occurred during local report processing.
An error has occurred during report processing.
Query execution failed for data set 'Risks51'.
The list Issues could not be found in the site http://xxx.xxxxx.com@siteURL!/

I'll try the suggestion in the link you sent and report back.

Thanks!

 

New Post
 7/10/2009 8:21 PM
 

That worked!  Thanks a lot.

Previous Previous
 
Next Next
ForumForumEnesys RS Data ...Enesys RS Data ...Support - RS Da...Support - RS Da...Query execution failedQuery execution failed

 
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