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

Search for additional results

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