Hi All,
I am facing a weird problem.
I am using stored procedure for my CR XI R2 report and when i launch launch the report, it gives me the following error.
Failed to retrieve data from the database. Details: Database Vendor Code: 6550 Failed to retrieve data from the database. Error in File {8F49B0D8-1B18-4B25-94C3-F840FC73B699}.rpt: Failed to retrieve data from the database. Details: Database Vendor Code: 6550
This is only happening on reports that use stored procedures to generate their results. The stored procedure is fine, and the permissions are all fine also.
Whenever I have used a stored procedure, I have used a ref_cursor to return the data.
If you don’t use the ref_cursor then add a select statement at the end of the procedure to show all columns in your results table.
Have you find a solution to the problem the steps is un clear to me too, av_deepu mentioned that
Hi av_deepu,
Can you share with us the steps or direct us to a site that can teach us how to solve the problem.
The error message that I am getting is from my sub reports, the main report loaded out fine, but when I click on the hyperlinks to the subreports I got this error:-
Failed to retrieve data from the database. Details: [Database Vendor Code: 6550 ] Failed to retrieve data from the database. Details: [Database Vendor Code: 6550 ] Failed to retrieve data from the database. Error in File OAWR3011A {AAA61A57-C7AC-4840-A580-731E0F6F898F}.rpt: Failed to retrieve data from the database. Details: [Database Vendor Code: 6550 ]
Hello I have also included a detail description of my wired sub report issue at the link below:-
Initially I thought it is the Crystal Report 2008 runtime software issue, because my web application is using R2 version, so I later patched it up to R4 but the issue still persists.
(BOB member since 2010-08-11)
(BOB member since 2007-03-23)