SARM Error: Can't Save SRQ, CSDL Or Aux_wo_prop (Doc ID 1279177.1)

Last updated on JANUARY 05, 2017

Applies to:

Oracle Communications ASAP - Version 4.7.0 to 7.2.0 [Release 4.7 to 7.2]
Information in this document applies to any platform.

Symptoms

SARM Error:

LOW:ASC_cprpcexec_array_nobin:3183:control/libasc/ctlib.c
Executing RPC [SSP_ins_srq_hdr_csdl]. Retry Count [0]
> /> 190425.674:51: LOW:ASC_ociStmtPrepare :920 :control/libasc/ocilib.c
Search of PLSQL cache - idx: 2
> /> 190425.731:51:PROG:checkerr_returning_errcod:2473:control/libasc/ocilib.c
Error - ORA-00001: unique constraint (SARMPROD.IDX1_SRQ) violated
ORA-06512: at "SARMPROD.SSP_UPDATE_SRQ_HDR", line 84
ORA-06512: at "SARMPROD.SSP_INS_SRQ_HDR_CSDL", line 48
ORA-06512: at line 1
errcode[1]
> /> 190425.731:51:PROG:check_status :1801:control/libasc/ocilib.c
Error: OCIStmtExecute [ORA-1] Failure...

> />190425.731:51:SANE:ASC_cprpcexec_array_nobin:3393:control/libasc/ctlib.c
Error: RPC SSP_ins_srq_hdr_csdl failed. Errorcode [1]
> /> 190425.731:51: LOW:ASC_ociclose :303 :control/libasc/ocilib.c
Calling OCIStmtRelease: Stmt 4157ae58
> /> 190425.733:51: LOW:ASC_ociclose :325 :control/libasc/ocilib.c
OCI8 Session closed
> /> 190425.733:51:SANE:Update WO :2270:sarm/sarm/sarm/wo_handler.c
WO: 2546663_27338216 Complete/Failed/Timeout, Revision Received
> /> 190425.733:51:PROG:System Event :2662:sarm/sarm/sarm/wo_handler.c
ASAP System Event: SYS_ERR
WO 2546663_27338216 Error: Can't Save SRQ [724237], CSDL or aux_wo_prop

> />> />> />> />> />> />> />> />

Changes

 

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