SAP Knowledge Base Article - Preview

3752742 - Msg 5066 persists after "dbcc shrinkdb_setup" on empty Table with dropped LOB column - SAP ASE

Symptom

  • `sp_shrink` / `ALTER DATABASE OFF` fails with Msg 5066 for a specific table.

    Msg 5066, Level 16, State 1:
    Table '<table_name>' contains off-row columns that do not link back to their
    owning rows. Run dbcc shrinkdb_setup to set up back links for this database.

  • Ran 'dbcc shrinkdb_setup`as KBA 2440368 suggested,it completes without showing error, but shrink cannot proceed with the same error.

  • `dbcc checktable` and `dbcc tablealloc` both report clean (0 rows, 0 text extents)

  • "sp_help <table_name>" shows below message which indicates previously had text/image/Lob columns that were subsequently dropped.
    Table OWNER.<table_name> has columns dropped by no datacopy method.

  • Check syspartitions for this table and it has "t<table_name>_<partid>" prefixed LOB partition.



Read more...

Environment

SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0 ; SAP Solution Manager 7.2

Keywords

shrink, LOB,phantom , KBA , BC-DB-SYB , Business Suite on Adaptive Server Enterprise , 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.