SAP Knowledge Base Article - Preview

2511360 - SQL0313N The number of variables in the EXECUTE statement is not equal to the number of values required

Symptom

SUM (SAP Software Upgrade Manager) stopping with the following errors in the following three SUM log files:

  • /.../TABIM_UPG/SAPup.ECO

    2EETW000 SQL error -313 occured: SQL0313N  The number of variables in the EXECUTE statement, the number of variables in the OPEN statement, or the number of arguments in an OPEN statement for a parameterized cursor is not equal to the number of values required.  SQLSTATE=07001
    2EETW000 sap_dext called with msgnr "900": 
    2EETW125 SQL error "-313" during "-313" access: "SQL0313N  The number of variables in the EXECUTE statement, the number of variables in the OPEN statement, or the number of arguments in an OPEN statement for a parameterized cursor is not equal to the number of values required.  SQLSTATE=07001"


  • /.../TABIM_UPG/PHASES.LOG

    3 ETQ121 20170726152525: PID 6836 execute 'F:\usr\sap\EOQ\DVEBMGS04\exe\tp "pf=~\var\TABIMUPG.TPP" put EOQ "-Dmainimp_proc=2" "-Dparallel=3"' in background, output written to 'I:\SUM\abap\log\SAPup.ECO'.
    3WETQ123 20170726152555: PID 6836 exited with status 12 (time    0.00 real)
    1 ETQ124 Scanned file 'log\SAPIE60099.EOQ' from offset 10119980 to 10819035 for errors.
    4EETQ399 Some errors found during the log scan!
    4 ETQ010 Date & Time: 20170726152556  
    1EETQ399 Last error code set is: Detected 1 aborted activities in 'TABIMUPG.ELG'
    1EETQ399XCalling 'F:\usr\sap\EOQ\DVEBMGS04\exe/tp' failed with return code 12, check
    1EETQ399XI:\SUM\abap\log\SAPup.ECO for details
    1EETQ203 Upgrade phase "TABIM_UPG" aborted with errors ("20170726152556")

  • /.../TABIM_UPG/SAPIE60099.EOQ

    4 ETW000 ================== STEP 1 =====================
    4 ETW000 date&time        : 26.07.2017 - 15:25:40
    4 ETW000 function         : IMPORT
    4 ETW000 data file        : I:\SUM\abap\data\RE60099.SAP.reduced
    . . .
    4 ETW000 successfully set a temporary lock on table T52D4
    4 ETW000  [     dev trc,00000]  Wed Jul 26 15:25:47 2017
    4 ETW000  [     dev trc,00000]  *** ERROR in DB6Open[dbdb6.c, 3828] CON = 0 (BEGIN)
    4 ETW000  [     dev trc,00000]  &+     dsql_db6_open( SQLExecute ): [IBM][CLI Driver][DB2/NT64] SQL0313N  The number of variables in the EXECUTE statemen
    4 ETW000  [     dev trc,00000]  &+     t, the number of variables in the OPEN statement, or the number of arguments in an OPEN statement for a parameteri
    4 ETW000  [     dev trc,00000]  &+     zed cursor is not equal to the number of values required.  SQLSTATE=07001                                         
    4 ETW000  [     dev trc,00000]  &+                                                                                                                       
    4 ETW000  [     dev trc,00000]  &+     SELECT VIEWFIELD,TABNAME,FIELDNAME FROM DD27S WHERE AS4LOCAL = ? AND VIEWNAME =  ?                                
    4 ETW000  [     dev trc,00000]  &+       cursor type=NO_HOLD, isolation=UR, cc_release=YES, optlevel=5, degree=1, op_type=18, read_only=0                
    4 ETW000  [     dev trc,00000]  &+                                                                                                                       
    4 ETW000  [     dev trc,00000]  &+     Input SQLDA:                                                                                                      
    4 ETW000  [     dev trc,00000]  &+                        1 CT=WCHAR           T=VARCHAR         L=2     P=3     S=0    
    4 ETW000  [     dev trc,00000]  &+                                                                                                                       
    4 ETW000  [     dev trc,00000]  &+     Input data:                                                                                                       
    4 ETW000  [     dev trc,00000]  &+     row 1:             1 WCHAR           I=2       "A"
    4 ETW000  [     dev trc,00000]  &+                                                                                                                       
    4 ETW000  [     dev trc,00000]  &+                                                                                                                       
    4 ETW000  [     dev trc,00000]  *** ERROR in DB6Open[dbdb6.c, 3828] (END)
    4 ETW000  [    dbds    ,00000]  ***LOG BY2=>sql error -313 performing OPC
    4 ETW000  [    dbds    ,00000]  ***LOG BY0=>SQL0313N  The number of variables in the EXECUTE statement, the number of variables in the OPEN statement, or the number of arguments in an OPEN statement for a parameterized cursor is not equal to the number of values required.  SQLSTATE=07001


Read more...

Environment

SUM
DB2 LUW
R3trans.exe version 6.24 (release 722 - 18.01.17 - 20:17:01)

Product

SAP ERP 6.0

Keywords

TABIM UPG SAPup ECO EXECUTING sap EOQ DVEBMGS exe tp EXE pf SUM abap var TABIMUPG TPP mainimp_proc parallel usr sap Looking for effective putsteps ready looking unicode enabled version child process terminated setting rc this import portion SQL error -313 occured SQL0313N  The number of variables in the EXECUTE statement the number of variables in the OPEN statement or the number of arguments in an OPEN statement for a parameterized cursor is not equal to the number of values required SQLSTATE 07001 sap_dext called with msgnr 900 during access R3trans R3trans.exe finished (0012) PHASES LOG PHASES.LOG log SAPup.ECO Scanned file SAPIE60099.EOQ Last error code set is Detected 1 aborted activities in TABIMUPG.ELG Upgrade phase errors data file RE60099.SAP.reduced ERROR in DB6Open dbdb6.c dsql_db6_open SQLExecute IBM CLI Driver DB2 NT64 sql performing OPC missing return code handler caller does not handle code 256 from dbdsqln#1[377] calling to abort transaction
DB6 DB2 LUW SUM MAIN_NEWBAS TABIM_UPG , KBA , BC-UPG-TLS-TLA , Upgrade tools for ABAP , BC-DB-DB6 , DB2 Universal Database for Unix / NT , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.