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.

 

About these ads
  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 32 other followers

%d bloggers like this: