Home » Developer & Programmer » Reports & Discoverer » Reports Generation I/O Error (Oracle 10g DB and Oracle 10g Application Server)
Reports Generation I/O Error [message #401516] Tue, 05 May 2009 06:05 Go to next message
pradies
Messages: 245
Registered: May 2008
Senior Member
Hi,

I am using Oracle 10g Database and Oracle 10g Appplicaiton server for reports generation. there is Report with the large number of pages and when its formatting report with the 47000 Thousand of pages then Its throwing the following error.

Terminated with error: REP--1870639098: Error during file I/O operation. REP-0105: Unable to lock file 'C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\000807756' in exclusive mode.scafa 6 C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\000807756 REP-0002: Unable to retrieve a string from the Report Builder message file. REP--1870639098:


So after searching on the net and at metalink also I am not getting any result from there.

So is there any solution for this error.

Thanks in Advance

Pradeep
Re: Reports Generation I/O Error [message #401672 is a reply to message #401516] Wed, 06 May 2009 01:51 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
This seems to be a very large report. (Is someone really going to review 50.000 pages?!?) Did you, perhaps, run out of available disk space?
Re: Reports Generation I/O Error [message #401768 is a reply to message #401672] Wed, 06 May 2009 07:06 Go to previous messageGo to next message
pradies
Messages: 245
Registered: May 2008
Senior Member
Hi,

Yes I know no one can review this large number of report. but how can i restrict user to not run this report (ledger Report).

Regarding the Memory issue, can you please tell me how its going out of disk space. because when this reports is running at that time CPU usage is about 10-15%. and all the Operating system Drives (c,d) have more then 10GB of free space. Total RAM on server is 4GB and during the Report the commit charge is about 2.2GB/10GB.

So this is little bit confusing for me how I m getting out of space?


Thanks

Pradeep Sharma
Re: Reports Generation I/O Error [message #401876 is a reply to message #401768] Wed, 06 May 2009 14:57 Go to previous message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
I'm not saying that you DID run out of space; I have just asked whether this is the case. It appears not.

So, what now? No idea, sorry.
Previous Topic: Monthwise break up not show in order
Next Topic: generate large pdf
Goto Forum:
  


Current Time: Sat Dec 03 16:23:38 CST 2016

Total time taken to generate the page: 0.04204 seconds