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

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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.