Hi Experts,
When we are trying to add column to a table (DRL/DPL) that has an unique clustered index in a database called phoenix (for which we did a project called database resizing in June 2022, followed by patching to SP03 PL12, instrumented fix, SP03 PL12 HF1 and then a one-off) we end up with an error below. As soon as we see the error we followed the SAP note 2392526 and then we were able to add the column. Now for a table with less rows like this doesn't took much tme for index creation and what could be the solution incase if we want to add a column to a table that has millions of records like a history table. Does our resizing(attachment -steps followed for resizing details) caused any problem ? What is the meaning of global placement index? Please advise.
Msg 13917, Level 16, State 1:Server 'POSB_ETHIX_PROD', Line 1:
ALTER TABLE 'AD_GB_EXCH_RATE' 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.
Msg 11050, Level 16, State 132:
Server 'POSB_ETHIX_PROD', 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 SAP Technical Support.
Observation:
The table structure after adding the column and recreating the index has two partitions names - one in small and the other in capital with different ID as their suffix with same creation date but we are unable to understand the exact reason behind this cause. Attached are the details.
NOTE: The error is happening only for the existing tables in the database but not for newly created tables.
Regards,
Dilip Voora