Skip to Content
author's profile photo Former Member
Former Member

Crystal Reports 9 - Error

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Former Member
    Former Member
    Posted on Jul 13, 2007 at 07:19 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.