COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: RP on 30 Oct 2007 04:46:01 PM

Title: Error while running the reports
Post by: RP on 30 Oct 2007 04:46:01 PM
I'm getteing the following errors, while running the reports. Could you tell me what is the reason and how to resolve this.

1. An error occurred while performing operation 'sqlScrollBulkFetch'   
    status='-232'

2. PDS-PPE-0116 An I/O error occurred using a temporary file. PPDSError
   116

Thank you,
PR

Title: Re: Error while running the reports
Post by: praveennb on 30 Oct 2007 10:13:31 PM
My guess is that the cognos service account doesn't have permission to access the temporary files.
try to change the cognos startup  account to a user who belongs to the local administrator group,
and restart the service

The user account used to start the cognos8 service should also have read/write access to this folder
<cognos8_install folder>\temp

let us know if this worked.
Title: Re: Error while running the reports
Post by: excelbase on 05 Nov 2007 04:58:56 AM
Hi PR,
It will seem to me  to be an environmental issue relating to  disc space.  We resolved this issue in the past by  deleting unused  temporary files.
Title: Re: Error while running the reports
Post by: excelbase on 05 Nov 2007 05:00:21 AM
In addition to this check how yor DBA has been managing his log files
Excelbase
Title: Re: Error while running the reports
Post by: RP on 05 Nov 2007 12:30:51 PM
Thank you, I'm working on that