Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crystal Reports - Failed to retrieve data from the database

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

Former Member
Not what you were looking for? View more on this topic or Ask a question