2515056 - UPDATE query on page level compression table raised illegal row length error 614 with state 7 -- SAP ASE | SAP Knowledge Base Article

SAP Knowledge Base Article - Preview

2515056 - UPDATE query on page level compression table raised illegal row length error 614 with state 7 -- SAP ASE

Symptom

  • An update query raises error 614, e.g.
    "Error: 614, Severity: 21, State: 7
    server Adaptive Server accessed a row that has an illegal length of 42487 while in data base 'db_firmdev'. Page pointer = 0x0x7f8523f58000, pageno = 90825386, status = 0x151, ptnid = 1777931185, indexid = 0, level = 0, pnextrno = 27. The minimum row length is 38. The page size is 8192."
  • Allpages-locked table
  • Table uses page level compression and it has compressed index

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 16.0 SP02 PL05 and lower
  • SAP Adaptive Server Enterprise (ASE) 15.7

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

compression, Error 614, index compression SQL614, 803584, CR#803584, CR803584 , 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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.