SAP Knowledge Base Article - Preview

2274065 - "invalid column length" on encrypted column reported by dbcc checktable and sp_post_xpload - SAP ASE

Symptom

  • On a table with encrypted column(s)
  • Running the 'dbcc checktable' command
  • Or running sp_post_xpload after a cross-platform migration
  • Reports spurious 'invalid column length' error :

Checking partition 'mytab_123456' (partition ID 123456) of table 'mytab'...
Invalid column length 17 found for column, column ID 2, row ID 0, page number 2841, partition ID 123456. The length is greater than the expected maximum column length 10.
Invalid column length 17 found for column, column ID 2, row ID 1, page number 2841, partition ID 123456. The length is greater than the expected maximum column length 10.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7 SP130 and higher
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

XPDL, validation, CR795382, CR#795382, 795382, crossplatform , KBA , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Bug Filed

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.