REP-52266 - Failed To Start 11g In-Process Report Server after Pointing Credential Key to Another Database for jobRepository (Doc ID 1639869.1)

Last updated on JULY 03, 2017

Applies to:

Oracle Reports Developer - Version 11.1.1.2.0 and later
Information in this document applies to any platform.
Checked for relevance on 01-Dec-2015

Symptoms

Set up jobRepository as part of HA (High Availability) configuration per instructions in:

       What are the Differences Between jobStatusRepository and jobRepository in 11g (Doc ID 1072504.1)

The in-process Reports Servers on both nodes were working fine.

After changing the rep_repository Credential Key to point from Test database to Prod database and bouncing the WLS_REPORTS and WLS_REPORTS1 managed servers, the in-process Reports Server now fails to start with error:

REP-52266: The in-process Reports Server rep_wls_reports_hostname_asinst_1 failed to start.oracle.reports.RWException: IDL:oracle/reports/RWException:1.0

and the rwserver_diagnostic.log shows:

[2014-03-21T14:24:46.064-04:00] [WLS_REPORTS] [INCIDENT_ERROR] [REP-942] [oracle.reports.server] [tid: 11] [userId: systemadm] [ecid: cffe8ad5614b3d48:68afa692:143b5db7ffd:-8000-00000000000659da,0] [APP: reports#11.1.2] REP-942 : java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist[[
 
oracle.reports.RWException: IDL:oracle/reports/RWException:1.0
at oracle.reports.utility.Utility.newRWException(Utility.java:1053)
at oracle.reports.utility.DBConnection.handleSQLException(DBConnection.java:240)
at oracle.reports.server.BLOBHelper.readAll(BLOBHelper.java:451)
at oracle.reports.server.JobStoreDB.readPersistFile(JobStoreDB.java:317)
at oracle.reports.server.RWServer.startServer(RWServer.java:1231)
at oracle.reports.server.RWServer.run(RWServer.java:358)
at java.lang.Thread.run(Thread.java:736)

]]

  

Changes

For jobRepository, changed Credential Key to point to Prod database instead of Test database.

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