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.