My Oracle Support Banner

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 MAY 15, 2023

Applies to:

Oracle Reports Developer - Version 11.1 to [Release 11g]
Information in this document applies to any platform.


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 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: <ecid>] [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(
at oracle.reports.utility.DBConnection.handleSQLException(
at oracle.reports.server.BLOBHelper.readAll(
at oracle.reports.server.JobStoreDB.readPersistFile(
at oracle.reports.server.RWServer.startServer(




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


To view full details, sign in with your My Oracle Support account.

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

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.