Tuesday 4 June 2013

REP-0004: Warning: Unable to open user preference file

Metalink id:
=======
R12: Request Logs Contain the Message "REP-0004: Warning: Unable to open user preference file" [ID 1120529.1]


Symptoms:
=======

All concurrent requests that run REPORTS are printing the following warning in the request log.
REP-0004: Warning: Unable to open user preference file.

Cause:
=====

This message occurs when the concurrent process attempts to open the Oracle Reports executable and your local preference file cannot be found or opened. This is just a warning, so the request will continue to run even if this occurs.



Solution:
=====
To resolve the warning, copy the prefs.ora file from your Reports Builder $ORACLE_HOME/tools/admin/ directory into the Applications $HOME directory.

Example:
Copy of the file prefs.ora in the directory /u01/prod/apps/tech_st/10.1.2/tools/admin to the directory  /home/appprod/.


appdev@ctssd $ pwd
/u01/erpapp/10.1.2/tools/admin
appdev@ctssd $ cp prefs.ora /export/home/apptest

Note: Bounce apache service.
After doing above steps my issue resolved.


To watch old blogs click on the bottom of the page.Thanks for visiting my blog.


No comments:

Post a Comment