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 JANUARY 05, 2024

Applies to:

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

Symptoms

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.

 

ERROR:

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

 

 

STEPS TO REPRODUCE:

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

Changes

 None

Cause

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
Symptoms
Changes
Cause
Solution
References


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