Hello All,
The deployment succeeds. But no values are been inserted into the database table. Only fails for this (Sidebars) DCR Type. But works fine on other DCR Type.
DBD: Deployment : Sidebars
DBD: Database Vendor set to oracle
DBD: SQL datatype for column LOCALE is NUMBER(1)
DBD: SQL datatype for column PAGE_TYPE is VARCHAR2(16)
DBD: SQL datatype for column PLATFORMS_ID is NUMBER(25)
DBD: SQL datatype for column ID is NUMBER(25)
DBD: SQL datatype for column POSITION is VARCHAR2(5)
DBD: SQL datatype for column ORDER_NUMBER is NUMBER(3)
DBD: SQL datatype for column TYPE is VARCHAR2(9)
DBD: SQL datatype for column TABLET_IMAGE_LINK is VARCHAR2(1000)
DBD: SQL datatype for column TABLET_URL is VARCHAR2(1000)
DBD: SQL datatype for column FREE_HTML is VARCHAR2(1000)
DBD: # of columns: 10
DBD: # of primary key columns specified: 4
DBD: # of groups defined in element: 1
DBD: [Thu Nov 15 18:05:54 PST 2007] Begin executing Sidebars
DBD: Area VPath:/default/main/Website/us_uk_22/WORKAREA/content
DBD: Setting up TDbSchemaAgent.
DBD: Validating cached connection...
DBD: Cached connection OK
DBD: Connected to [fndbstg:1521:web]
DBD: SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWDELTRACKER'
DBD: SELECT * FROM USER_TABLES WHERE TABLE_NAME='SIDEBARS'
DBD: Table [SIDEBARS] exists.
DBD: Running deployment [Sidebars]
DBD: extraction type=default
DBD: tuple mode=wide
DBD: area=/default/main/Website/us_uk_22/WORKAREA/content
DBD: filelist=[d:\iwhome/tmp/DDfilelist.115410]
DBD: /default/main/Website/us_uk_22/WORKAREA/content/templatedata/Internet/Sidebars/data/us_homepage
DBD: Generate DirectoryContents start:Thu Nov 15 18:05:54 PST 2007
DBD: Generate DirectoryContents end :Thu Nov 15 18:05:54 PST 2007
DBD: Generate TCustomDCRTupleProducer start:Thu Nov 15 18:05:54 PST 2007
DBD: Generate TCustomDCRTupleProducer end :Thu Nov 15 18:05:54 PST 2007
DBD: Path not found -- interpret as 'NotPresent'
DBD: Building replicant order column information.
DBD: Building replicant order column information... Done.
DBD: TUPLE={state=NotPresent, path=templatedata\Internet\Sidebars\data\us_homepage}
DBD: TTableSchemaHelper object for [SIDEBARS] found in cache.
DBD: SELECT KEYCOLNAME , KEYCOLVALUE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ? AND KEYCOLNAME IN ( 'ID','LOCALE','PLATFORMS_ID','PAGE_TYPE')
DBD: 0 PK values retrieved from iwdeltracker for templatedata\Internet\Sidebars\data\us_homepage, /default/main/Website/us_uk_22/WORKAREA/content
DBD: DELETE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ?
DBD: -- Deleted
DBD: Filelist walk done
DBD: Stat for group [SIDEBARS_LEFT_TABLET]:
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: Committing database [fndbstg:1521:web]...
DBD: Deployment[Sidebars]
DBD: -----------------------------------
DBD: DCRs inserted : 0
DBD: DCRs updated : 0
DBD: DCRs deleted : 1
DBD: DCRs failed : 0
DBD: DCRs rolled back : 0
DBD: DCRs skipped : 0
DBD: -----------------------------------
DBD: Started : Thu Nov 15 18:05:54 PST 2007
DBD: Finished: Thu Nov 15 18:05:54 PST 2007
DBD:
### IWDataDeploy DONE ###
DBD:
### Sending result ###
ENG: 2007-11-15 18:05:54 PST GMT-08:00 Database deployment execution returned 0
ENG: 2007-11-15 18:05:54 PST GMT-08:00 <<< Completed database deployment Invocation>>>
ENG: 2007-11-15 18:05:54 PST GMT-08:00 doTask returned 0
ENG: 2007-11-15 18:05:54 PST GMT-08:00 Setting final state to TASKDONE
ENG: 2007-11-15 18:05:54 PST GMT-08:00 Job ID=m41 Deployment leg=database Elapsed Time=78 ms <<<
ENG: 2007-11-15 18:05:54 PST GMT-08:00 End logfile [d:\iwhome\OpenDeployNG\log\DataDeploy/Website/us_uk_22\src.Sidebars_22_jstephan_115415.Sidebars.fncmsdev01.to.database.log]
Kindly Advice.
Thanks
John