Reports With Attached PLX Causes Reports Server Hangs/Crashes Intermittently or REP-770 / REP-736 / REP-1247
Last updated on MARCH 08, 2018
Applies to:Oracle Reports Developer - Version 10.1.2.0.2 to 11.1 [Release Oracle10g to 11g]
Information in this document applies to any platform.
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:
The PL/SQL will be recompiled.
REP-0736: There exist uncompiled program unit(s).
REP-1247: Report contains uncompiled PL/SQL.
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.
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