SAP Knowledge Base Article - Preview

2692634 - Error during creating or upgrading data services repository hosted on DB2 database

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

SAP Data Services 4.2

Keywords

db2, repo, index, ds , KBA , EIM-DS-SVR , Data Services 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 ONE Support launchpad (Login required).

Search for additional results

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