SAP Knowledge Base Article - Preview

2660263 - "create index al_langxmltext1" error during repository creation in Data Services

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

SAP Data Services 4.2

Keywords

db2, db2 11.1, create index al_langxmltext1, repository, DS, installation, creation, BODS, DI , KBA , EIM-DS-DEP , Data Services Deployment, Installation, Upgrade , 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.