Data Deploy | Row not getting updated

Hi,

We have a data deployment scripts that deploys around 33000 odd DCRs from the STAGING area to the database. It was working fine until a couple of days back when it did not update certain rows. Ex: There is a column that accepts image path. Certain rows were updated while others were not.

Below is a snippet from the deployment log

DBD: Column: AISLE_LOGO_IMAGE_DES, field: aisleInfo/0/aisleLogoImage_DES, Index: 4,Converting '/en/custom_aisles/assets/images/logo/mm/M_A_MORTENSON_34378.gif
' to VARCHAR
DBD: Column: AISLE_LOGO_IMAGE_ALT_DES, field: aisleInfo/0/aisleLogoImageAlt_DES, Index: 5,Converting 'Company Logo' to VARCHAR
DBD: Column: AISLE_HOME_PG_DCR_ID, field: aisleHomePage/0/aisleHomePageDCR_ID, Index: 6,Converting '/default/main/sprint_com/custom_aisles_jsp/generic/STAGING
/templatedata/pages/home_page/data/default.dcr' to VARCHAR
DBD: Column: AISLE_PGM_DETL_DCR_ID, field: aisleProgramDetails/0/aisleProgramDetailsDCR_ID, Index: 7,Converting '/default/main/sprint_com/custom_aisles_jsp/ge
neric/STAGING/templatedata/pages/program_details/data/default.dcr' to VARCHAR
DBD: Column: AISLE_SUPP_PG_DCR_ID, field: aisleSupport/0/aisleSupportDCR_ID, Index: 8,Converting '/default/main/sprint_com/custom_aisles_jsp/generic/STAGING/t
emplatedata/pages/support/data/default.dcr' to VARCHAR
DBD: Column: AISLE_PROMO_PG_DCR_ID, field: aislePromotions/0/aislePromotionsDCR_ID, Index: 9,Converting '/default/main/sprint_com/custom_aisles_jsp/generic/ST
AGING/templatedata/pages/promotions/data/default.dcr' to VARCHAR
DBD: Column: AISLE_ID, field: aisleInfo/0/aisleId, Index: 10,Converting '34378' to VARCHAR
DBD: Column: AISLE_NME, field: aisleInfo/0/aisleName, Index: 11,Converting 'M A MORTENSON' to VARCHAR
DBD: Column: AISLE_WELCOME_TITLE_TXT, field: aisleInfo/0/aisleWelcomeTitle, Index: 12,Converting 'Welcome M.A. MORTENSON Employees
' to VARCHAR
DBD: Column: AISLE_LOGO_IMAGE_DES, field: aisleInfo/0/aisleLogoImage_DES, Index: 13,Converting '/en/custom_aisles/assets/images/logo/ma/M_A_MORTENSON_34378.gi
f' to VARCHAR
DBD: Column: AISLE_LOGO_IMAGE_ALT_DES, field: aisleInfo/0/aisleLogoImageAlt_DES, Index: 14,Converting 'Company Logo' to VARCHAR
DBD: Column: AISLE_HOME_PG_DCR_ID, field: aisleHomePage/0/aisleHomePageDCR_ID, Index: 15,Converting '/default/main/sprint_com/custom_aisles_jsp/generic/STAGIN
G/templatedata/pages/home_page/data/default.dcr' to VARCHAR
DBD: Column: AISLE_PGM_DETL_DCR_ID, field: aisleProgramDetails/0/aisleProgramDetailsDCR_ID, Index: 16,Converting '/default/main/sprint_com/custom_aisles_jsp/g
eneric/STAGING/templatedata/pages/program_details/data/default.dcr' to VARCHAR
DBD: Column: AISLE_SUPP_PG_DCR_ID, field: aisleSupport/0/aisleSupportDCR_ID, Index: 17,Converting '/default/main/sprint_com/custom_aisles_jsp/generic/STAGING/
templatedata/pages/support/data/default.dcr' to VARCHAR
DBD: Column: AISLE_PROMO_PG_DCR_ID, field: aislePromotions/0/aislePromotionsDCR_ID, Index: 18,Converting '/default/main/sprint_com/custom_aisles_jsp/generic/S
TAGING/templatedata/pages/promotions/data/default.dcr' to VARCHAR
DBD: DELETE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ?
DBD: 1 rows inserted into iwdeltracker for /default/main/sprint_com/custom_aisles_jsp/generic/STAGING/templatedata/aisles/master/data/mm/M_A_MORTENSON_34378.d
cr, /default/main/sprint_com/custom_aisles_jsp/generic/STAGING
DBD: -- Updated

Now, the DCR has the aisle logo value set as /en/custom_aisles/assets/images/logo/mm/M_A_MORTENSON_34378.gif which is being picked up by the deployment. However, the column still has the old value of /en/custom_aisles/assets/images/logo/ma/M_A_MORTENSON_34378.gif
even after the deployment log indicated that it was updated.

Can someone please help me debug this issue

Thanks
Dhruv

Find more posts tagged with

Comments

moonkhanna

/en/custom_aisles/assets/images/logo/mm/M_A_MORTENSON_34378.gif

/en/custom_aisles/assets/images/logo/ma/M_A_MORTENSON_34378.gif

If deployment log says it has updated the value, it would have done that. Check if you are using the right database to validate..or probably deployment is deploying to some other database.

You write some rows are being updated. Try updating one of those dcrs with the above value and run the deployment again. Check if that row gets updated now?

michaelangel0

I think I am experiencing the same problem.

According to the deployment log the new values appear to be over-ridden by values taken from the existing database row.

In the log file I see a number of correct 'DBD: Column: ' entries for the tuple, as described in the deployment definition XML file. The values for each column are the expected values from the DCR we are deploying. However, they are immediately followed by a set of 'DBD: Column: ' entries, duplicating those already listed, which specify values from the existing database row.

It's as if an error has occurred which causes DD to roll back the data but not indicate that it has done so.

This only occurs on updates, and I'm fairly sure it only occurs when updating rows that existed before a change was made to the deployment definition config file.

I should point out that I'm deploying to SQL Server 2005 using OD 6.1 running on Windows

michaelangel0

For anyone interested, the solution to my particular problem is to fix the data that was causing the problem. In this case it was to reset to 0 a date field that had a datestamp value (yyyy-MM-dd HH:mm:ss.S) when DD was configured to deploy a date value (yyyy-MM-dd).

IMO Datadeploy is failing to correctly log that an error has occurred. As far as the deployment is concerned, the update has succeeded and only by close examination of the log file is there any evidence that the update in fact failed.

Anybody from Interwoven care to comment?