CTRL Server : ORA-01405 Error (Doc ID 949449.1)

Last updated on OCTOBER 04, 2016

Applies to:

Oracle Communications ASAP - Version 4.2.0 and later
Information in this document applies to any platform.
***Checked for relevance on 15-November-2013***

Symptoms

This is a fatal error that occurs when starting the CTRL server (either by itself – starts (-d) $CTRL), or as part of the series of ASAP servers starting when using the standard ASAP startup script start_asap_sys (-d). This could occur at any point during development.

Here, the CTRL server can't start up. Since this is the 1st ASAP server to start in sequence, ASAP won't start.

$ start_asap_sys -d
Starting Master Control Server CTRLDV01...
Failed to start Master Control Server CTRLDV01

In the CTRL server dialogue file – CTRL${ENV_ID}.diag …

...<cut>...

Connection established to Oracle Server with user ctrlDV01 and connection ASAPDV
> />195135.173:55: LOW:ASC_ociopen :123 :ocilib.c
Connection set to non-blocking for user ctrlDV01
> />195135.173:55: LOW:ASC_ociopen :135 :ocilib.c
Successfully got the file descriptor for the connection [27]
> />195135.173:55: LOW:ASC_ociopen_cursor :321 :ocilib.c
Successfully opened cursor
> />195135.173:55: LOW:ASC_ociopen :147 :ocilib.c
Configuring Oracle session profile
> />195135.173:55: LOW:ASC_ociparse :432 :ocilib.c
Successfully parsed PLSQL block cursor
> />195135.173:55: LOW:Initialization :966 :main.c
Application Server Initialization Wait Complete
> />195135.173:55:SANE:Thread Start :346 :asc_spawn.c
Startup of Thread [Timer 1], MsqQ [], MsgQId [-1]
> />195135.174:57: LOW:Initialization :966 :main.c
Application Server Initialization Wait Complete
> />195135.174:57:SANE:Thread Start :346 :asc_spawn.c
Startup of Thread [Connection Check], MsqQ [], MsgQId [-1]
> />195135.174:57: LOW:ASC_ociparse :432 :ocilib.c
Successfully parsed PLSQL block cursor
> />195135.175:64: LOW:ASC Process Init :711 :asc_spawn.c
Application Initialization of Thread CTRLDV01- (CTRLDV01)
> />195135.176:64: LOW:Client Connection :1699:main.c
Connection Received from Client Application:
User [ctrlDV01], [********] Machine/Server [CTRLDV01-C] Appl [CTRLDV01]
> />195135.176:50: LOW:ASC_ocicreate_cmd :517 :ocilib.c
Created PL/SQL statement as follows : begin :retval :=CSP_list_centers(:curs); end;
> />195135.176:50: LOW:ASC_ociparse :432 :ocilib.c
Successfully parsed PLSQL block cursor
> />195135.177:20:SANE:ORACLE ERROR :1130:ocilib.c

-- ORACLE error when processing OCI function OEXEC, OEXN


> />195135.177:20:SANE:ORACLE ERROR :1138:ocilib.c
error message ORA-01405: fetched column value is NULL


> />195135.177:20: LOW:ASC_cprpcexec() :875 :ctlib.c
RPC CSP_get_master failed
> />195135.177:20:SHUT:Control Agent :151 :ctrl_agent.c
Error: 'CSP_get_master' RPC Failed

Checking the Oracle error code (rc = 1405) for this specific error, you can see that it is in response to the empty column in the table.

$ oerr ora 01405
\01405, 00000, "fetched column value is NULL"
// *Cause:
// *Action:

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