Portal Engine Questions on portal engine and web parts.
Version 6.x > Portal Engine > error on custom table synch View modes: 
User avatar
Member
Member
john.banning-adaptdev - 5/24/2012 5:18:07 PM
   
error on custom table synch
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?

User avatar
Kentico Consulting
Kentico Consulting
kentico_borisp - 5/26/2012 2:54:53 AM
   
RE:error on custom table synch
Hello,

Try to delete the table manually, as you suggested, but please perform a backup first. Afterwards, try to synchronize the custom table from your development server.

Best regards,
Boris Pocatko