Hello,
I am deploying a tree structure in database....First a container(PressReleases expandable 0 to 10)---then its child (PressReleases2--expandable 0 to 10)and then again the child of PressReleases2 that is (container3--expandable 0 to 10)
Totaly it is three level deployment.
I have a set of Primary key {Title(this is menber of --PressReleases ), SubTitle(this is menber of --PressReleases2), and SubTitle2(this is menber of --container3)}.
My entries inside my deployment configuration file look like..
<--column name="Title" data-type="VARCHAR(50)" value-from-field="JetNews/0/PressReleases/[0-10]/Title/0" allows-null="no" is-url="no" list-to-replicant="yes" is-replicant="yes"--/>
<--column name="SubTitle" data-type="VARCHAR(50)" value-from-field="JetNews/0/PressReleases/[0-10]/PressReleases2/[0-10]/SubTitle/0" allows-null="yes" is-url="no" list-to-replicant="yes" is-replicant="yes"--/>
<--column name="date" data-type="datetime" data-format="yyyy-mm-dd" value-from-field="JetNews/0/PressReleases/[0-10]/PressReleases2/[0-10]/Date/0" allows-null="yes" is-url="no" list-to-replicant="yes" is-replicant="yes"--/>
<--column name="SubTitle2" data-type="VARCHAR(800)" value-from-field="JetNews/0/PressReleases/[0-10]/PressReleases2/[0-10]/container3/[0-10]/SubTitle2/0" allows-null="no" is-url="no" list-to-replicant="yes" is-replicant="yes"--/>
It not deploying the content to Database. Its not able to reach out to the third level container i.e. container3, while if i put the third Primary key that is SubTitle2 in second level container then it is successfuly deploy it.
Can any body tell me what the problem may be?
Error Logs are attached:---
==============================================
==============================================
ENG: 2008-11-17 12:15:25 IST GMT+05:30 Begin logfile [C:\Interwoven\OpenDeployNG\log\testDD\src.DataDeployMenu.NewsCK.mlbp-0959.to.database.log] ---------
ENG: 2008-11-17 12:15:25 IST GMT+05:30 Job ID=m10 Deployment=testDD/DataDeployMenu
ENG: 2008-11-17 12:15:25 IST GMT+05:30 DataDeploy Version is 6.2.0.0.0
ENG: 2008-11-17 12:15:25 IST GMT+05:30 Owner started the deployment is MLBP-0959\Administrator
ENG: 2008-11-17 12:15:25 IST GMT+05:30 DD args iwdd="NewsCK" tableName="table" deployList="C:/Interwoven/OpenDeployNG/conf/testDD/Menu.txt" deployTargetUsername="sa" deployTargetPassword="password" cfg=C:\Interwoven\OpenDeployNG\conf\testDD\DataDeployMenu.xml need-result=yes depuuid=5032fb20-b473-11dd-adbe-8f50f4ede6c7 leglabel=database
ENG: 2008-11-17 12:15:25 IST GMT+05:30 Proceed to execute the database deployment
DBD: Deployment : NewsCK
DBD: Database Vendor set to rdbms
DBD: SQL datatype for column Title is VARCHAR(50)
DBD: SQL datatype for column SubTitle is VARCHAR(50)
DBD: SQL datatype for column date is datetime
DBD: SQL datatype for column SubTitle2 is VARCHAR(800)
DBD: # of columns: 4
DBD: # of primary key columns specified: 3
DBD: # of groups defined in element: 1
DBD: [Mon Nov 17 12:15:25 IST 2008] Begin executing NewsCK
DBD: Begin Set up the publisher thread
DBD: End Set up the publisher thread
DBD: Area VPath://172.20.73.96/default/main/JetPortalBranch/English/India/WORKAREA/India_WA
DBD: Setting up TDbSchemaAgent.
DBD: Validating cached connection...
DBD: Cached connection OK
DBD: Connected to [172.20.73.96:1433;databaseName=IWDB]
DBD: Table [JW_News] exists.
DBD: Running deployment [NewsCK]
DBD: extraction type=full
DBD: tuple mode=wide
DBD: area=//172.20.73.96/default/main/JetPortalBranch/English/India/WORKAREA/India_WA
DBD: filelist=[C:/Interwoven/OpenDeployNG/conf/testDD/Menu.txt]
DBD: //172.20.73.96/default/main/JetPortalBranch/English/India/WORKAREA/India_WA//templatedata/Folder1/MyFolder1/data/ttt
DBD: Generate DirectoryContents start:Mon Nov 17 12:15:25 IST 2008
DBD: Generate DirectoryContents end :Mon Nov 17 12:15:25 IST 2008
DBD: Building replicant order column information.
DBD: Building replicant order column information... Done.
DBD: TUPLE={JetNews/0/PressReleases/0/Title/0=ttt, JetNews/0/PressReleases/0/PressReleases2/0/container3/1/Text3/0=vcvcv, IWOV_PROC_FLAG=true, JetNews/0/PressReleases/0/PressReleases2/0/container3/0/SubTitle2/0=stt2, state=Original, JetNews/0/PressReleases/0/PressReleases2/0/SubTitle/0=st1, JetNews/0/PressReleases/0/PressReleases2/0=, JetNews/0/PressReleases/0=, JetNews/0=, JetNews/0/PressReleases/0/PressReleases2/0/container3/1/SubTitle2/0=ss3, JetNews/0/PressReleases/0/PressReleases2/0/container3/0/Text3/0=cvcc, JetNews/0/PressReleases/0/PressReleases2/0/container3/1=, JetNews/0/PressReleases/0/PressReleases2/0/container3/0=, JetNews/0/PressReleases/0/PressReleases2/0/Date/0=2008-08-08, path=templatedata\Folder1\MyFolder1\data\ttt}
DBD: Performing Real Update
DBD: TTableSchemaHelper object for [JW_News] found in cache.
DBD: SELECT KEYCOLNAME , KEYCOLVALUE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ? AND KEYCOLNAME IN ( 'Title','SubTitle','SubTitle2')
DBD: 4 PK values retrieved from iwdeltracker for templatedata\Folder1\MyFolder1\data\ttt, //172.20.73.96/default/main/JetPortalBranch/English/India/WORKAREA/India_WA
DBD: TTableSchemaHelper object for [JW_News] found in cache.
DBD: TTableSchemaHelper object for [JW_News] found in cache.
DBD: TTableSchemaHelper object for [JW_News] found in cache.
DBD: SelectCurrentRows
ELECT date,Title,SubTitle,SubTitle2 FROM JW_News WHERE Title IN (? ) AND SubTitle IN (? ) AND SubTitle2 IN (?,? ) ORDER BY Title,SubTitle,SubTitle2
DBD: Index: 1, value: ttt
DBD: Index: 2, value: st1
DBD: Index: 3, value: stt2
DBD: Index: 4, value: ss3
DBD: WARNING:db-datetime-format attribute not set for [date] in group [JW_News]. Assuming default: yyyy-MM-dd HH:mm:ss.S
DBD: Converted 2008-01-08 00:08:00.0 to 2008-08-08
DBD: SelectCurrentRows: 1 rows selected.
DBD: TTableSchemaHelper object for [JW_News] found in cache.
DBD: GetCurrentRowsFromGroupInfo: 1 rows selected from JW_News
DBD: Building Row map tree for group [JW_News].
DBD: This may take a while....
DBD: Row map tree for group [JW_News] built.
DBD: DELETE FROM JW_News WHERE Title = ? AND SubTitle = ? AND SubTitle2 = ? AND date = ?
DBD: Column: Title, field: null, Index: 1,Converting 'ttt' to VARCHAR
DBD: Column: SubTitle, field: null, Index: 2,Converting 'st1' to VARCHAR
DBD: Column: SubTitle2, field: null, Index: 3,Converting 'stt2' to VARCHAR
DBD: Column: date, field: null, Index: 4,Converting '2008-08-08' to TIMESTAMP
DBD: DELETE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ?
DBD: 4 rows inserted into iwdeltracker for templatedata\Folder1\MyFolder1\data\ttt, //172.20.73.96/default/main/JetPortalBranch/English/India/WORKAREA/India_WA
DBD: -- Updated
DBD: Filelist walk done
DBD: Stat for group [JW_News]:
DBD: -----------------------------------
DBD: Rows inserted : 0
DBD: Rows updated : 0
DBD: Rows deleted : 1
DBD: Rows failed : 0
DBD: Rows rolled back : 0
DBD: Rows skipped : 0
DBD: -----------------------------------
DBD: Committing database [172.20.73.96:1433;databaseName=IWDB]...
DBD: Deployment[NewsCK]
DBD: -----------------------------------
DBD: DCRs inserted : 0
DBD: DCRs updated : 1
DBD: DCRs deleted : 0
DBD: DCRs failed : 0
DBD: DCRs rolled back : 0
DBD: DCRs skipped : 0
DBD: -----------------------------------
DBD: Started : Mon Nov 17 12:15:25 IST 2008
DBD: Shutting down DDD PublisherThread
DBD: Finished: Mon Nov 17 12:15:25 IST 2008
DBD:
### IWDataDeploy DONE ###
DBD:
### Sending result ###
ENG: 2008-11-17 12:15:25 IST GMT+05:30 Database deployment execution returned 0
ENG: 2008-11-17 12:15:25 IST GMT+05:30 <<< Completed database deployment Invocation>>>
ENG: 2008-11-17 12:15:25 IST GMT+05:30 doTask returned 0
ENG: 2008-11-17 12:15:25 IST GMT+05:30 Setting final state to TASKDONE
ENG: 2008-11-17 12:15:25 IST GMT+05:30 Manifest path is C:/Interwoven/OpenDeployNG/log/testDD/src.DataDeployMenu.NewsCK.mlbp-0959.to.database.log.mf
ENG: 2008-11-17 12:15:25 IST GMT+05:30 Got Manifest object com.interwoven.od.adapter.delivery.base.IWODManifest@12d9844
ENG: 2008-11-17 12:15:25 IST GMT+05:30 fHasFailedItems is set to false
ENG: 2008-11-17 12:15:25 IST GMT+05:30 Published leg event depUuid=[5032fb20-b473-11dd-adbe-8f50f4ede6c7] legLabel=[database] nextUuid=[null] nextDep=[null]
ENG: 2008-11-17 12:15:25 IST GMT+05:30 Job ID=m10 Deployment leg=database Elapsed Time=187 ms <<<
ENG: 2008-11-17 12:15:25 IST GMT+05:30 End logfile [C:\Interwoven\OpenDeployNG\log\testDD\src.DataDeployMenu.NewsCK.mlbp-0959.to.database.log]
