Application Going Down With CSP_update_proc_info Failed Error (Return Status = -100) (Doc ID 1470009.1)

Last updated on JULY 10, 2012

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.

Symptoms


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:
CTRLDEV4,IDENTITY,1,1E20,1,N,N,20,453103

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.

ERROR
-----------------------
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

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