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-DB4 , BW DB2 for AS/400 , BW-SYS-DB-DB2 , BW DB2 for z/OS , 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.