Unable to run oracle reports

Products

• CA Automic Applications Manager (AM)

Issue/Introduction

Unable to run oracle reports

Environment

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

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.