RQP-DEF-0177-白红宇

RQP-DEF-0177

阅读量：4116 次

发布时间：2019-05-25

本文共 1518 字，大约阅读时间需要 5 分钟。

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.

Related information

Historical Number

1037276

转载地址：http://urdpi.baihongyu.com/

你可能感兴趣的文章