Symptom
During Data Services installation (DS) or creation of a repository using the Data Services Repository Manager, the following errors occur:
CREATE INDEX AL_LANGXMLTEXT1
ON AL_LANGXMLTEXT (OBJECT_NORMNAME, OBJECT_TYPE, OBJECT_SUBTYPE)
BODI-320004: Error or warning in executing the SQL statement <
CREATE INDEX AL_LANGXMLTEXT1
ON AL_LANGXMLTEXT (OBJECT_NORMNAME, OBJECT_TYPE, OBJECT_SUBTYPE)>. The message from the underlying database is: <SQL submitted to database <SDI> resulted in error <[IBM][CLI Driver][DB2/NT64] SQL0614N The index or index extension "AL_LANGXMLTEXT1" cannot be created or altered because the combined length of the specified columns is too long. SQLSTATE=54008
>. The SQL submitted is <
CREATE INDEX AL_LANGXMLTEXT1
ON AL_LANGXMLTEXT (OBJECT_NORMNAME, OBJECT_TYPE, OBJECT_SUBTYPE)>.>.
An error occurred during creation of the central repository. (BODI-300020)
Read more...
Environment
- IBM DB2 11.1 RDBMS
- Windows Server 2012 R2
- SAP Data Services 4.2
- SAP Information Platform Services 4.2 SP5 Patch 3
Product
Keywords
db2, db2 11.1, create index al_langxmltext1, repository, DS, installation, creation, BODS, DI , KBA , EIM-DS-DEP , Deployment, Installation, Upgrade , 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.