SAP Knowledge Base Article - Preview

2356080 - SQL0614N During Upgrade, the combined length of the specified columns is too long. SQLSTATE=54008

Symptom

In the Sum Log of an Upgrade you see the following error lines...

| | Activate table /BIC/A*****300 |
| | Index /BIC/A*****300-KEY (total of field lengths exceeds allowed value) |
| | Index /BIC/A*****300-KEY must be created in the database |
| | Index /BIC/A*****300-KEY must be created in the database |
| | Storage information set to Column Store |
| | /BIC/A*****300: Structure change at field level (Index is created new) |
| | Adjust table in DB >>> |
| | sql: |
| | CREATE UNIQUE INDEX '/BIC/A*****300~KE' on '/BIC/A*****300' |
| | ('TCTUSERNM', |
| | 'TCTAUTH', |
| | 'TCTADTO', |
| | 'TCTIOBJNM', |
| | 'TCTHIENM', |
| | 'TCTHIEVERS', |
| | 'TCTHIEDATE', |
| | 'TCTNIOBJNM', |
| | 'TCTNODE', |
| | 'TCTATYPE', |
| | 'TCTACOMPM', |
| | 'TCTTLEVEL', |
| | 'TCTNDEF') |
| | ALLOW REVERSE SCANS |
| | SQL0614N The index or index extension "/BIC/A*****300~KE" cannot be |
| | created or altered because the combined length of the specified column |
| | is is too long. SQLSTATE=54008


Read more...

Environment

Netweaver Business Warehouse on a DB2/DB4/DB6 platform

Keywords

KBA , BW-WHM-DBA-IOBJ , InfoObjects , BW-SYS-DB-DB6 , BW DB2 Universal Database , BW-SYS-DB-DB2 , BW DB2 for z/OS , BW-SYS-DB-DB4 , BW DB2 for AS/400 , 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.