Work Orders with Invisable Characters in Work Order ID (Primary Key) Resulted In SARM Crash. (Doc ID 1613341.1)

Last updated on JANUARY 14, 2014

Applies to:

Oracle Communications ASAP - Version 7.0.2 and later
Information in this document applies to any platform.

Symptoms

Orders were submitted with a primary key that had some invisiable characters in it.

For example, Work Orders ID is in (Rem_07082013_?????????????????????_NCD) format, the spaces are converted to ? and is successfully inserted into tbl_wrk_ord. After triggering the above order, SARM crashed within 5 minutes.

ERROR
-----------------------


Aug 7 18:39:20 2013: Error - errcode[0]
Aug 7 18:39:20 2013: ASAP System Event: SYS_TERM
Error: RPC 'SSP_insert_wo_event' Failed for WO Rem_test1_61455533271 _NCD
Aug 7 18:39:24 2013: Application SARMPS06 Terminating Due to SYS_TERM Event
Error: RPC 'SSP_insert_wo_event' Failed for WO Rem_test1_61455533271 _NCD
Aug 7 18:40:29 2013: SARMPS06: Msg 0 Severity 0 State 1 Server 'CTRLPS06' Proc '' @ 0
'Successful Connection to CTRLPS06 (100)'
Aug 7 18:40:29 2013: ASAP System Event: SYS_INFO


1 : appl_cd = SARMPS06
2 : file = sarm/sarm/sarm/wo_handler.c
3 : reason = WO: Rem_test1_61455533271 _NCD, RPC [SSP_ins_wo_hdr] Failed
4 : line = 1866
5 : event = SYS_ERR
6 : event_log = 1
>> 183920.164:75: LOW:ASC_ociclose :325 :control/libasc/ocilib.c
OCI8 Session closed
>> 183920.164:75:PROG:System Event :1378:sarm/sarm/sarm/srp_driver.c
ASAP System Event: SYS_INFO
Memory Pool 'CS_BYTE[2048] (Base)' used up, Resizing by 32 blocks to 64 blocks
>> 183920.164:74:SANE:WO Commit RPC :3875:sarm/sarm/sarm/wo_handler.c
Commit Complete for WO Rem_test1_61455533271 _NCD, Status = 101
>> 183920.165:75: LOW:WO Notification :4274:sarm/sarm/sarm/srp_driver.c
WO: Rem_test1_61455533271 _NCD, Placing WO Accept Notification in Queue
>> 183920.165:75: LOW:ASC_cppalloc :348 :control/libcontrol/ctlib.c
Successfully obtained a Session from the Pool
>> 183920.165:75: LOW:ASC_cprpcexec_nobind() :3563:control/libasc/ctlib.c
Executing RPC [SSP_insert_wo_event]. Retry Count [0]
>> 183920.165:75: LOW:ASC_ocicreate_cmd :651 :control/libasc/ocilib.c
Created PL/SQL statement as follows : begin :retval :=SSP_insert_wo_event(:wo_id,:event_unid,:event_type,:event_status,:srp_id,:event_dts,:estimate,:misc,
:rev_flag,:exceptions,:mach_clli,:host_clli,:reason,:csdl_seq_no,:csdl_id,:timeout_status,:queue_tm,:xaction_type,:old_wo_stat,:new_wo_stat,:status,:extsy
s_id,:rollback_exceptions); end;
>> 183920.165:75: LOW:ASC_ociStmtPrepare :920 :control/libasc/ocilib.c
Search of PLSQL cache - idx: 5
>> 183920.175:75: LOW:ASC_cprpcexec_nobind() :3731:control/libasc/ctlib.c
RPC SSP_insert_wo_event return status = -100
>> 183920.175:75:PROG:checkerr_returning_errcod:2473:control/libasc/ocilib.c
Error - errcode[0]
>> 183920.175:75:PROG:System Event :4330:sarm/sarm/sarm/srp_driver.c
ASAP System Event: SYS_TERM
Error: RPC 'SSP_insert_wo_event' Failed for WO Rem_test1_61455533271 _NCD




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