Symptom
- Table t1 has update trigger which inserts data from internal deleted into table t2;
- Table t1/t2 schemas are modified by command 'alter table ... drop column with NO DATACOPY';
- The update trigger of t1 has been recreated afer table schema changed;
- Following problems start to happen after 'reorg rebuild' being run on table t1:
* 'Invalid column length' messages may display in ASE errorlog file like below:
Invalid column length: 11. Value must be between 0 and 1 at offset -17 for 'data-only' row with minimum row length of 46.
* New inserted data rows in t2 show data corruption.
Read more...
Environment
- SAP Adaptive Server Enterprise (ASE) 15.7 SP138/139
Product
SAP Adaptive Server Enterprise 15.7
Keywords
'Invalid column length', 'NO DATACOPY', alter table drop column, CR#803870, 803870, CR 803870, reorg rebuild, , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , 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.