RQP-DEF-0177

Problem(Abstract)

User attempts to run any Controller 'standard report' (also known as 'system report'), for example 'Reconcile - Between Accounts/Opening Balances (Preview)'.

User receives error message.

Symptom

Reconcile - Between Accounts/Opening Balances (Preview)

Cognos 8
RQP-DEF-0177
An error occurred while performing operation 'sqlOpenResult' status='-28'
Details

UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive. UDA-SOR-0001 Unable to
allocate memory. RSV-SRV-0042 Trace back: RSReportService.cpp(595): QFException: CCL_CAUGHT:
RSReportService::process() RSReportServiceMethod.cpp(177)....

Cause

The Controller application server has run out of Windows memory. Therefore, the IBM Cognos 8 BI 'reporting' engine cannot process the report correctly.

There are many potential causes for this lack of memory, but if you are running an old/out-of-date version of Controller, it is possible that your system is suffering from a memory leak.

Resolving the problem

Immediate Fix

Ensure all Controller users out of the system. Reboot Controller application server.

Long-term Solution

Optimise the Cognos 8 BI reporting service environment, by:

1. Ensure that Controller product is upgraded to latest release, to take advantage of memory leak fixes, such as those described inside IBM Technotes #1347915, 1367340 & 1365078.
2. Afterwards, if the problem persists, follow the advice inside separate IBM Technote articles #1341779, 1021723 & 1032429.

Related information

1341779 - Intermittent error when running reports: UDA-
1021723 - Description of 'Sort buffer size in MB' setti
1032429 - UDA-SQL-0530 Could not start a gateway thread
1347915 - Error 'CAM-AAA-0027 - The function call to 'C
1367340 - Error 'Insufficient memory to continue the ex
1365078 - Error 'CAM-AAA-0071 An internal error occurre

Historical Number

1037276