Hi All,
See below the error we got yesterday when the scheduled failed for Rebate performance report. This report is doing bursting we have around 1500 reports that needs to be in the shared network drive with both (XML and PDF versions). We almost got all the XML versions but no PDF and the schedule got failed.
RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation "APICursor:penResult" is inactive.
UDA-SQL-0107 A general exception has occurred during the operation "AOpen".
Please let me know the solution if you got this issues before.
Hi,
These could be because of large number of reports you have bursted in a shot.
Try to burst 400 to 500 reports in a job.Memory usagae could be one issue.
Regards,
Shailendra Gupta
Thanks for the replay Gupta.
how to increase the job.Memory usagae or how to change the settings.
Quote from: shailendra32 on 10 Jul 2012 05:39:16 AM
Hi,
These could be because of large number of reports you have bursted in a shot.
Try to burst 400 to 500 reports in a job.Memory usagae could be one issue.
Regards,
Shailendra Gupta
Have you tried adjusting the maximum memory setting in Cognos Configuration?
I would look into the Installation and Configuration guide, into the following topic:
Adjusting the Memory Resources for the IBM Cognos Service
Yes bi4u2, I tried changing the settings in cognos config from small type config to large type config. The large type config takes only max 1534 and if I increase this value more than that it gives JVM error message and says it is not supported
we have 3.75 GB RAm and VMware virtual platform.
please let me know what else ideas i can get to resolve this issuse