Tuesday, April 24, 2012

REP-0118 Unable to create temporary file

Earlier today, we were getting the following error when generating reports in Oracle Developer 6i:

REP-0118 Unable to create temporary file

It seems that the reports runtime wasn't able to create a temporary file in the reports temporary directory.  So, we simply changed the permission of this directory to correct the problem.  We gave write permission to the user who was running the report.  This directory is located here:

$ORACLE_HOME/reports60/TMP

Installations can be customized, so to get the exact location of the above folder, look for the regedit entry: REPORTS60_TMP

In summary, the cause of this error is the changing of the permission of the REPORTS60_TMP folder to read only.  The user running the report has no permission to write any file on this directory.

2 comments:

  1. I am using Oracle Reports Builders 10g on Windows 7, and have used it for a few weeks. All of a sudden after opening it, it will show the icon in the task bar, but nothing else. The task manager says that it's active, but Reports Builder does not allow me to make any changes. The main window simply does not appear.

    Does anybody have this or a comparable experience, plus a solution, please?

    ReplyDelete