My Oracle Support Banner

Several Project Forms Error When Using Form Functions Like 'Export', 'Select All' or 'Record-Last': FRM-41839: Disk I/O error on temporary record buffer file (Doc ID 969646.1)

Last updated on MARCH 06, 2023

Applies to:

Oracle Project Costing - Version and later
Information in this document applies to any platform.
PAXTRAPE, Expenditure Inquiry form
PAXPREPR, Projects Inquiry form


On several Projects forms, such as Project or Expenditure Inquiry forms, the users receive error on the form on attempting to one or more of the following functions:

File > Export

File > Select All

View > Record > Last


The temporary directory may have a lot of space available and the file size setting may be unlimited but the error is still encountered. Also the issue may reproduce just for some projects, usually those having to retrieve or scan a huge number of records.

The number of records triggering the error would vary, depending on the hardware configuration, network capabilities and so on.

Also the issue may not always reproduce even for the same project queried. That may vary depending on the hardware resources available.



FRM-41839: Disk I/O error on temporary record buffer file < location of the .TMP file >




1. Project Costing Super User > Projects or
Project Costing Super User > Expenditure > Inquiry
2. From the menu, pick any of these options
2.1. File > Export
2.2. Edit > Select All
2.3. View > Record > Last
3. The form shows: 'Gathering Column Information'
4. The form shows: '100 more records have been retrieved, an unknown number of additional records remain' Options: < Continue> <Stop> <Continue to End>
5. <Continue to End> shows the form's progress: Retrieving all records...
4. Some or all these functions may throw error on executing after attempting to retrieve all the records




To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.