nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

DataDeploy not updating rows while DCR being updated

Gogz

In Data deploy when I create a new DCR it is getting inserted to the DB, but when I update or delet a DCR, the DB is not updating or deleting.

Attached the Log file & ddcfg file.

Also I have one more different problem, I am running the DD for a while for the same data folder, after some time it says "No dcr's found in the directory" where as the DCRs are exists. Later when I restart the OD server, this resolves. Does this is restarting OD is the soultion for this problem.

Please clarify.

Regards,
GoguL

Find more posts tagged with

Comments

nakumar

Are you using standalone DD or DAS? What is the OS and TS Version?

Gogz

Thanks for your interest Kumar.

It is Standalone DD
TS version: iwserver: 6.7.1 Build 67998 Interwoven 20070828
OD version: Version 6.1.1.0.0 Build 62302 Interwoven 20061128
OS : Solaris

Gogz

I tried even by deleting the iwdeltracker table, but still no update DB for edited DCRs.

lidkh

Check whether you have the correct TS version within OpenDeployNG/etc/deploy.cfg. It should be in your case:

teamsite.version: 6.7.1

Gogz

It is present in deploy.cfg file. If it is not there then my new DCRs will not added to the DB, but it happens well for me.

nakumar

Can you post the log when you did a new DCR insert and also the log when there is an update ?

Gogz

PFA logs in the Zip file as you requested.

nakumar

In updated_dcr_log.txt, I can see that the DCR are getting updated

DCRs updated : 4

Also there are no errors in the log. Let me know exactly where the updation is failing?

Gogz

The Data deployment does not fails, but in the table updated/deleted DCR row is not updated/deleted. DB still has all the rows. This is the problem.

Also you can see in the LOG

Rows updated : 0

nakumar

Is this the change (update) you made to the DCR?

DBD: UPDATE WEBAPP_FURL3 SET URI_MATCH = ? , CONTENT_TYPE = ? , USER_LOCALE = ? , PLATFORM = ? , URIDESTINATION = ? , URI_DESCRIPTION = ? , CREATIONDATE = ? , LAST_UPDATEDDATE = ? , AVAILABLE_DATE = ? , EXPIRY_DATE = ? WHERE URL_ID = ? AND URI_MATCH = ? AND CONTENT_TYPE = ? AND USER_LOCALE = ? AND PLATFORM = ? AND URIDESTINATION = ? AND URI_DESCRIPTION = ? AND CREATIONDATE = ? AND LAST_UPDATEDDATE = ? AND AVAILABLE_DATE = ? AND EXPIRY_DATE = ?
DBD: Column: URI_MATCH, field: friendly_url/0/URI_MATCH, Index: 1,Converting 'Productsssssaaa' to VARCHAR
DBD: Column: CONTENT_TYPE, field: friendly_url/0/CONTENT_TYPE, Index: 2,Converting 'products' to VARCHAR
DBD: Column: USER_LOCALE, field: friendly_url/0/USER_LOCALE, Index: 3,Converting 'inen-gb' to VARCHAR
DBD: Column: PLATFORM, field: friendly_url/0/PLATFORM, Index: 4,Converting 'internal' to VARCHAR
DBD: Column: URIDESTINATION, field: friendly_url/0/URIDESTINATION, Index: 5,Converting '/LeafAction.do?Record=Product_products_in_en-gb' to VARCHAR
DBD: Column: URI_DESCRIPTION, field: friendly_url/0/URI_DESCRIPTION, Index: 6,Converting 'newly created' to VARCHAR
DBD: Column: CREATIONDATE, field: friendly_url/0/CREATIONDATE, Index: 7,Converting '08-05-08' to TIMESTAMP
DBD: Column: LAST_UPDATEDDATE, field: friendly_url/0/LAST_UPDATEDATE, Index: 8,Converting '08-05-08' to TIMESTAMP
DBD: Column: AVAILABLE_DATE, field: friendly_url/0/AVAILABLE_DATE, Index: 9,Converting '14-05-09' to TIMESTAMP
DBD: Column: EXPIRY_DATE, field: friendly_url/0/EXPIRY_DATE, Index: 10,Converting '14-05-09' to TIMESTAMP
DBD: Column: URL_ID, field: friendly_url/0/URI_ID, Index: 11,Converting '333' to VARCHAR
DBD: Column: URI_MATCH, field: friendly_url/0/URI_MATCH, Index: 12,Converting 'Productsssssaaa' to VARCHAR
DBD: Column: CONTENT_TYPE, field: friendly_url/0/CONTENT_TYPE, Index: 13,Converting 'products' to VARCHAR
DBD: Column: USER_LOCALE, field: friendly_url/0/USER_LOCALE, Index: 14,Converting 'inen-gb' to VARCHAR
DBD: Column: PLATFORM, field: friendly_url/0/PLATFORM, Index: 15,Converting 'internal' to VARCHAR
DBD: Column: URIDESTINATION, field: friendly_url/0/URIDESTINATION, Index: 16,Converting '/LeafAction.do?Record=Product_products_in_en-gb' to VARCHAR
DBD: Column: URI_DESCRIPTION, field: friendly_url/0/URI_DESCRIPTION, Index: 17,Converting 'updated' to VARCHAR
DBD: Column: CREATIONDATE, field: friendly_url/0/CREATIONDATE, Index: 18,Converting '08-01-2008 12:01' to TIMESTAMP
DBD: Column: LAST_UPDATEDDATE, field: friendly_url/0/LAST_UPDATEDATE, Index: 19,Converting '08-01-2008 12:01' to TIMESTAMP
DBD: Column: AVAILABLE_DATE, field: friendly_url/0/AVAILABLE_DATE, Index: 20,Converting '14-01-2009 12:01' to TIMESTAMP
DBD: Column: EXPIRY_DATE, field: friendly_url/0/EXPIRY_DATE, Index: 21,Converting '14-01-2009 12:01' to TIMESTAMP
DBD: DELETE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ?
DBD: 1 rows inserted into iwdeltracker for templatedata/website/friendly_url/data/new_Product_products_in_en-gb, /btgsportal/main/supersite/inprocess_db/WORKAREA/content_classes
DBD: -- Updated

Gogz

Yes

URI Description is changed from "updated" to "newly created"

nakumar

Check the columns in db tables, it should have got updated if the log is showing as "updated". In case if you feel the update is not happened at the db end. Can you retry the deployment with real-update="no" ?

Gogz

I tried even with that.

See the log shows only the DCRs updated and not the Rows updated.

Gogz

is there anyone to help me in this?

Ottawa_IWOV

bump ...

We are experiencing the same issue. I mean, this Data Deploy tool is infinitely frustrating. I cannot believe it is a product offering from Interwoven. We have spent the better part of a year having to do complex integrations with this tool (i.e. producing custom XML files for deployment etc.) and now we have phantom updates that are not occuring in the DB.

Does anyone from Interwoven have insights as to the issues that a *number* of people are facing related to DB updates?

Thanks!

Gogz

This was resolved in my case. The root cause is the date format, which was wrong. I changed to
column name="CREATIONDATE" data-type="DATE" data-format="yyyy.MM.dd" db-datetime-format="yyyy.MM.dd" value-from-field="friendly_url/0/CREATIONDATE" allows-null="yes"

After then the update works for me. But the delete happens only with the filelist or base area comparison deployment.

Regards,
Gogz.

Ottawa_IWOV

After some investigation, it is coming down to character encoding.

75B60F26.txt

vikasp

After some investigation, it is coming down to character encoding.

I am also facing the same issue.Can you please suggest what was the exact solution for this issue??
Thanks in Advance

vikasp

Can anyone help to resolve this issue

Thanks in advance

sashae

I'm also experiencing the same issue, running TS 6.7.2sp2. We've noticed that it primarily occurs with large, multiply-updated DCRs. In our case, if we delete a modified or added replicant and then re-add it with the same content, DD picks up the change. The most fascinating part for me is that OD is seeing changes (we're adding physical images at the same time as we're modifying DD records) and those files are correctly deployed.

It seems that this issue is fairly widespread...