FRM-41839 Disk I/O

Exporting Data From Journals Enter Form Gives Error FRM-41839 Disk I/O Error [ID 1208313.1]

Applies to:

Oracle General Ledger - Version: 11.5.10.0 and later   [Release: 11.5.10 and later ]
Information in this document applies to any platform.
Form:GLXJEENT.FMB - Enter Journals/Encumbrances

Symptoms

FRM-41839 Disk I/O error on temporary record buffer file is seen when File > Export is done on Journals > Enter form.

Cause

The export functionality has a limitation to the amount of data that can be exported.  In this case the number of records identified were 120000.  Export cannot work for such a huge amount of data as that would consume all system resources.

Solution

Use the find window or enter-query and construct a query that returns just the records you need.  Running a query that potentially returns 100,000 rows and using "last record" functionality to find the record you want will result in poor performance.

No comments:

ORA-00059: Maximum Number Of DB_FILES Exceeded in 19C database

When I am adding datafile to my 19C database facing the below error. SQL> alter tablespace DATA  add datafile '/u01/data/data15.dbf&#...