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
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.