Random Cognos 8 Bursting Error

[sc_solucient]

I'm trying to burst a large number of reports (over 4,000), but I keep getting the following sporadic error(s):

RQP-DEF-0177 An error occurred while performing operation 'sqlOpenResult' status='-28'.
UDA-SQL-0114 The cursor supplied to the operation "sqlOpenResult" is inactive.
UDA-SQL-0107 A general exception has occurred during the operation "AOpen".Ã, 

It happens at different points of the burst run, but never finishes the job.

The database is oracle.

Anybody experience something similiar?? ???

[COGNOiSe administrator]

You might be running out of TEMP space in ORACLE.

[Redrichmond]

We have the same problem..Logged with Cognos support who dont know what the problem is..If we restart the services the reports run..We split the report into 2 and had better sucess. Although it crashes after a few runs...

I suspect it has to be to do with the report or model..After speaking to a Cognos external Consultant. They had the same problem but rebuilt the report and model to remove any joins in the report, pushing all queries to the DB..

We have 16gb of memory. Increasing the memory will not help as Cognos 8 can use 4 gb as a 32bit application. We increased the memory on our content store DB and cleared down the Trans log which was 90GB!!! This didnt help.

We tried playing with the MB settings in the server from 1024 to 768 to 512 this didnt work..

I guess Cognos has some kind of limit/queries that it can cope with before it blows up...

Sorry But try rebuilding the model and report....

[MMithun]

Did anybody resolved this issue?

If yes, are are the different settings need to change?