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 ONE Support launchpad (Login required).

Search for additional results

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