2902121 - Job DBA!UPDATE_RECO failure with CALL_FUNCTION_PARM_UNKNOWN runtime error and dump

You observe ST22 dumps coinciding with the execution of transaction code DB13 job 'Update reorg,stats,copy recommendations'.  Similar error conditions are also reported in SM21 and Developer Traces.

ST22 dump
---------------------------------------------------------------------------------------------------
Category ABAP Programming Error

Runtime Errors CALL_FUNCTION_PARM_UNKNOWN
Except. CX_SY_DYN_CALL_PARAM_NOT_FOUND
ABAP Program SAPLS_CCDSNU_DB2
Application Component BC-DB-DB2
Date and Time 03/10/2020 03:14:36
----------------------------------------------------------------------------------------------------
Short text
 Function parameter "SQLERR_REF" is unknown.
----------------------------------------------------------------------------------------------------
What happened?
 Error in the ABAP Application Program

 The current ABAP program "SAPLS_CCDSNU_DB2" had to be terminated because it has
 come across a statement that unfortunately cannot be executed.

 Function module "DBSYCHK_GET_DB_RELEASE" was called
 with the parameter "SQLERR_REF".
 This parameter is not defined.
---------------------------------------------------------------------------------------------------

Information on where terminated
Termination occurred in the ABAP program "SAPLS_CCDSNU_DB2" - in
"CCDSNU_CALL_DSNACCOX".
The main program was "RSDB2J00 ".

In the source code you have the termination point in line 180
of the (Include) program "LS_CCDSNU_DB2U22".
The program "SAPLS_CCDSNU_DB2" was started as a background job.
Job Name....... "DBA!UPDATE_RECO_____@031412/2000"
Job Initiator.. "SAPUSER"
Job Number..... 03141300
The termination is caused because exception "CX_SY_DYN_CALL_PARAM_NOT_FOUND"
occurred in
procedure "CCDSNU_CALL_DSNACCOX" "(FUNCTION)", but it was neither handled
locally nor declared
in the RAISING clause of its signature.

The procedure is in program "SAPLS_CCDSNU_DB2 "; its source code begins in line
1 of the (Include program "LS_CCDSNU_DB2U22 ".
--------------------------------------------------------------------------------------------------
Source Code Extract
--------------------------------------------------------------------------------------------------
Line |SourceCde
--------------------------------------------------------------------------------------------------
150| RETURN.
151| ENDIF.
152|
153|* Log Output of DSNACCOX depending on DB2MISC entry
154| SELECT SINGLE thevalue
155| FROM db2misc
156| INTO thevalue
157| WHERE thekey = 'DSNACCOX_TRACE'
158| AND subkey = space."#EC NOTEXT
159|
160| TRANSLATE thevalue TO UPPER CASE."#EC TRANSLANG
161|
162| IF thevalue = 'YES'."#EC NOTEXT
163| dsnaccox_logging = abap_true.
164| CONCATENATE filename '.' sy-datum '_' sy-uzeit INTO filename.
165|
166| CONCATENATE 'Running function' 'CCDSNU_CALL_DSNACCOX'
167| INTO text SEPARATED BY space."#EC NOTEXT
168| APPEND text.
169| PERFORM start_log TABLES text USING filename.
170|
171| CLEAR text. REFRESH text.
172| CONCATENATE 'CON_NAME' con_name INTO text SEPARATED BY space."#EC NOTEXT
173| APPEND text.
174| CONCATENATE 'QUERYTYPE' querytype INTO text SEPARATED BY space."#EC NOTEXT
175| APPEND text.
176| PERFORM log_activity TABLES text USING filename.
177| ENDIF.
178|
179|* Get DB Release
>>>>>| CALL FUNCTION 'DBSYCHK_GET_DB_RELEASE'
181| EXPORTING
182| CON_NAME = con_name
183| IMPORTING
184| RELEASE = db2release
185| SQLERR_REF = delerr_ref
186| EXCEPTIONS
187| ADBC_SQL_ERROR = 1
188| OTHERS = 2.
189| IF sy-subrc <> 0.
190| message = selerr_ref->sql_message.
191| RAISE SQL_ERROR.
192| ENDIF.
193|
194|* Check if DSNACCOX exists
195| sp_name = 'DSNACCOX'."#EC NOTEXT
196| IF con_name = SPACE.
197| perform check_stoproc_exists using sp_name
198| changing sp_exists message_text.
199| ELSE.
--------------------------------------------------------------------------------------------------

SM21 System Log
--------------------------------------------------------------------------------------------------
03:14:36 BTC 069 400 D3 2 Reason: Error executing stored procedure DSNACCOX - SQLCODE: 0 MSG:
--------------------------------------------------------------------------------------------------

Developer Trace dev_w
--------------------------------------------------------------------------------------------------
C Tue Mar 10 03:14:36 2020
C *** ERROR => ERROR: wrong number of output parameters; 53 expected, 50 available
--------------------------------------------------------------------------------------------------

Read more...

• SAP Netweaver 7.00 and later
• Db2 z/OS any version

SAP NetWeaver 7.0 ; SAP NetWeaver 7.1 ; SAP NetWeaver 7.2 ; SAP NetWeaver 7.3 ; SAP NetWeaver 7.4 ; SAP NetWeaver 7.5 ; SAP enhancement package 1 for SAP NetWeaver 7.0 ; SAP enhancement package 1 for SAP NetWeaver 7.3 ; SAP enhancement package 2 for SAP NetWeaver 7.0 ; SAP enhancement package 3 for SAP NetWeaver 7.0

Dbacockpit CCMS DBA Planning Calender BW Business Warehouse Short Dump SM37 DTP job Conversion Tool , KBA , BC-DB-DB2-CCM , DB2 for z/OS - CCM/Database monitors , Problem