SAP Knowledge Base Article - Preview

2402790 - reorg rebuild fails if table is compressed and binded for in-memory database - SAP ASE

Symptom

  • Failed to run Reorg rebuild cmd on compressed table
  • user is binded to a temporary in-memory database
  • 1> reorg rebuild tb1
    2> go
    Beginning REORG REBUILD of table 'tb1'.
    Msg 14575, Level 16, State 5:
    Server 'ase157', Line 1:
    CREATE TABLE WITH COMPRESSION is not supported for in-memory database
    '<database_name>'.
    Msg 11050, Level 16, State 3:
    Server 'ase157', Line 1:
    Adaptive Server cannot process this ALTER TABLE statement due to one or more
    preceding errors. If there are no preceding errors, please contact Sybase
    Technical Support.
    Msg 11934, Level 16, State 1:
    Server 'ase157', Line 1:
    REORG REBUILD of table 'tb1' failed due to an internal error. Please contact
    SYBASE Technical Support.

Read more...

Environment

  • SAP Adaptive Server Enterprise (ASE) 15.7
  • SAP Adaptive Server Enterprise (ASE) 16.0

Product

SAP Adaptive Server Enterprise 15.7 ; SAP Adaptive Server Enterprise 16.0

Keywords

Msg 14575, Level 16, State 3, Msg 11050, Level 16, State 3, Msg 11934, Level 16, State 1, Reorg rebuild, compressed table, in-memory db, bind, alter table, CR711248, CR#711248, 711248 , 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.