Saturday, July 30, 2016

Concurrent Reports Failing With Errors REP-0004,REP-0082 and REP-0104

ISSUE:

Below error found in concurrent log

REP-0004: Warning: Unable to open user preference file.
REP-0082: Error executing SCA utility.
REP-0104: Unable to delete file '<Name.rdf>'.
scaba 5
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-159:

SOLUTION:

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

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

cp /d01/oracle/apps/tech_st/10.1.2/tools/admin/prefs.ora to the directory /home/applmgr/

2. REP-0082: Error executing SCA utility.
    REP-0104: Unable to delete file '<Name.rdf>'.
    scaba 5
    REP-0069: Internal error
    REP-57054: In-process job terminated:Terminated with error:
    REP-159:

To implement the solution, please execute the following steps:

1. Stop the concurrent managers using adcmctl.sh.

2. Truncate the reports.log file in log directory (under $APPLCSF/$APPLLOG).

3. Restart the concurrent managers.

4. Submit Concurrent request of type RDF from Oracle Applications and ensure it completes normal.

No comments:

Post a Comment