scheduled brusting report failed with errors - Urgent help

[tel03]

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.

[shailendra32]

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

[tel03]

Thanks for the replay Gupta.

how to increase the job.Memory usagae or how to change the settings.

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

[bi4u2]

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

[tel03]

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