RQP-DEF-0177

最新推荐文章于 2021-04-11 06:32:14 发布

soconglin

最新推荐文章于 2021-04-11 06:32:14 发布

阅读量5.7k

点赞数

分类专栏： Cognos BI 文章标签： report application ibm system leak thread

Cognos BI 专栏收录该内容

5 篇文章 0 订阅

订阅专栏

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:

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.
Afterwards, if the problem persists, follow the advice inside separate IBM Technote articles #1341779, 1021723 & 1032429.