Issue running Oracle Reports After upgrade from v6.x to v8.x

Document ID : KB000090136
Last Modified Date : 14/04/2018
Show Technical Document Details
Issue:
Issue running Oracle Reports After upgrade from v6.x to v8.x
Resolution:
Detailed Description and Symptoms

the awrun script can be run from the command line and produces the report. When it is run through Applications Manager V8.0x however the report is not actually generated.

 

In the Output file of the job you will see similar:

D:\appworx\agent\run>call D:\appworx\agent\exec\aw_free_space D:\appworx\agent\tmp\dspace_4114931.00
disk_space=9598590976
M_SRWP starting at Wed 08/18/2010  8:22:33.77
In srwp.bat - Oracle Reports 10g
rwclient options:
The system cannot find the file specified.
rwrun userid=aw_bac/password cmdfile=pr2765546.bat1
NTSPAWN pid 2748:abc
JOBID 4114931.00
 

 


Investigation

The reason this issue occurs after upgrading is because all jobs now inherit a java environment from the AgentService.
The old "c" Agent just had the environment from running the sosite file.
?


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.