SAP Knowledge Base Article - Preview

2404881 - Fatal table corrupt due to cross-platform migration - SAP ASE

Symptom

  • During the cross-platform Prod DB migration (from 12.5.4 Solaris to 15.7 SP136 HF1 Linux)
  • Fatal table corruption has been thrown in the suspect index list warning from sp_post_xpload and sp_indsuspect commands.
  • Can't run DBCC REINDEX as suggested (Msg 605)
  • Can't access table data with select into or truncate table(Msg 12315) in the target ASE DB 15.7. 
  • ASE 12.5.4 source DB table is fully accessible
    Msg 605, Level 16, State 1:
    Server 'ASE', Line 1:
    An attempt was made to fetch logical page '766408' from cache 'default data
    cache'. Page belongs to database 'mydb' (8), object 'mytable'
    (1985858587), index 'myindex' (2), partition 'myindex_1985858587'
    (1985858587) and not to database 'mydb' (8), object 'mytable2'
    (1100530954), index 'myindex2' (-1), partition 'myindex2_1100530954' (1100530954).
    REINDEX received an exception - command aborted.
    DBCC execution completed. If DBCC printed error messages, contact a user * System Administrator (SA) role.
  • Msg 12315, Level 21, State 1:
    Server 'ASE', Line 1:
    Corrupt page, Internal error: Mismatch between tail timestamp 'ec48' and the low
    two bytes of timestamp in the page header '48ec' while accessing page '8568824'
    of object '1100530954' in database '8'. Please contact Sybase Technical Support.
    ASE is terminating this process.


Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE)
  • Dataserver
  • Linux on Power 64bit
  • Linux on x86_64 64bit
  • Solaris on Sparc 64bit 
  • Solaris x86_64 64bit

Product

SAP Adaptive Server Enterprise 12.5 ; SAP Adaptive Server Enterprise 15.7

Keywords

Cross platform, dump/load, indexes, corrupt, dbcc, drop, re-create, table , 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.