Sunday, July 9, 2017

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

Issue :
----------
Enter Password:
REP-0004: Warning: Unable to open user preference file.
REP-0069: Internal error
REP-57054: In-process job terminated:Finished successfully but output is voided

Report Builder: Release 10.1.2.2.0 - Production on Sat Jun 24 06:48:27 2017

Cause:

Your local (customized) Oracle Reports preference file could not be opened.
This is just a warning, so the product will continue to run even if this occurs.
The possible causes of this error include the following:

Case 1: The file was not found under the specified name in the specified location.

Case 2: You lacked the necessary privileges to open the file.

Case 3: A system error made it impossible to open the file.

Action:
-----------

You can take the following actions to rectify this error:

Case 1: Make sure the file prefs.ora is located in your "home" directory.

Case 2: Make sure that you have the privileges necessary to access the file. If you don't, change your privileges accordingly.

Case 3: Consult your operating system documentation or contact your system administrator.

======================================================================

The preferences file referred to above is:

Windows
ORACLE_HOME\CAUPREFS.ORA (user preferences)
ORACLE_HOME\CAGPREFS.ORA (global preferences)

UNIX
your_home_directory/prefs.ora (user preferences)
$ORACLE_HOME/tools/admin/prefs.ora (global preferences)

===================================================================== 
Simple Way:

Check whether u have prefs.ora file in your application user's home

eg: prefs file should be in /home/applmg/prefs.ora

if not please copy prefs.ora file from  $ORACLE_HOME/tools/admin/prefs.ora  to /home/applmg/prefs.ora location.

Run your concurrent request/program.



No comments:

Post a Comment

IAS Cache initialization failed

 Today I faced an Issue in R12.2 instance. The solution I followed to overcome the issue is very simple, but they are more than one solution...