My Oracle Support Banner

REP-300: Oci_invalid_handle / REP-501 Reports Engine Crash (Doc ID 1270315.1)

Last updated on JANUARY 12, 2018

Applies to:

Oracle Reports Developer - Version 11.1.1.2.0 and later
Microsoft Windows Itanium (64-bit)
Microsoft Windows x64 (64-bit)
Linux x86-64

Symptoms

Sometimes a report job failed with the following error :REP-300/REP-501.
The behavior is random when generating the reports.
The problem happens for reports started via forms/run_report_object or using "rwservlet"  with desformat PDF, destype cache or file.

After the first reports job has crashed, all following jobs of any kind return with error REP-501, so the engine cannot connect to the DB anymore till you restart the reports server or engLife is reached and the engine is restarted.

Possible error message is :

REP-300: OCI_INVALID_HANDLE. ==> select .....

 

Common possible errors that can be found in diagnostic log files are : REP-300 : OCI_INVALID_HANDLE, REP-0501, and ORA-00002

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!

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