Unable To Start SARM Server With Error ORA-01455: Converting Column Overflows Integer Datatype (Doc ID 1062553.1)

Last updated on JULY 11, 2016

Applies to:

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

Symptoms

Unable to start SARM server and we are getting following error in SARM diag file:

162437.936:87: LOW:ASC Process Init :718 :control/libcontrol/asc_spawn.c
Application Initialization of Thread JSRPbulk SRP Drv
>> 162437.937:88: LOW:ASC Process Init :718 :control/libcontrol/asc_spawn.c
Application Initialization of Thread JSRPbulk SRP Drv
>> 162437.938:6: LOW:ASC_cprpcexec() :1294:control/libasc/ctlib.c
RPC(SSP_srp_list) Complete in 34ms
>> 162437.938:6:PROG:ASC_cprpcexec() :1049:control/libasc/ctlib.c
Processing RPC [SSP_select_pending]
>> 162437.938:6: LOW:ASC_ociopen_cursor :417 :control/libasc/ocilib.c
Successfully opened cursor
>> 162437.938:6: LOW:ASC_ocicreate_cmd :613 :control/libasc/ocilib.c
Created PL/SQL statement as follows : begin :retval :=SSP_select_pending(:curs,:wo_id); end;
>> 162437.938:6: LOW:ASC_ociparse :528 :control/libasc/ocilib.c
Successfully parsed PLSQL block cursor
>> 162438.069:6:PROG:ORACLE ERROR :1444:control/libasc/ocilib.c

-- ORACLE error OFETCH, OFEN

>> 162438.070:6:PROG:ORACLE ERROR :1448:control/libasc/ocilib.c
error message ORA-01455: converting column overflows integer datatype


>> 162438.070:6:PROG:ASC_ocifetch :1309:control/libasc/ocilib.c
ASC_ocifetch Failed
>> 162438.070:6:SANE:SRP Driver Select Pending:1898:sarm/sarm/sarm/srp_driver.c
Fetch failed - rows fetched = 15
>> 162438.070:6:PROG:ASC_cprpcexec() :1246:control/libasc/ctlib.c
Error while performing handler
>> 162438.071:6:PROG:System Event :1986:sarm/sarm/sarm/srp_driver.c
ASAP System Event: SYS_TERM
Error: RPC 'SSP_select_pending' Failed
>> 162442.071:6:SHUT:System Event :1986:sarm/sarm/sarm/srp_driver.c
Application SARMbulk Terminating Due to SYS_TERM Event
Error: RPC 'SSP_select_pending' 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