I am getting the following error:
Dependent task 'Create Custom table item 'IPGEO Regions Look Up - 1' failed:Synchronization server error: Exception occurred: [SyncHelper.GetDataSet]: Error parsing task data - Root element is missing.
when I attempt to synchronize a custom table between the staging server and production.
I have gone as far as attempting to delete the existing table on production and recreate by hand. But upon deleting the table I cannot recreate a table with the same name I get the following:
[DataConnection.ExecuteQuery]: Query: CREATE TABLE customtable_IPGEORegionsLookUp ( ItemID int NOT NULL IDENTITY (1,1)); ALTER TABLE customtable_IPGEORegionsLookUp ADD CONSTRAINT PK_customtable_IPGEORegionsLookUp PRIMARY KEY CLUSTERED ([ItemID]);: caused exception: There is already an object named 'customtable_IPGEORegionsLookUp' in the database.
I am thinking about just going into SQL server and deleting the table.. Is there another way to do this?