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 , 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.