search cancel

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

book

Article ID: 90136

calendar_today

Updated On:

Products

CA Automic Applications Manager (AM)

Issue/Introduction

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

Environment

Release: AAMOS499000-8.0-Automic Applications Manager-OS400 Agent
Component:

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.