Application Going Down With CSP_update_proc_info Failed Error (Return Status = -100)
(Doc ID 1470009.1)
Last updated on JULY 23, 2018
Applies to:Oracle Communications ASAP - Version 5.2.4 to 7.2.0 [Release 5.2 to 7.2]
Information in this document applies to any platform.
ASAP is going down with CSP_update_proc_info Failed error (Return Status = -100)
We are trying to create one environment Database/App on a different server by exporting ASAP Schema's from existing one. But when starting the application, it is running fine, but it is shutting down after running with the following error:
Need to undestand what the function CSP_update_proc_info does? What values does it get?
We could see that it uses an internal Sequence IDENTITY and when running the following command:
SELECT * FROM dba_sequences WHERE sequence_owner IN ('CTRLDEV4')
we are getting the following values:
And SELECT MAX(proc_identity) FROM ctrldev4.tbl_process_info gives me 453095.
The value of sequnce is higher than the what is there in the table Process info. We are still not able to understand why the application is going down.
Created PL/SQL statement as follows : begin :retval :=CSP_update_proc_info(:appl_cd,:sys_events,:user_cpu,:system_cpu); end;
>> 035938.012:11: LOW:ASC_ociparse :528 :control/libasc/ocilib.c
Successfully parsed PLSQL block cursor
>> 035938.036:11: LOW:ASC_cprpcexec() :1186:control/libasc/ctlib.c
RPC CSP_update_proc_info return status = -100
>> 035938.037:11:SHUT:System Event :257 :control/libcontrol/ctrl_agent.c
Error: RPC 'CSP_update_proc_info' Failed
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document