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:
- Use Dinamic Environment Switching, a very interesting option available since 220.127.116.11 version (http://docs.oracle.com/cd/B14099_19/bi.1012/b14048.pdf, http://docs.oracle.com/cd/E15523_01/bi.1111/b32121/pbr_conf002.htm#i1013352)
- Use symbolic links in order to reduce the length of the directory names and thus, reducing the length of the REPORTS_PATH environment.
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.