SAP Knowledge Base Article - Preview

2392526 - Alter table error: You cannot alter a roundrobin partitioned table with a global placement index when the operation requires data copy - ASE

Symptom

  • Running Trizetto updates on a table
  • The following ODBC error from application is reported:

THREAD = 2System.Data.Odbc.OdbcException (0x80131937): ERROR [ZZZZZ] [SAP][ASE ODBC Driver][Adaptive Server Enterprise]

  •  Additional error reported by Trizetto in the ASE error log:

ERROR [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise]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.
ERROR [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise]Conversion of dbo.<table> started - Nov 14 2016 11:41:28:223PM
ERROR [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise]ALTER of dbo.<table> started - Nov 14 2016 11:41:28:373PM
ERROR [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise]******************************************************************************
ERROR [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise]******   Error encountered creating new colums in <table> table! ******
ERROR [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise]******************************************************************************
ERROR [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise]ALTER of dbo.<table> ended - Nov 14 2016 11:41:28:433PM
ERROR [ZZZZZ] [Sybase][ODBC Driver][Adaptive Server Enterprise]Conversion of dbo.<table> ended - Nov 14 2016 11:41:28:436PM
at Trizetto.Foundation.DataManagement.Conversion.UpgradeFramework.ExecDynamicSQL(ThreadAttributes p_ThreadAttributes, List`1 p_Commands, String& p_UpstSts)

  • The underlying ASE error reported is:

ALTER TABLE 'dbo.<table>' failed. You cannot alter a roundrobin partitioned table with a global placement index when the operation requires data copy. Drop the index and try again.

  • The table involved in the "alter table" has the following attributes:

    • data-only locking table
    • partitioned
    • has a clustered and nonclustered index


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

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.