Cannot View Oracle Reports "Failed Jobs" and "Long Running Jobs" in EM Console (Doc ID 1474872.1)

Last updated on JULY 05, 2016

Applies to:

Oracle Reports Developer - Version 11.1.1.6.0 and later
Information in this document applies to any platform.

Symptoms

 When checking "Failed Jobs" or "Long Running Jobs" under Reports Server in EM Console, receive the following error message :

 Even followed the solution which is provided from <Note 1453938.1> "Cannot View Failed Report Jobs In Enterprise Manager". That is:

      * Remove the <repserver_name>.dat

However, the problem still existed.

Changes

 Using jobStatusRepository and jobRepository in Reports Server's rwserver.conf file :

<jobStatusRepository class="oracle.reports.server.JobRepositoryDB">
       <property name="dbpassword" value="csf:reports:queuePassword"/>
       <property name="dbconn" value="metat"/>
       <property name="dbuser" value="rep_queue_d"/>
   </jobStatusRepository>


   <jobRepository>
       <property name="dbpassword" value="csf:reports:queuePassword"/>
       <property name="dbconn" value="metat"/>
       <property name="dbuser" value="rep_queue_d"/>
   </jobRepository>

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms