Crystal Reports 9 - Error

[Former Member]

Post Author: Hitch_Hiker

CA Forum: Data Connectivity and SQL

Hi,I am having an issue with Crystal Reports 9. I have a report has a ODBC connection and uses a parameterized stored proc. Based on the parameter passed the stored proc returns a specific set of records or all records. The latter obviously has a lot of data and hence the SP takes a lil longer to execute (under 4 seconds when I call the stored proc from MS SQL Server Management studio). The report works fine when I request for specific set of records but behaves erratically when I request for all records. When I request for all records and hit refresh, the report fails for every alternate refresh and gives me this message, "Not supported. Details: Cannot obtain error message from Server." I searched online and found a very similar problem here,Link 1and http://support.businessobjects.com/communityCS/FilesAndUpdates/ce90dbexwin_en.pdf . ADAPT00136660 Patch ID: 35156653Description:When a user connected to a parameterized stored procedure via ODBC, using Crystal Reports 9, the error message, "Notsupported. Details: Cannot obtain error message from Server.", was generated when no records were returned. Thiserror usually occurred when an invalid parameter value was used to refresh data. When a user viewed or scheduled thesame report in Crystal Enterprise 9, Page Server and Job Server errors were also generated.New Behavior:Now when a user refreshes data in a Crystal Reports 9 report that connects via ODBC to a parameterized storedprocedure, the report displays correctly when no data is returned. The error message is no longer displayed and thereport preview pane shows the results of the report with no data from the stored procedure. The same report can also bescheduled or viewed on-demand successfully in Crystal Enterprise 9. I applied the patch to another machine and it fixed my problem. However, I cannot apply this patch the the main server (people are worried that it might break any other reports) and I am stuck with this issue. I would like to know if there is any work around or any other solution (apart form patching) to this problem? Has anyone faced this before? Thanks

[Former Member]

Post Author: synapsevampire

CA Forum: Data Connectivity and SQL

You need smarter management.

If a software supplier suggests a patch, and the patch corrects something, then you need to apply it.

Implementing a test server is optimal of course. If they do NOT have one, then they must have a disaster recovey plan in place, if it breaks something else, implement it.

They sound like poorly thought out, fear mongering IT people that should be replaced.

I would write up an analysis that states that management will not implement the suggested solution.

In either case, I would get your resume in circulation

-k