DataDeploy deletes existing rows

cdoloriert

Hi,

DataDeploy Version is 6.1.1.0.0
TS 6.7.2

CaseStudy content type can have sidebars and text widgets and they are stored in a table called Mon_ContentDetails. When I remove text widget and do a deployment sidebars remain intact in that table, but when I remove all sidebars, DD removes all widgets from the table as well.

I can see in the DD logs that it first inserts the widgets on Mon_ContentDetails, but then it deletes from it.


DBD: DELETE FROM Mon_ContentDetails WHERE ContentID = ? AND ContentTypeID = ? AND DetailsWidgetID = ? AND DetailsWidgetTypeID = ? AND LocaleID = ? AND SortOrder = ?
DBD: Column: ContentID, field: null, Index: 1,Converting '11122007181000904' to LONG
DBD: Column: ContentTypeID, field: null, Index: 2,Converting '4' to INTEGER
DBD: Column: DetailsWidgetID, field: null, Index: 3,Converting '2009030811534951' to LONG
DBD: Column: DetailsWidgetTypeID, field: null, Index: 4,Converting '1' to INTEGER
DBD: Column: LocaleID, field: null, Index: 5,Converting '1033' to INTEGER
DBD: Column: SortOrder, field: null, Index: 6,Converting '2' to INTEGER
DBD: DELETE FROM Mon_ContentDetails WHERE ContentID = ? AND ContentTypeID = ? AND DetailsWidgetID = ? AND DetailsWidgetTypeID = ? AND LocaleID = ? AND SortOrder = ?
DBD: Column: ContentID, field: null, Index: 1,Converting '11122007181000904' to LONG
DBD: Column: ContentTypeID, field: null, Index: 2,Converting '4' to INTEGER
DBD: Column: DetailsWidgetID, field: null, Index: 3,Converting '11122007181000858' to LONG
DBD: Column: DetailsWidgetTypeID, field: null, Index: 4,Converting '1' to INTEGER
DBD: Column: LocaleID, field: null, Index: 5,Converting '1033' to INTEGER
DBD: Column: SortOrder, field: null, Index: 6,Converting '1' to INTEGER
DBD: DELETE FROM Mon_ContentDetails WHERE ContentID = ? AND ContentTypeID = ? AND DetailsWidgetID = ? AND DetailsWidgetTypeID = ? AND LocaleID = ? AND SortOrder = ?
DBD: Column: ContentID, field: null, Index: 1,Converting '11122007181000904' to LONG
DBD: Column: ContentTypeID, field: null, Index: 2,Converting '4' to INTEGER
DBD: Column: DetailsWidgetID, field: null, Index: 3,Converting '20090308150354228' to LONG
DBD: Column: DetailsWidgetTypeID, field: null, Index: 4,Converting '3' to INTEGER
DBD: Column: LocaleID, field: null, Index: 5,Converting '1033' to INTEGER
DBD: Column: SortOrder, field: null, Index: 6,Converting '3' to INTEGER
DBD: DELETE FROM Mon_ContentDetails WHERE ContentID = ? AND ContentTypeID = ? AND DetailsWidgetID = ? AND DetailsWidgetTypeID = ? AND LocaleID = ? AND SortOrder = ?
DBD: Column: ContentID, field: null, Index: 1,Converting '11122007181000904' to LONG
DBD: Column: ContentTypeID, field: null, Index: 2,Converting '4' to INTEGER
DBD: Column: DetailsWidgetID, field: null, Index: 3,Converting '20090408094236999' to LONG
DBD: Column: DetailsWidgetTypeID, field: null, Index: 4,Converting '1' to INTEGER
DBD: Column: LocaleID, field: null, Index: 5,Converting '1033' to INTEGER
DBD: Column: SortOrder, field: null, Index: 6,Converting '4' to INTEGER


Do you know why this is happening?
Any suggestions?

Thank your help.

sniv

You have mentioned sidebars and text widgets ..I haven't see any fields or columns mapping for those ..can you help to understand?

Vinayak