Symptom
The following error appears when creating or upgrading data services repository hosted on DB2 database
CREATE UNIQUE INDEX AL_SCHEMA_INDX1 ON AL_SCHEMA (NAME, OWNER, DATASTORE, VERSION, DB_SCHEMA)
BODI-320004: Error or warning in executing the SQL statement <
CREATE UNIQUE INDEX AL_SCHEMA_INDX1 ON AL_SCHEMA (NAME, OWNER, DATASTORE, VERSION, DB_SCHEMA)>. The message from the underlying database is: <SQL submitted to database <DSREPDEV> resulted in error <[IBM][CLI Driver][DB2/AIX64] SQL0614N The index or index extension "AL_SCHEMA_INDX1" cannot be created or altered because the combined length of the specified columns is too long. SQLSTATE=54008
>. The SQL submitted is <
CREATE UNIQUE INDEX AL_SCHEMA_INDX1
ON AL_SCHEMA (NAME, OWNER, DATASTORE, VERSION, DB_SCHEMA)>.>.
An error occurred during creation of the local repository. (BODI-300054)
Read more...
Environment
SAP Data Services 4.x
Repository DB2 - verious versions
Product
Keywords
db2, repo, index, ds , KBA , EIM-DS-SVR , Administration/Server , 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.
SAP Knowledge Base Article - Preview