Primary Column Values are missing in DataDeploy

Hi All,

I am doing db deployment(Stand alone) using OD UI. I created a table with columns(id,group,dept) in oracle and also created DCR. But it is not able to find out the values of columns from table.

Check my log statement given below,

DBD: TUPLE={sample/0/group/0=BE, IWOV_PROC_FLAG=true, sample/0/ID/0=50, state=Original, path=templatedata\category\data\model, sample/0/dept/0=ECE, sample/0=}
DBD: ERROR:Values for PK column [ID] missing in [templatedata\category\data\model].
DBD: ERROR:Exception occured: Values for PK column [ID] missing in [templatedata\category\data\model].
DBD: ERROR:
com.interwoven.dd100.dd.InvalidSourceTupleException: Values for PK column [ID] missing in [templatedata\category\data\model].
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.BuildSelectStmtForExistCheck(TDbSchemaGroupCfg.java:2142)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.RowsExistForTuple(TDbSchemaGroupCfg.java:2059)
at com.interwoven.dd100.dd.TDbSchemaCfg.RowsExistForTuple(TDbSchemaCfg.java:1063)
at com.interwoven.dd100.dd.TDbSchemaCfg.RowsExist(TDbSchemaCfg.java:1042)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:421)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:336)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:399)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:388)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:1002)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:502)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:289)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:178)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:547)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)

DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:Unable to process TeamSite source /templatedata/category/data
DBD: ERROR:deployment [model] FAILED
DBD: Error occured in area outside TDbAgent consumer (explicit rollback initiated)
DBD: Stat for group [tab]:
DBD: -----------------------------------
DBD: Rows inserted : 0
DBD: Rows updated : 0
DBD: Rows deleted : 0
DBD: Rows failed : 0
DBD: Rows rolled back : 0
DBD: Rows skipped : 0
DBD: -----------------------------------
DBD: Rollback database [server Smiley Tongue

ort

racle]...
DBD: Deployment[model]
DBD: -----------------------------------
DBD: DCRs inserted : 0
DBD: DCRs updated : 0
DBD: DCRs deleted : 0
DBD: DCRs failed : 0
DBD: DCRs rolled back : 0
DBD: DCRs skipped : 0
DBD: -----------------------------------

Reply me back, if anyone knows the solution.

Regards,
Ramya.

Find more posts tagged with

Comments

Migrateduser

can you post your DD config and your DCR? also, what version

Dhinesh

Hi,

Find the attachment of ddconfig & dcr source.

TS version ---- 6.7.1.0
OD version ---- 6.1.1

Regards,
Ramya.

Migrateduser

the DD error log shows your XML structure as

sample/0/ID/0

your DCR and (matching) DD Config you posted show it as

dcrdata/0/ID/0

aside from that.. i believe you have this set wrong:

[html][/html]

your saying your primary-key can be null, which I dont believe would be correct. I think it should be:

[html][/html]

Dhinesh

Hi jrandallnyc,

Thanks for the reply. My issues with the value from field. When I change it to "Demo/0/{iw_sub_elements}/0/name/0/{iw_sub_elements}/0/#PCDATA" for all columns, my issue gets resolved.

The values from dcr gets updated into database, but partially.

If have 10 dcrs, only 5 dcr values gets updated in database table.
Similarily for 4 dcrs, only 2 values gets updated.

But I found out all entries are there in IWDELTRACKER table.

OD server running with trial version. Whether this is the reason for this partial updation?

Migrateduser

Hi jrandallnyc,

Thanks for the reply. My issues with the value from field. When I change it to "Demo/0/{iw_sub_elements}/0/name/0/{iw_sub_elements}/0/#PCDATA" for all columns, my issue gets resolved.

The values from dcr gets updated into database, but partially.

If have 10 dcrs, only 5 dcr values gets updated in database table.
Similarily for 4 dcrs, only 2 values gets updated.

But I found out all entries are there in IWDELTRACKER table.

OD server running with trial version. Whether this is the reason for this partial updation?

you shouldnt need to use the #PCDATA in your DDconfig, based on your DCR you posted, the only change needed to the DD Config is what I suggested before.. sounds like an issue with real-updates.. try adding real-update="no"

[html][/html]

Dhinesh

Hi jrandallnyc,

I have made those primary key(not null), adding real update='no' changes.
Also I change in dd.xml like "sample/0/{iw_sub_elements}/0/id/0/{iw_sub_elements}/0/#PCDATA", its working fine.

But when I kept in this format in dd.xml Demo/0/id/0, it shows the same error message("InvalidSourceTupleException: Values for PK column [ID] missing ").

All of my dcr values gets updated into database.

Regards,
Dhinesh.

Migrateduser

Hi jrandallnyc,

I have made those primary key(not null), adding real update='no' changes.
Also I change in dd.xml like "sample/0/{iw_sub_elements}/0/id/0/{iw_sub_elements}/0/#PCDATA", its working fine.

But when I kept in this format in dd.xml Demo/0/id/0, it shows the same error message("InvalidSourceTupleException: Values for PK column [ID] missing ").

All of my dcr values gets updated into database.

Regards,
Dhinesh.

so with #PCDATA all is working fine?

RamyaT

Yes, Its working fine when I keep dd.xml in the format "sample/0/{iw_sub_elements}/0/id/0/{iw_sub_elements}/0/#PCDATA".