Installing CM Patch May Require Manual IPSA DB Package Drop (Doc ID 1069884.1)

Last updated on AUGUST 21, 2016

Applies to:

Oracle Communications Configuration Management - Version: 5.2.3 - Release: 5.2
Information in this document applies to any platform.

Symptoms

When a CM / IPSA patch is applied there may be a need to also manually drop an IPSA DB package as there is a fix for <<Bug 8870450>> which requires this. Indication of this being required is the presence of the following error in the NP log or a on-demand or scheduled archive.

20100119-073008|926|ERROR|Thread-6||||proxy_np|kronwandl|Problem while trying to write the device changes information to the database
java.sql.SQLException: ORA-06550: line 1, column 7:
PLS-00306: wrong number or types of arguments in call to 'WRITE_DEVICE_CHANGE'
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

       at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:125)
       at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:700)
       at oracle.jdbc.driver.T2CConnection.checkError(T2CConnection.java:632)
       at oracle.jdbc.driver.T2CCallableStatement.execute_for_describe(T2CCallableStatement.java:847)
       at oracle.jdbc.driver.T2CCallableStatement.execute_for_rows(T2CCallableStatement.java:1010)
       at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1086)
       at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:2984)
       at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3057)
       at oracle.jdbc.driver.OracleCallableStatement.executeUpdate(OracleCallableStatement.java:4296)
       at com.metasolv.serviceactivator.util.database.DatabaseUtil.updateDeviceHadChanges(DatabaseUtil.java:249)
       at com.metasolv.serviceactivator.networkprocessor.CommitQueueAuditItem.updateDeviceChangeInfo(CommitQueueAuditItem.java:215)
       at com.metasolv.serviceactivator.networkprocessor.CommitQueueAuditItem.run(CommitQueueAuditItem.java:88)
       at com.metasolv.serviceactivator.util.ThreadPool$PoolThread.run(ThreadPool.java:152)


Changes

Recent application of IPSA / CM patch. Specifically CM 5.2.4 patch 1

Cause

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