After 5000 Orders Getting Error In SARM Diag: RPC [SSP_ins_wo_hdr] Failed

(Doc ID 1067354.1)

Last updated on OCTOBER 09, 2012

Applies to:

Oracle Communications ASAP - Version 4.6.0 to 7.0.0 [Release 4.6 to 7.0.0]
Information in this document applies to any platform.

Symptoms

ASAP was unable to process WOs after processing a certain number of WOs (e.g. 5000 WOs) and error message appears in the SARM.

In SARM diag:

>> 093918.291:7: LOW:ASC_ociclose             :325 :control/libasc/ocilib.c
OCI8 Session closed
>> 093918.291:192:PROG:System Event             :2071:sarm/sarm/sarm/wo_handler.c
ASAP System Event: SYS_ERR
WO:'867689736-0000000001' Is In The Unknown State [0]. Failing WO with ASAP_STAT_DB_ERROR.
>> 093918.291:151: LOW:ASC_ociclose             :325 :control/libasc/ocilib.c
:
>> 093918.332:181: LOW:ASC_cprpcexec_nobind()   :3764:control/libasc/ctlib.c
RPC Unknown return Value for Stored Proc SSP_ins_wo_hdr , [1536]
>> 093918.332:181: LOW:ASC_cprpcexec_nobind()   :3807:control/libasc/ctlib.c
RPC(SSP_ins_wo_hdr) Complete in 30ms
:
ASAP System Event: SYS_ERR
  WO: 11915948-0000000001, RPC [SSP_ins_wo_hdr] Failed
  >> 143854.214:200:SANE:Update WO              
  :2270:sarm/sarm/sarm/wo_handler.c
--------------------------------------------

>> 114605.417:180: LOW:ASC_cprpcexec_nobind() :3731:control/libasc/ctlib.c
RPC SSP_ins_wo_hdr return status = -100
>> 114605.417:180:PROG:checkerr_returning_errcod:2473:control/libasc/ocilib.c
Error - errcode[0]
>> 114605.418:180:PROG:System Event :1809:sarm/sarm/sarm/wo_handler.c
ASAP System Event: SYS_ERR
WO: 12385750-0000000001, RPC [SSP_ins_wo_hdr] Failed

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