FRM-41839

FRM-41839 Occurs when Querying Large Number of Rows and the Temporary File Size Grows Beyond 2GB [ID 970318.1]

Applies to:

Oracle Forms - Version 10.1.2.3.0 to 10.1.2.3.0 [Release 10.1.2.3]
Information in this document applies to any platform.
Checked for relevance on 28-Sep-2012

Symptoms

This problem can occur when attempting to execute a query in a form that returns large number of rows if the temporary file size increases beyond 2GB.  The error returned is ->
FRM-41839: Disk I/O error on temporary record buffer file /var/tmp/AAA6Gay8d.TMP

Cause

The forms run time process does not allow the temp file to grow beyond 2GB while querying the block. The following bug is filed for the same issue.

Bug 8970798 Abstract: APPS6: FORMS NOT ABLE TO WRITE TO TMP FILE BEYOND 2GB

The bug fixes the issue and allows the temporary to grow up to 4GB.

Solution

To implement the solution, please execute the following steps:

1. Apply   Patch 9593176

2. Download and review the readme and pre-requisites for the patch.
( see also
NOTE:1188127.1 - Oracle Forms 10.1.2.3 Bundle Patch Frequently Asked Questions (FAQ)

3. Ensure that you have taken a backup of your system before applying the recommended patch.
4. Apply the patch in a test environment.
5. Retest the issue.
6. Migrate the solution as appropriate to other environments.