BOE XI R2 system connected to an Oracle 10.023g database
I have an issue here where users are viewing Crystal Reports on demand. The reports contain several on demand subreports and are connecting to the database via Universe. Upon viewing the report, individual connections are established on the database, each connection representing a subreport and the main report itself. However, once the user closes the report, the connections remain opened but are inactive. After the "Minutes Before an Idle Report Job is Closed" has passed, the connections still remain.
The key question here is what constitutes a report job as closed? Are the on- demand subreports still withholding the connections and maintaining an active job, therefore does not close. The connections close only after the pageserver is restarted.
The following are the settings for the Crystal Reports Page Server:
Minutes Before an Idle Connection is Closed: 5
Minutes Before an Idle Report Job is Closed: 5
Oldest On-Demand Data Given To a Client(in minutes): 0
Report Job Database Connection: Disconnect when all records have been retrieved or the job is closed.
Regards,
Calvin