Skip to Content
author's profile photo Younus Mohammed
0
Younus Mohammed
Apr 24, 2013 at 01:29 PM

Package Discarded and Invalidated:SAP PI JDBC error

184 Views

Hi all,

For a particular interface (ECC-->SAP PI-->Oracle DB).With receiver JDBC adapter, we are invoking Stored Procedures at DB for updating the interface data. We have been facing issues, where the receiver JDBC adapter says “

: ORA-04068: existing state of packages has been discarded,ORA-04061: existing state of package body "DB.PackageName.StoredProcName" has been invalidated ORA-04065: not executed, altered or dropped package body " DB.PackageName.StoredProcName" ORA-06508: PL/SQL: could not find program
unit being called: " DB.PackageName.StoredProcName" ORA-06512: at line 1.

Steps taken till now:

  1. Checked with DBA team to see if the relevant packages are in “INVALID”or “Un-compiled” state. The answer was NO.
  2. Stopping and Starting the receiver channels did resolve the issue initially but today again we have the same error.
  3. Checked with DB Dev team as well,to see if there were any deployments/installations done at their side, which might have an impact on the stored procedures/packages. The answer was NO.
  4. When the packages or Stored Procedure are run on the DB there is no issue.

We have observed this issue to be intermittent. If any of you have encountered this before or can throw some light on how to get this resolved,it would be appreciated.

Thank you!!

regards,

Younus