SAP Knowledge Base Article - Preview

2678758 - DB6: SQL1666N error in CCMS_BI_SETUP job

Symptom

In your Solution Manager system, BI content activation job CCMS_BI_SETUP fails.

In the job log, you find the following SQL1666N error:

=> SM37

06.08.2018 06:08:08 ERROR: errors while content activation occured
06.08.2018 06:08:08 ERROR: Error/warning in dict. activator, detailed log > Detail
06.08.2018 06:08:08 ERROR: The SQL statement was not executed
06.08.2018 06:08:08 ERROR: Table /BI0/D0SM_ESRADP (Error adjusting the database)

The object activation log gives more detailed information.

SE11 => Table name (i.e. /BI0/D0SM_ESRADP) => Display => Utilities => Activation Log.


Table /BI0/D0SM_ESRADP must be created in the database

Adjust table in DB >>>
sql:
CREATE TABLE "/BI0/D0SM_ESRADP"
("DIMID" INTEGER
DEFAULT 0 NOT NULL,
"SID_0CHNGID" INTEGER
DEFAULT 0 NOT NULL,
"SID_0RECORDTP" INTEGER
DEFAULT 0 NOT NULL,
"SID_0REQUID" INTEGER
DEFAULT 0 NOT NULL)
IN "ABC#DIMD" <<< Data tablespace where table is to be created.
INDEX IN "ABC#DIMI" <<< Index tablespace where index is to be created.
LONG IN "ABC#DIMD" <<< Tablespace where long object is to be created.
ORGANIZE BY COLUMN
SQL error -1666: SQL1666N  The table definition statement failed because some functionality was specified 
in the table definition that is not supported with the table type. 
Unsupported functionality: "NON-RECLAIMABLE STORAGE". 
SQLSTATE=42613
DDL Time(___1): ........13 milliseconds
The SQL statement was not executed
Table /BI0/D0SM_ESRADP (Error adjusting the database)


Read more...

Environment

  • IBM Db2 10.5 FP5SAP2 or higher
  • SAP Solution Manager 7.2

Product

SAP Solution Manager 7.2

Keywords

SQL1666N, CCMS_BI_SETUP, Unsupported functionality, NON-RECLAIMABLE STORAGE , KBA , BW-SYS-DB-DB6 , BW DB2 Universal Database , 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.