Home > oracle, oracle forms&reports > REPORTS_PATH limited to 1024 chars: REP-52251: Cannot get output of job ID 7204

REPORTS_PATH limited to 1024 chars: REP-52251: Cannot get output of job ID 7204

We are deploying an application in Forms 10g Release 2, and when we run a report we get this error:

REP-52251: Cannot get output of job ID 7204
REP-51026: No output for job 7204

In the Oracle Enterprise Manager Reports Server’s Failed jobs we can see this error message:

 Terminated with error:
 REP-110: Unable to open file 'repenv1012.rdf'.
 REP-1070: Error while opening or saving a document.
 REP-0110: Unable to open file 'repenv1012.rdf'.
 

This error is due to the length of the REPORTS_PATH environment variable defined in $ORACLE_HOME/bin/reports.sh. We have a lot of applications deployed within one reports server, and the reports path length has exceeded 1024 chars.
To solve it, we have two ways:

Although the Dinamic Environment Switching is very powerfull, it requires adding a new parameter to the calling report, and as we do not develop the applications, we have opted for the second one.

 

  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

Follow

Get every new post delivered to your Inbox.

Join 33 other followers

%d bloggers like this: