REP-0001: Unable to find the Report Builder message file. Please verify your installation.

Error: REP-0001: Unable to find the Report Builder message file.  Please verify your installation.

Active User and all other report related concurrent programs are completing with error with below error message.

REP-0001: Unable to find the Report Builder message file.  Please verify your installation.

Solution:

We have noticed that application environment is set to 1013 Oracle Home instead of 1012.

When we export ORACLE_HOME=/ABCD/product/1012 and executed report command from backend, it went successful.

But when we submit Active users it is again completing with same error message.

Finding:

After running Print Environment Variable program(Parameter: ORACLE_HOME) , it is still pointing to 1013 oracle home.

Modified the .bash_profile, env files to point 1012 oracle home and bounced the Application to resolve this issue.

The Concurrent Manager Process that was running this request has exited abnormally

Error : The Concurrent Manager Process that was running this request has exited abnormally

When I checked at back end for associated SID for the concurrent request, i couldn't find it.

Unable to cancel a concurrent request out of the queue that is stuck.

Cause

Tried to Cancel a concurrent request. Used the "Cancel Request" button from the Administer > Concurrent > Manager form.

Got the following message:

Request xxxxxx can no longer be cancelled. The Concurrent Manager Process that was running this request has exited abnormally. The ICM will mark this request as completed with error.


Solution

Manually cancel the request out of the queue with the following SQL against the offending
request id(s). This can be safely done while managers are up and running:

SQL> UPDATE fnd_concurrent_requests
  2  SET phase_code = 'C', status_code = 'X'
  3  WHERE request_id = '28979017';

1 row updated.


SQL> commit;