My Oracle Support Banner

Reports With Attached PLX Causes Reports Server Hangs/Crashes Intermittently or REP-770 / REP-736 / REP-1247 (Doc ID 1232385.1)

Last updated on JANUARY 08, 2024

Applies to:

Oracle Reports Developer - Version 10.1.2.0.2 and later
Oracle Forms for OCI - Version 12.2.1.4.0 and later
Information in this document applies to any platform.

Symptoms

Intermittently, reports are hanging, they are queued up. If the end user re-executes them, sometimes they work again. It does not follow a specific pattern to be reproduced. Showjobs URL just displays in "current jobs" the status "Opening report". Other reports fail intermittently with error:


REP-770: One or more PL/SQL libraries have been modified since the report was saved.
The PL/SQL will be recompiled.

REP-0736: There exist uncompiled program unit(s).

REP-1247: Report contains uncompiled PL/SQL.



"Terminated with error: <br>REP-770: 'beforepform': Fatal PL/SQL error occurred. ORA-06508: PL/SQL: could not find program unit being called"



REP-770: There exist uncompiled program unit(s).


Resubmitting the same report with the same parameters will sometimes work. If not, it is necessary to stop and restart the reports server.

It is just reproducible in the Production environment, where more reports are executed per minute.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


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