IBM Support

webMethods Knowlegebase : ORA-06508: PL/SQL: could not find program unit being called (1807017)

Troubleshooting


Problem

Have setup the Archival for ISCore Audit and Process Audit tables.

The ISCore Audit archival is working as expected, but when trying to archive Process Audit tables, using built-in service pub.monitor.archive:processArchive, getting below errors:

"Error in deleting driver tables and commiting: [Ljava.lang.Object;@4352ebd7

2021-03-19 14:40:28 CET [MOD.0120.0760E] Error in process archiving: java.sql.SQLException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-04063: package body "WMREP_QA_ARCHIVE.PROCESS_ARCHIVE" has errors

ORA-06508: PL/SQL: could not find program unit being called: "WMREP_QA_ARCHIVE.PROCESS_ARCHIVE"

ORA-06512: at line 1

2021-03-19 14:40:28 CET [MOD.0120.0000T] java.sql.SQLException: [SoftwareAG][Oracle JDBC Driver][Oracle]ORA-04063: package body "WMREP_QA_ARCHIVE.PROCESS_ARCHIVE" has errors

ORA-06508: PL/SQL: could not find program unit being called: "WMREP_QA_ARCHIVE.PROCESS_ARCHIVE"

ORA-06512: at line 1"

On checking the Package body from SQL client site finds the below errors associated with Package Body:

"WMREP_QA_ARCHIVE.PROCESS_ARCHIVE

Error(1350,5): PL/SQL: Statement ignored

Error(1370,28): PLS-00302: component 'SYSTEM' must be declared

Error(1398,6): PL/SQL: Statement ignored

Error(1422,34): PLS-00302: component 'SYSTEM' must be declared"

What needs to be done to resolve this issue?

Fix Level:

IS_10.5_Core_Fix6

Monitor 10.5 Fix6

DCC catalog for ARCHIVE

* code version name data

* OPM 9.0.1 OperationManagement TS_WMREP,TS_WMREP *

* ISC 10.3 ISCoreAudit TS_WMREP,TS_WMREP

* PRA 10.5.fix1 ProcessAudit TS_WMREP,TS_WMREP

* ARC 10.5.fix1 Archive TS_WMREP,TS_WMREP

Document Location

Worldwide

[{"Line of Business":{"code":"LOB76","label":"Data Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSAWP1J","label":"IBM webMethods BPM"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"webMethods Monitor (WMN)"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Red Hat Enterprise Linux"}],"Version":"10.5"},{"Line of Business":{"code":"LOB77","label":"Automation Platform"},"Business Unit":{"code":"BU048","label":"IBM Software"},"Product":{"code":"SSFIWYE","label":"IBM webMethods B2B"},"ARM Category":[{"code":"a8mKe00000000AQIAY","label":"webMethods Monitor (WMN)"}],"ARM Case Number":"","Platform":[{"code":"PF025","label":"Red Hat Enterprise Linux"}],"Version":"10.5"}]

Log InLog in to view more of this document

This document has the abstract of a technical article that is available to authorized users once you have logged on. Please use Log in button above to access the full document. After log in, if you do not have the right authorization for this document, there will be instructions on what to do next.

Document Information

Modified date:
20 March 2025

UID

ibm17202840

Page Feedback