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.