Datadeploy not inserting data

Hi all,

Datadeploy is not inserting the datas into the table. But it responds as success on the deployment.

The following is the DD XML config file :

< database use="$databaseUse" delete-tracker="yes" real-update="no" update-type="standalone" >
< dbschema>
< group name="RELEASES" table="RELEASES" root-group="yes">
< attrmap>
< column name="ID" data-type="VARCHAR2(50)" value-from-field="releases/0/folder/[0-50]/Releases/[0-500]/image/0" is-replicant="yes" allows-null="no" />
< column name="RELEASES_ID" data-type="NUMBER(25)" value-from-field="releases/0/ReleaseId/0" allows-null="no" />
< column name="CREATED_DATE" data-type="DATE" data-format="MM/dd/yyyy HH:mm:ss" value-from-field="releases/0/folder/[0-50]/Releases/[0-500]/created-date/0" is-replicant="yes" allows-null="no" />
< column name="UPDATED_DATE" data-type="DATE" data-format="MM/dd/yyyy HH:mm:ss" value-from-field="releases/0/folder/[0-50]/Releases/[0-500]/updated-date/0" is-replicant="yes" allows-null="no" />
< column name="LINK" data-type="VARCHAR2(1000)" value-from-field="releases/0/folder/[0-50]/Releases/[0-500]/path/0" is-replicant="yes" allows-null="yes" />
< column name="CAPTION" data-type="VARCHAR2(1000)" value-from-field="releases/0/folder/[0-50]/Releases/[0-500]/caption/0" is-replicant="yes" allows-null="yes" />
< column name="VISIBILITY" data-type="NUMBER(1)" value-from-field="releases/0/folder/[0-50]/visibility/0" is-replicant="yes" allows-null="no" />
< /attrmap>
< keys>
< primary-key>
< key-column name="ID"/>
< key-column name="RELEASES_ID"/>
< /primary-key>
< /keys>
< /group>
< /dbschema>
< /database>

And the log file :

DBD: Building Row map tree for group [RELEASES].
DBD: This may take a while....
DBD: Row map tree for group [RELEASES] built.
DBD: DELETE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ?
DBD: 8 rows inserted into iwdeltracker for templatedata\net\releases\data\20070618164259837087.xml, /default/main/GR/cbr/WORKAREA/content
DBD: -- Updated
DBD: Filelist walk done
DBD: Stat for group [RELEASES]:
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: Event reporting turned off
DBD: Committing database [stg:1521:web]...
DBD: Deployment[Releases]
DBD: -----------------------------------
DBD: DCRs inserted : 1
DBD: DCRs updated : 0
DBD: DCRs deleted : 0
DBD: DCRs failed : 0
DBD: DCRs rolled back : 0
DBD: DCRs skipped : 0
DBD: Started : Mon Jun 18 17:46:37 PDT 2007
DBD: Finished: Mon Jun 18 17:46:42 PDT 2007
DBD:
### IWDataDeploy DONE ###

DBD:
### Sending result ###

ENG: 2007-06-18 17:46:42 PDT GMT-07:00 Database deployment execution returned 0

ENG: 2007-06-18 17:46:42 PDT GMT-07:00 <<< Completed database deployment Invocation>>>

ENG: 2007-06-18 17:46:42 PDT GMT-07:00 doTask returned 0

ENG: 2007-06-18 17:46:42 PDT GMT-07:00 Setting final state to TASKDONE

ENG: 2007-06-18 17:46:42 PDT GMT-07:00 Job ID=m2 Deployment leg=database Elapsed Time=5016 ms <<<
ENG: 2007-06-18 17:46:42 PDT GMT-07:00 End logfile

And the deployment command returns as successful. But no data is been inserted into the database.

I am using Interwoven TeamSite 6.5.0 Service Pack 2 with OpenDeploy Version 6.0.2.1.0 Build 52162 Interwoven 20050921.

Please advice.

Thanks
John

Find more posts tagged with

Comments

Phanie

can you post the perl file where you are referring to the xml file

Ambuj

Hi all,

Datadeploy is not inserting the datas into the table. But it responds as success on the deployment.

The following is the DD XML config file :

< database use="$databaseUse" delete-tracker="yes" real-update="no" update-type="standalone" >
< dbschema>
< group name="RELEASES" table="RELEASES" root-group="yes">
< attrmap>
< column name="ID" data-type="VARCHAR2(50)" value-from-field="releases/0/folder/[0-50]/Releases/[0-500]/image/0" is-replicant="yes" allows-null="no" />
< column name="RELEASES_ID" data-type="NUMBER(25)" value-from-field="releases/0/ReleaseId/0" allows-null="no" />
< column name="CREATED_DATE" data-type="DATE" data-format="MM/dd/yyyy HH:mm:ss" value-from-field="releases/0/folder/[0-50]/Releases/[0-500]/created-date/0" is-replicant="yes" allows-null="no" />
< column name="UPDATED_DATE" data-type="DATE" data-format="MM/dd/yyyy HH:mm:ss" value-from-field="releases/0/folder/[0-50]/Releases/[0-500]/updated-date/0" is-replicant="yes" allows-null="no" />
< column name="LINK" data-type="VARCHAR2(1000)" value-from-field="releases/0/folder/[0-50]/Releases/[0-500]/path/0" is-replicant="yes" allows-null="yes" />
< column name="CAPTION" data-type="VARCHAR2(1000)" value-from-field="releases/0/folder/[0-50]/Releases/[0-500]/caption/0" is-replicant="yes" allows-null="yes" />
< column name="VISIBILITY" data-type="NUMBER(1)" value-from-field="releases/0/folder/[0-50]/visibility/0" is-replicant="yes" allows-null="no" />
< /attrmap>
< keys>
< primary-key>
< key-column name="ID"/>
< key-column name="RELEASES_ID"/>
< /primary-key>
< /keys>
< /group>
< /dbschema>
< /database>

And the log file :

DBD: Building Row map tree for group [RELEASES].
DBD: This may take a while....
DBD: Row map tree for group [RELEASES] built.
DBD: DELETE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ?
DBD: 8 rows inserted into iwdeltracker for templatedata\net\releases\data\20070618164259837087.xml, /default/main/GR/cbr/WORKAREA/content
DBD: -- Updated
DBD: Filelist walk done
DBD: Stat for group [RELEASES]:
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: Event reporting turned off
DBD: Committing database [stg:1521:web]...
DBD: Deployment[Releases]
DBD: -----------------------------------
DBD: DCRs inserted : 1
DBD: DCRs updated : 0
DBD: DCRs deleted : 0
DBD: DCRs failed : 0
DBD: DCRs rolled back : 0
DBD: DCRs skipped : 0
DBD: Started : Mon Jun 18 17:46:37 PDT 2007
DBD: Finished: Mon Jun 18 17:46:42 PDT 2007
DBD:
### IWDataDeploy DONE ###

DBD:
### Sending result ###

ENG: 2007-06-18 17:46:42 PDT GMT-07:00 Database deployment execution returned 0

ENG: 2007-06-18 17:46:42 PDT GMT-07:00 <<< Completed database deployment Invocation>>>

ENG: 2007-06-18 17:46:42 PDT GMT-07:00 doTask returned 0

ENG: 2007-06-18 17:46:42 PDT GMT-07:00 Setting final state to TASKDONE

ENG: 2007-06-18 17:46:42 PDT GMT-07:00 Job ID=m2 Deployment leg=database Elapsed Time=5016 ms <<<
ENG: 2007-06-18 17:46:42 PDT GMT-07:00 End logfile

And the deployment command returns as successful. But no data is been inserted into the database.

I am using Interwoven TeamSite 6.5.0 Service Pack 2 with OpenDeploy Version 6.0.2.1.0 Build 52162 Interwoven 20050921.

Please advice.

Thanks
John

It is not saying that it has inserted any row to the table.. It means although the command is successful it has not inserted any row...

I would suggest you to deploy some fixed (sample) values first to test the deployment.. if it works fine then you can start deploying values from DCR...

nipper

I have seen this before when the TeamSite Version is not defined in the deploy.cfg. Can you check that ?

sampledb.rptdesign

jstephan

It worked fine when i removed all the replicants and tried with a single record in the DCR. Everything worked verywell. Record is been inserted.

This is the Datadeploy Command :
d:/iwhome/OpenDeployNG/bin/iwodcmd.exe start DataDeploy/GR/new/Release -k iwdd=Releases -k filelist="d:/iwhome/tmp/DDfilelist.101140" -k area="/default/main/GR/cbr/WORKAREA/content" -k databaseUse=cbr -inst _john_101145

Datadeploy Result ->
Locating OpenDeploy service.
Got OpenDeploy service
>>>>>-- Start deployment DataDeploy/GR/new/Release_john_101145.
iwodstart running in default synchronous mode.
Need to wait for deployment to complete.
>>>>>-- Deployment DataDeploy/GR/new/Release_john_101145 finished:
ID: m2 Start time: Mon Jun 18 17:46:37 PDT 2007
Status: Completed

jstephan

Finally when i changed the DCR structure (changed the visibility into nested container), it worked fine. thanks for all your responses.

kajjubee

jstephan,
Can you give more details on this please? I am encountering this same exact issue, and I suspect this happens with replicant inside a replicant like in your case (I'm using 6.0 DTD). But I am not sure what you mean by "changed visibility into nested container".

TS 6.7.1 SP1 Patch 1
OD 6.2
Solaris 10

Thanks,
K