Unable to remove data sync group - always provisioning
-
venerdì 2 marzo 2012 03:24
I created a Data Sync Group. One of the tables has a couple of computed column. Turns out this isn't supported (so why did it let me do it?) so in the log viewer I see lots of errors (see below for example text).
So now I need to remove the sync but it always seems to be "Provisioning" and wont allow me to remove it.This means that I can't add another (corrected) Sync because the DB is already "provisioning".
How can i remove this Sync?
Thanks
Mark
Server id: c7b688c8-c893-4318-ad17-3a5c3efb4242
Region: North Central US
Time / Date: 2-March-2012 03:16 GMT
Tracing Id: 7d212627-da7d-42ad-b398-af1a152a644f
Error text:
Database provisioning failed with the exception "The column "DepartureBest" cannot be modified because it is either a computed column or is the result of a UNION operator.
The column "ArrivalBest" cannot be modified because it is either a computed column or is the result of a UNION operator.
Inner exception: SqlException Error Code: -2146232060 - SqlError Number:271, Message: The column "DepartureBest" cannot be modified because it is either a computed column or is the result of a UNION operator. SqlError Number:271, Message: The column "ArrivalBest" cannot be modified because it is either a computed column or is the result of a UNION operator.
Tutte le risposte
-
venerdì 2 marzo 2012 05:42
Eventually the Sync Group showed as failed and I was able to remove it.- Contrassegnato come risposta Mark Walker - Merlot.Aero venerdì 2 marzo 2012 05:42

