SSP_ins_wo_hdr Failed: With Error Literal Does Not Match Format String (Doc ID 1323474.1)

Last updated on MAY 28, 2013

Applies to:

Oracle Communications ASAP - Version 5.2.4 and later
Information in this document applies to any platform.
***Checked for currency on 28-May-2013***

Symptoms

The SARM terminated with SYS_TERM Event and unable to process work order. Created PL/SQL statement as follows:

begin :retval
ak_stat,:command,:asdl_timeout,:parent_wo,:wo_timeout,:asdl_retry_num,:asdl_r
etry_int,:wo_rback,:stub_update_req,:asdl_delay_fail,:max_delay_fail,:srq_id,
:batch_group,:extsys_id,:rtn_val); end;
145125.440:7: LOW:ASC_cprpcexec() :1510:control/libasc/ctlib.c
RPC(log_event) Complete in 27ms, First Result in 27ms
145125.446:49:PROG:check_status :1682:control/libasc/ocilib.c
Error: OCIStmtExecute [ORA--1] Failure...

145125.446:49:PROG:checkerr :1828:control/libasc/ocilib.c
Error - ORA-01861: literal does not match format string
ORA-06512: at line 1
errcode[1861]
145125.446:49:SANE:ASC_cprpcexec_nobind() :3400:control/libasc/ctlib.c
Error: RPC SSP_ins_wo_hdr failed
145125.446:49:PROG:System Event 
:1795:sarm/sarm/sarm/wo_handler.c
ASAP System Event: SYS_ERR
WO: OSM.7845.316449, RPC [SSP_ins_wo_hdr] Failed
....
....
Created PL/SQL statement as follows : begin :retval
:=SSP_insert_wo_event(:wo_id,:event_unid,:event_type,:event_status,:srp_id,:e
vent_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,:n
ew_wo_stat,:status,:extsys_id,:rollback_exceptions); end;
145125.449:49:PROG:check_status :1682:control/libasc/ocilib.c
Error: OCIStmtExecute [ORA--1] Failure...

145125.450:49:PROG:checkerr :1828:control/libasc/ocilib.c
Error - ORA-01861: literal does not match format string
ORA-06512: at line 1
errcode[1861]
145125.450:49:SANE:ASC_cprpcexec_nobind() :3400:control/libasc/ctlib.c
Error: RPC SSP_insert_wo_event failed
145125.450:49:PROG:System Event 
:4312:sarm/sarm/sarm/srp_driver.c
ASAP System Event: SYS_TERM
Error: RPC 'SSP_insert_wo_event' Failed for WO OSM.7845.316449
145125.469:7: LOW:ASC_cprpcexec() :1510:control/libasc/ctlib.c
RPC(log_event) Complete in 23ms, First Result in 23ms
145125.470:7: LOW:RPC Param :1377:control/libasc/ctlib.c
Sending er.c
3 : reason = Error: RPC 'SSP_insert_wo_event' Failed =
1
145125.483:7: LOW:ASC_cprpcexec() 
:1510:control/libasc/ctlibver.c
Application SARMdev1 Terminating Due to SYS_TERM Event

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