Skip to Content
0
Former Member
Nov 10, 2011 at 09:33 PM

Crystal Reports - Failed to retrieve data from the database

26727 Views

Hi There,

I'm hoping that somebody can help me.

I've developed a crystal report from a stored procedure which I wrote. I can execute the stored procedure within SQL Server and within the Crystal Reports designer without any errors. Furthermore, I have imported the report into sap and can run it within SAP from the server without any errors. SAP version 8.81 PL5

The issue is that when it's run from a client machine, I get the following error: "Failed to retrieve data from the database. Details: Database Vendor Code: 156. Error in the File RCR10010 {tempfile location}

Here's a list of things which I have tried, all to no avail:

- Checked user permissions to ensure that they have proper authorizations

- Re-set the datasource connection and re-imported the report to SAP.

- Exported the report and reviewed the datasource connection and re-imported to SAP.

- Tried to run the report on multiple machines to ensure that it's not machine specific

- Tried to run the report using different users to ensure it's not user specific.

- Tested other reports built from stored procedures on client machines to ensure that they work.

Any assistance in this would be GREATLY appreciated.

Thank you