SAP Knowledge Base Article - Preview

3101468 - DB6: Cube compression job fails due to mismatched number of parameter markers

Symptom

Info cube compression job fails due to following error found in the work process trace.

C Thu Sep 18 18:18:36:120 2021
C  *** ERROR in DB6Execute[/bas/749_REL/src/dbs/db6/dbdb6.c, 5071] CON = 1 CACHEID = 9 (BEGIN)
C  &+***      dsql_db6_exec: Number of input parameters does not match the number of parameter markers ( 3 parameters; 2 markers).
C  &+***
C  &+***      INSERT INTO "/BI0/0100000088"("KEY_ABC1008P","KEY_ABC1008T","KEY_ABC1008U","KEY_ABC10081","KEY_ABC10082","KEY_ZMV1
C  &+***      0073","KEY_ABC10084","KEY_ABC10085","KEY_ABC10086","KEY_ABC10087","KEY_ABC10088","KEY_ABC10089","KEY_ABC1008A"

<snipped>

C  &+***      = E."KEY_ABC1008D" AND E."KEY_ABC1008P" = ?
C  &+***        cursor type=NO_HOLD, isolation=UR, cc_release=NO, optlevel=5, degree=-1, op_type=15, read_only=0
C  &+***
C  &+***      ABAP location info 'CL_SQL_STATEMENT==============CP', 1157
C  &+***
C  *** ERROR in DB6Execute[/bas/749_REL/src/dbs/db6/dbdb6.c, 5071] (END)


Read more...

Environment

  • SAP BW on IBM Db2 for Linux and UNIX
  • SAP kernel version equal or higher than 7.45

Keywords

Cube, compression, number, input parameters, match, parameter markers , KBA , BW-SYS-DB-DB6 , BW DB2 Universal Database , 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 for Me (Login required).

Search for additional results

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