Execution Error - Support - RS Data Extension

Search Forum Home

Forum

Enesys RS Data ...

Support - RS Da...

Execution Error

9/4/2009 1:45 AM

anonymous

Joined: 1/1/0001

Posts: 0

Execution Error

Hi,

I am evaluating RS Data Extension. I installed and configured both client and SR server. In development environment in BIDS, I was able to run everything correctly, but when I publish the report to the server and run, I got the following error:

An error has occurred during report processing.
- Query execution failed for data set 'DataSourceDev'.
  - For more information about this error navigate to the report server on the local server machine, or enable remote errors

I am using WinAuth and I am the site owner. Please help!

Thanks,

9/4/2009 2:20 AM

Frédéric LATOUR

Joined: 5/31/2006

Posts: 629

Execution Error

Hi,

If your report server is located on a different server than your SharePoint server you may need to implement Kerberos in order to pass current user credentials (double-hop problem).

To confirm this is the problem, try to change the data source on the sever (it should have been automatically published when publishing the report) and set the credentials to a specific user account (your account would be fine if you have the necessary permissions).

Does it work in this configuration?

Let me know.

Regards,

Frederic LATOUR
ENESYS

9/4/2009 11:17 PM

anonymous

Joined: 1/1/0001

Posts: 0

Re: Execution Error

Hi,

After configure DS based on your suggestion, I got the reports to work in Report Manager, but NOT in the Report Server! When running the reports in Report Server, the interface shows up, but when click on "View Report", I got the following error:

Execution 'ovsdbky1wmmaeiima4c0zeza' cannot be found (rsExecutionNotFound)

Please help.

Thanks,

9/5/2009 12:58 AM

Frédéric LATOUR

Joined: 5/31/2006

Posts: 629

Re: Execution Error

Hi,

Not sure to understand what you mean by Report Manager compared to Report Server?

Do you mean BIDS?

Can you clarify?

Thanks,

Frederic LATOUR
ENESYS

9/8/2009 9:12 PM

anonymous

Joined: 1/1/0001

Posts: 0

Re: Execution Error

Hi,

The reports work in the Report Manager (http://srss/Reports) where you manage security/subscript...But when I browse to Report Server (http://srss/ReportServer) where you usually give the link to users to access the reports, it did not work and gave me above error!

Thanks,

9/9/2009 1:21 PM

Frédéric LATOUR

Joined: 5/31/2006

Posts: 629

Re: Execution Error

Not sure what exactly could go wrong here. It works fine on our side.

Does it work with another type of report (say a report using a SQL data source)?

Regards,

Frederic LATOUR
ENESYS

Page 1 of 1