August 11, 2006 at 9:37 am
Question: We have instances where users request a crystal report form our server. Sometimes they havent got all of the correct parameters and end up with reports that produce over 60 million rows. So they cancell the report realizing that they asked to broad of a question. Then they run another report but the old report, even though it has been cancelled, crystal doesnt seem to notify SQL server and SQL keeps churning on the data.
Has anyone else run into this problem, and know of a way to get crystal to notify SQL. We average a couple thousand reports on cuttoff and a couple hundred a day throughout the month.
August 11, 2006 at 11:54 am
Answer
Behavior that leaves the SQL Server ODBC connection active and processing after a user has cancelled the related report instance.
If the ODBC connection is configured as synchronous, the application using the connection launches a statement on the connection and can do nothing but wait for the statement to complete (or for it to timeout), regardless of what kind of SQL statement in being executed.
On the other hand, if the ODBC connection is configured as asynchronous, the application using the connection can be designed to launch a statement and then continue to do other stuff while occasionally polling the connection to see if the statement has completed. In this mode, the application also has the option to cancel the running statement prior to its' completion.
There appears to be no way to set a "default" synchronous/asynchronous behavior in the ODBC DSN definition itself. Apparently in Microsoft's world, the configuration of the ODBC connection in this regard is up to the application using the DSN definition at the time it establishes its' connections.
The next question is if Business Objects supports this behavior.
Rd
August 11, 2006 at 12:54 pm
How do you have Crystal setup and is this a web app?
August 11, 2006 at 12:58 pm
Setup as a web app that allows the users to schedule there reports through CE10 and then load balances to several report servers.
August 14, 2006 at 7:40 am
Have you contacted Business Objects (http://www.businessobjects.com/) or checked their knowledge base? I have seen this behavior when the Crystal Reports server itself wasn't running.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply