REP-0081 and REP-0105
hi,
I got this error while running a really large report using Report Builder (6.0.8.23) -> Generate to File (PDF)
REP-0081: error during I/O operation
REP-0105: Unable to lock file 'C:\orant\REPORT60\TMP\01003924' in exclusive mode.scafa 6 'C:\orant\REPORT60\TMP\01003924'
Looking through metalink and posting there, it seemed the error was usually caused by too little memory and possible solutions offered there were to increase the size of BUFFERS and ARRAYSIZE. I ran this on 2 windows machines with 600 RAM/3GB hard disk and 1GB RAM/10GB hard disk.
My question there and for which i was asked to post here is "if you are running a report with generate to PDF, shouldn't it be writing to the file (hard disk) regularly in which case the size of RAM should not matter that much. It would certainly buffer some data and hold it in memory before writing but will it hold the entire report data before writing or perform regular writes to the PDF. If it performs regular writes then how much data does it buffer?"