Unable to run oracle reports

Document ID : KB000089173
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Unable to run oracle reports
Resolution:
Detailed Description and Symptoms

After upgrading to version 8.0 your Oracle report modules do not work as expected. The job completes within Applications Manager but does not execute the job in Oracle reports. Either that or you may receive a java heap error and the job only runs via command line.


Investigation

This happens when you call awrun on a Windows machine to actually execute the report from Applications Manager. We do not report an error but if you go to the windows server itself you will notice the following error or similar:

 

Faulting application awrun.exe, version 0.0.0.0, faulting module utj90.dll, version 9.0.4.0, fault address 0x0000138a.


Solution

-unsetting CLASSPATH

-create a prefix script for those specific jobs that will unset the CLASSPATH

-create a specific program type that satisfies the needs of running the oracle report jobs.