CE 9.0 Report Fails "Failed to open a rowset"

[wilsonmichael]

When running this one report i sometimes get this failed message "Failed to open a rowset. File D:\Program Files\Crystal Decisions\Shared\Temp\procSched\USMEADMGFISPCD1.report\~tmp11c834f5d929860.rpt."

This message occurrs after the report has been running for 30 minutes. Is there some kind of timeout for long running queries?

I have checked the database and i do see a long running query but there is output that is being written. The error found in oracle is a lost connection error.

System Details
I am running crystal enterprise 9.0 with oracle 9 database.
using odbc driver CR Oracle Wire Protocol ODBC Driver 4.10

The report i am running contains a stored procedure. I pass three parameters to the procedure. These 3 parameters are a Userid, a report_id and a seq_id. These parameters are telling the proceudure where to get the data to run from.

Thanks
Mike

 

[Turkbear]

Hi,
It looks like you connection to Oracle is Timing Out..There is a setting that drops 'idle' connections after some period of time and since no data had been returned yet, the connection is seen as idle..
In the CMC go to Manage Servers and check the timeout setting on the Pageserver...
But before changing it, you may want to be sure your SP is as efficient as possible so that the query does not take so long..how many records, on average, are involved?

 

[wilsonmichael]

The setting for the page server says 20 minutes.
so after 10 minutes of activity it seems to go idle
until it fails after 30 minutes

I ran this report with the same criteria and data in our benchmarking environment and it ran in 7 minutes. Returned 2600 rows. The data in both environments are the same.

 

[cjlarue]

Could it be a difference in indexes between the two DB environments. Also the timeout issue was a bug in CR crdb_ADO.dll until 9.1.1.450. I don't recall if there was a similar issue with other DB Drivers.

 

[wilsonmichael]

currently there are no indexes on the tables the procedure uses in either environments

 

[wilsonmichael]

What was the timeout bug yu speak of and what hotfix was this fixed in

 

[cjlarue]

The bug was that the error "Failed to open a rowset" occcurrs when a report is based on a stored procedure that requires greater than 30 seconds to process. It was fixed in the hot fix cr10netwin_en.zip on 12/5/2002.