3411406 - Error 605 on encrypted databases - SAP ASE

• On SAP ASE database with full database encryption
• DML and SELECT commands randomly fail with error 605 and / or error 694
• These can be seem on allocation pages (objid = 99) and system tables.
• A typical example of the sequence in the ASE log includes:
  
  Error: 21, Severity: 21, State: 1
  WARNING - Fatal Error 605 occurred at Dec  17 2023 12:14PM.  Please note the error and time, and contact a user with System Administrator (SA) authorization.
  Error: 605, Severity: 21, State: 1
  An attempt was made to fetch logical page '12345678' from cache 'default data cache'. Page belongs to database 'db_name' (4), object '<Unknown>' (0), index '<Unknown>' (0), partition '<Unknown>' (-1) and not to database 'db_name' (4), object 'sysobjects' (1), index 'ncsysobjects' (2), partition '<Unknown>' (27248221).
  Error while undoing log row in database 'db_name'.  Rid pageid = 6735982; row num = 10.
  WARNING: Pss 0x000000025e123f28 found with open sdes. pspid 1933, psuid 3, pcurdb 4, system table entry 0, sdesp 0x00000001f20902b0, objid 8.
  Error: 6103, Severity: 17, State: 1
  Unable to do cleanup for the killed process; received Msg 3300.
  WARNING: spid 12345 with suid 3 and curdbid 4 has an active transaction in dbid 4 with xactid (6735982, 8).
  
  The error 605 stack trace contains functions include :
  
  wrongpage 
  getpage_with_validation 
  bt__getchildlatched 
  bt__traverse 
  bt__undo_leafinsdel 
  undo_bt_insdel 
  rec_undo_session 
  abort__all 
  xact_rollback

• SAP Adaptive Server Enterprise (ASE) 160 SP03 PL12 and higher, 160 SP04 PL03 and higher for Business Suite
• SAP Adaptive Server Enterprise (ASE) 160 SP03 PL12 and higher, 160 SP04 PL03 and higher
• SAP NetWeaver (NW) - All versions

605, 694, allocation page, objid=99, corrupt, rollback, CR#828710, CR828710, 828710, CR 828710, corruption error , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , BC-SYB-ASE , Sybase ASE Database Platform (non Business Suite) , Problem