REP-0004

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 /apps/prod/apps/tech_st/10.1.2/tools/admin/ to the directory  /home/applprod/.

[applprod@sujeet ~]$ cd /apps/prod/apps/tech_st/10.1.2/tools/admin/

[applprod@sujeet  admin]$ ls
prefs.ora  

[applprod@sujeet  admin]$ cp prefs.ora /home/applprod/

Note: Bounce apache service.



Issue resolved.


NOTE:
For a report developed by xml publisher getting the same error, create /HDDATA/xml_tmp directory (environment dependent) on the system server after checking Administration from XML Publisher Administrator responsibility -> Configuration -> General -> Temporary directory column is /HDDATA/xml_tmp.

No comments:

ORA-01552: cannot use system rollback segment for non-system tablespace 'TEMP'

 ORA-01552: cannot use system rollback segment for non-system tablespace "string" Cause: Used the system rollback segment for non...