Unable Add Sub-ports On Spec Already Installed ORA-06512: At "ASAP.SP_SPEC_UPDATE_PORTADDR",line 101 (Doc ID 1463632.1)

Last updated on JULY 30, 2012

Applies to:

Oracle Communications MetaSolv Solution - Version 6.2.0 and later
Information in this document applies to any platform.

Symptoms

Receive the error when try to add Sub-ports on an Equipment Specification that is already installed. While adding new ports we get error :

 

sqlerror:1
java.sql.BatchUpdateExecption: ORA-01403: no data foundORA-06512: at
"ASAP.SP_SPEC_UPDATE_PORTADDR",line 101ORA-06512:at
"ASAP.TR_SPEC_PORT_ADDRESS", line 18ORA-04088: error during execution of trigger
'ASAP.TR_SPEC_PORTADDRESS'


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