Current environments:
Two machines both running TeamSite 6.5 SP2 and OpenDeploy 6.0.2. Both are running on W2K.
However, the behaviour of Data Deploy is different. The difference occurs (see log snapshot below) after an update to an existing record. One server does a "[FONT=Courier New]DAS: DoesRowExist
ELECT COUNT(*) FROM .." check but the other does not. Can you please let me know how to turn on (or off) this verification step?[/FONT]one[INDENT]
DBD: UPDATE KE_CONTENT SET partner_id = ? , promotion_id = ? , location_id = ? , content = ? , locale_key = ? , title = ? , summary = ? , external_url = ? , use_as_link = ? , external_link_text = ? , english_only = ? , vpath = ? , created_by = ? , modified_by = ? , created_date = ? , prov_code = ? , city = ? , subcat_id = ? WHERE id = ? AND partner_id is null AND promotion_id is null AND location_id is null AND locale_key = ? AND title = ? AND summary = ? AND external_url is null AND use_as_link = ? AND external_link_text is null AND english_only = ? AND vpath = ? AND created_by = ? AND modified_by = ? AND created_date = ? AND prov_code is null AND city is null AND subcat_id is null
DBD: Column: partner_id, field: partner_code, Index: 1,Converting '' to VARCHAR
...
...
DBD: -- Updated
DBD: Filelist walk done
...
[/INDENT]
other[INDENT]
DAS: UPDATE KE_CONTENT SET partner_id = ? , promotion_id = ? , location_id = ? , content = ? , locale_key = ? , title = ? , summary = ? , external_url = ? , use_as_link = ? , external_link_text = ? , english_only = ? , vpath = ? , created_by = ? , modified_by = ? , created_date = ? , prov_code = ? , city = ? , subcat_id = ? WHERE id = ? AND partner_id is null AND promotion_id is null AND location_id is null AND locale_key = ? AND title = ? AND summary = ? AND external_url is null AND use_as_link = ? AND external_link_text is null AND english_only = ? AND vpath = ? AND created_by = ? AND modified_by = ? AND created_date = ? AND prov_code is null AND city is null AND subcat_id is null
DAS: Column: partner_id, field: partner_code, Index: 1,Converting '' to VARCHAR
...
...
DAS: DoesRowExistELECT COUNT(*) FROM KE_CONTENT WHERE id = ? AND partner_id is null AND promotion_id is null AND location_id is null AND locale_key = ? AND title = ? AND summary = ? AND external_url is null AND use_as_link = ? AND external_link_text is null AND english_only = ? AND vpath = ? AND created_by = ? AND modified_by = ? AND created_date = ? AND prov_code is null AND city is null AND subcat_id is null
...
[/INDENT]
