Data Deploy issue

I am trying to insert the dcr data to Database using DataDeploy. The error is given below. In the DCR the data is available in the given fields offer_name and faux_title but it says null.

In the DD configuration file i configured in the fields but it is not getting deploy and i tries number of ways to map the database fields but it does'nt work.

DBD: TTableSchemaHelper object for [OFFER_CONTENT] found in cache.

DBD: RowsExistForPath Smiley Frustrated ELECT COUNT(*) FROM OFFER_CONTENT WHERE CONTENT_ID = ?

DBD: INSERT:INSERT INTO OFFER_CONTENT(CONTENT_ID,CONTENT_NAME,CONTENT_TITLE,CREATE_DAT,REGION) VALUES (?,?,?,?,?)

DBD: Column: CONTENT_ID, field: path, Index: 1,Converting '15495859' to DECIMAL

DBD: Column: CONTENT_NAME, field: root/0/info/0/offer_name, Index: 2,null

DBD: Column: CONTENT_TITLE, field: root/0/info/0/faux_title, Index: 3,null

DBD: Column: CREATE_DAT, literal: 2015-02-09, Index: 4,Converting '2015-02-09' to TIMESTAMP

DBD: Column: REGION, literal: US, Index: 5,Converting 'US' to VARCHAR

DBD:

DBD: *******************************************************

DBD: SQLException occured in TDbSchemaGroupCfg

DBD: Exception Message: ORA-01400: cannot insert NULL into ("INTERWOVEN"."OFFER_CONTENT"."CONTENT_NAME")

Please find attache tjhe DD configuration file. Please check and try to suggest what may be the issue. In the same way i configured other DD configuraion it works for me....

Find more posts tagged with

Comments

Adam Stoller

It's been a while since I've had to work with DataDeploy - but are you sure about the xpath you're providing for those fields? I.e.: is it root/0/**** or just root/****? Try the latter and see if that works (it can't hurt to try...)

Rick Poulin

It would help if you attached a sample DCR so we can validate your paths.

Also, probably shouldn't matter, but my old code always had a trailing /0 in my value-from-field attributes, although I don't recall why I had to put that there.

gopi123

please find attached the dcr file.

Adam Stoller

The paths you showed in your first post (e.g.: root/0/info/0/offer_name, root/0/info/0/faux_title) seem to bear no relation to the DCR that you posted where the paths are: /root/offer_name, /root/faux_title (e.g.: there is no 'info' container)

I suggest you try the following possibilities in your DD config file:

/root/0/offer_name
/root/0/offer_name/0
/root/offer_name
/root/offer_name/0
root/0/offer_name
root/0/offer_name/0
root/offer_name
root/offer_name/0

At least one of the above should work - when you figure out which one works, post it.

gopi123

Thanks the below mapping is working fine.

root/0/offer_name/0