Submit DCR does not update staging areas tables

Hi,

I am new to Teamsite/Opendeploy admin and currently facing a problem with a particular DCR.

When I modify the DCR, the workarea tables get updates properly. however when I submit the DCR, staging area tables do not get updated with the latest changes.

I checked the iwdd log but it does not indicate any errors. As per the log the table update is successful but when I look at the database the table is not actually updated.

Any help will be greatly appreciated.

Following is the snippets from the iwdd log for deployment of the specific DCR.

---------------------------------------------------------------------
DBD: Thread for [/default/main/dev]: Wed Aug 09 09:14:03 EDT 2006 Smiley Tongue

rocessing item [78].
DBD: args[0]:mysubmitlist=/var/tmp/ddt6787.tmp
DBD: args[1]:mybasetablenameprefix=DEFAULT_COMMENTARY_ARRANGE_ARTICLES_INDEX
DBD: args[2]:need-result=yes
DBD: args[3]:iwdd=submitlist
DBD: args[4]:mytablenamesuffix=MAIN_DEV_WORKAREA_PIMCO
DBD: args[5]:myarea=/default/main/dev/WORKAREA/pimco
DBD: args[6]:mytable=DEFAULT_COMMENTARY_ARRANGE_ARTICLES_INDEX__MAIN_DEV_WORKAREA_PIMCO
DBD: args[7]:mytablenameprefix=DEFAULT_COMMENTARY_ARRANGE_ARTICLES_INDEX
DBD: args[8]:cfg=/iwmnt/default/main/dev/WORKAREA/pimco/templatedata/commentary/arrange_articles_index/arrange_articles_index_dd.cfg
DBD: args[9]:mybasetablenamesuffix=MAIN_DEV_STAGING
DBD: args[10]:mybasetable=DEFAULT_COMMENTARY_ARRANGE_ARTICLES_INDEX__MAIN_DEV_STAGING
DBD: numArgs=11
DBD: Configuration File: /iwmnt/default/main/dev/WORKAREA/pimco/templatedata/commentary/arrange_articles_index/arrange_articles_inde
x_dd.cfg
DBD: Deployment : submitlist
DBD: Deployment : submitlist
DBD: Database Vendor set to oracle
DBD: SQL datatype for column IW_State is varchar(255)
DBD: SQL datatype for column dcrPath is VARCHAR(255)
DBD: SQL datatype for column category is VARCHAR(255)
DBD: SQL datatype for column subCategory1 is VARCHAR(255)
DBD: SQL datatype for column commItem1 is VARCHAR(255)
DBD: SQL datatype for column subCategory2 is VARCHAR(255)
DBD: SQL datatype for column commItem2 is VARCHAR(255)
DBD: SQL datatype for column subCategory3 is VARCHAR(255)
DBD: SQL datatype for column commItem3 is VARCHAR(255)
DBD: SQL datatype for column subCategory4 is VARCHAR(255)
DBD: SQL datatype for column commItem4 is VARCHAR(255)
DBD: SQL datatype for column subCategory5 is VARCHAR(255)
DBD: SQL datatype for column commItem5 is VARCHAR(255)
DBD: SQL datatype for column subCategory6 is VARCHAR(255)
DBD: SQL datatype for column commItem6 is VARCHAR(255)
DBD: SQL datatype for column last_updated is DATE
DBD: # of columns: 16
DBD: # of primary key columns specified: 1
DBD: # of groups defined in element: 1
DBD: [Wed Aug 09 09:14:03 EDT 2006] Begin executing submitlist
DBD: Area VPath:/default/main/dev/WORKAREA/pimco
DBD: Setting up TDbSchemaSynchronizer.
DBD: Validating cached connection...
DBD: Cached connection OK
DBD: Connected to [168.114.240.22:1521 Smiley Tongue

IMWEB]
DBD: SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWT_21193D10B98B'
DBD: Table [IWT_21193D10B98B] exists.
DBD: SELECT * FROM USER_TABLES WHERE TABLE_NAME='IWTRACKER'
DBD: Table [iwtracker] exists.
DBD: DEFAULT_COMMENTARY_ARRANGE_ARTICLES_INDEX__MASTER__MAIN_DEV_STAGING registered
DBD: DEFAULT_COMMENTARY_ARRANGE_ARTICLES_INDEX__MASTER__MAIN_DEV_WORKAREA_PIMCO registered
DBD: Running deployment [submitlist]
DBD: extraction type=full
DBD: tuple mode=wide
DBD: area=/default/main/dev/WORKAREA/pimco
DBD: filelist=[/var/tmp/ddt6787.tmp]
DBD: /default/main/dev/WORKAREA/pimco/templatedata/commentary/arrange_articles_index/data/PMNIndex
DBD: Generate DirectoryContents start:Wed Aug 09 09:14:03 EDT 2006
DBD: Generate DirectoryContents end :Wed Aug 09 09:14:03 EDT 2006
DBD: Generate TDCRTupleProducer start:Wed Aug 09 09:14:03 EDT 2006
DBD: Generate TDCRTupleProducer end :Wed Aug 09 09:14:03 EDT 2006
DBD: Building replicant order column information.
DBD: Building replicant order column information... Done.
DBD:
DBD: TTableSchemaHelper object for [IWT_1D09DBD1EDB6] found in cache.
DBD: RowsExistForPath Smiley Frustrated

ELECT COUNT(*) FROM IWT_1D09DBD1EDB6 WHERE dcrPath = ?
DBD: SELECT NAME FROM iwtracker WHERE BASE='DEFAULT_COMMENTARY_ARRANGE_ARTICLES_INDEX__MASTER__MAIN_DEV_STAGING'
DBD: child: DEFAULT_COMMENTARY_ARRANGE_ARTICLES_INDEX__MASTER__MAIN_DEV_WORKAREA_BUILD
DBD: child: DEFAULT_COMMENTARY_ARRANGE_ARTICLES_INDEX__MASTER__MAIN_DEV_WORKAREA_PIMCO
DBD: Checking for exclude list Smiley Very Happy

EFAULT_COMMENTARY_ARRANGE_ARTICLES_INDEX__MASTER__MAIN_DEV_WORKAREA_BUILD
DBD: Original table name: DEFAULT_COMMENTARY_ARRANGE_ARTICLES_INDEX__MASTER__MAIN_DEV_WORKAREA_BUILD
DBD: CheckForRow Smiley Frustrated

ELECT COUNT(*) FROM IWT_211124F9C9B5 WHERE dcrPath = ?
DBD: TTableSchemaHelper object for [IWT_211124F9C9B5] found in cache.
DBD: CheckForRow: count = 1
DBD: Adding _MAIN_DEV_WORKAREA_BUILD to exclude propagation list.
DBD: Checking for exclude list Smiley Very Happy

EFAULT_COMMENTARY_ARRANGE_ARTICLES_INDEX__MASTER__MAIN_DEV_WORKAREA_PIMCO
DBD: SELECT NAME FROM iwtracker WHERE BASE='DEFAULT_COMMENTARY_ARRANGE_ARTICLES_INDEX__MASTER__MAIN_DEV_STAGING'
DBD: child: DEFAULT_COMMENTARY_ARRANGE_ARTICLES_INDEX__MASTER__MAIN_DEV_WORKAREA_BUILD
DBD: child: DEFAULT_COMMENTARY_ARRANGE_ARTICLES_INDEX__MASTER__MAIN_DEV_WORKAREA_PIMCO
DBD: Checking if _MAIN_DEV_WORKAREA_BUILD exists in the exclude propagate list.
DBD: Row exists in DEFAULT_COMMENTARY_ARRANGE_ARTICLES_INDEX__MASTER__MAIN_DEV_WORKAREA_BUILD -- leave alone
DBD: Excluding propagation to current delta...
DBD: TTableSchemaHelper object for [IWT_21193D10B98B] found in cache.
DBD: SELECT Smiley Frustrated

ELECT IW_State,category,subCategory1,commItem1,subCategory2,commItem2,subCategory3,commItem3,subCategory4,commItem4,sub
Category5,commItem5,subCategory6,commItem6,TO_CHAR(last_updated,'yyyy-MM-dd hh:mm:ss') AS last_updated,dcrPath FROM IWT_1D09DBD1EDB6
WHERE dcrPath = ?
DBD: Recurse select: pIndex = 0, value = templatedata/commentary/arrange_articles_index/data/PMNIndex
DBD: BuildTuples:executeQuery returned valid result set
DBD: TTableSchemaHelper object for [IWT_21193D10B98B] found in cache.
DBD: BuildTuples:BuildRows returned: true
DBD: DeleteForUpdate: skipping root group
DBD: TTableSchemaHelper object for [IWT_1D09DBD1EDB6] found in cache.
DBD: TTableSchemaHelper object for [IWT_1D09DBD1EDB6] found in cache.
DBD: SelectCurrentRowsUsingPath: SELECT IW_State,category,subCategory1,commItem1,subCategory2,commItem2,subCategory3,commItem3,subCa
tegory4,commItem4,subCategory5,commItem5,subCategory6,commItem6,TO_CHAR(last_updated,'yyyy-MM-dd hh:mm:ss') AS last_updated,dcrPath
FROM IWT_1D09DBD1EDB6 WHERE dcrPath = ? ORDER BY dcrPath
DBD: SelectCurrentRowsUsingPath: 1 rows selected.
DBD: Validating cached connection...
DBD: Cached connection OK
DBD: Class pimco.IWDataDeployCurrentTime returned '2006-08-09 09:14:03' as the value for 'last_updated' in table IWT_1D09DBD1EDB6
DBD: DoesRowExist Smiley Frustrated

ELECT COUNT(*) FROM IWT_1D09DBD1EDB6 WHERE dcrPath = ? AND IW_State = ? AND category = ? AND subCategory1 = ?
AND commItem1 = ? AND subCategory2 = ? AND commItem2 = ? AND subCategory3 = ? AND commItem3 = ? AND subCategory4 = ? AND comm
Item4 = ? AND subCategory5 = ? AND commItem5 is null AND subCategory6 = ? AND commItem6 is null AND last_updated = ?
DBD: Column: dcrPath, field: path, Index: 1,Converting 'templatedata/commentary/arrange_articles_index/data/PMNIndex' to VARCHAR
DBD: Column: IW_State, field: state, Index: 2,Converting 'Modified' to VARCHAR
DBD: Column: category, field: category, Index: 3,Converting 'Portfolio Manager Newsletters' to VARCHAR
DBD: Column: subCategory1, field: subCategory1, Index: 4,Converting 'Bill Gross's Investment Outlook' to VARCHAR
DBD: Column: commItem1, field: commItem1, Index: 5,Converting 'The End of History and the Last Bond Bull Market-08/01/2006' to VARC
HAR
DBD: Column: subCategory2, field: subCategory2, Index: 6,Converting 'Global Central Bank Focus (formerly Fed Focus)' to VARCHAR
DBD: Column: commItem2, field: commItem2, Index: 7,Converting 'Don't Shoot Ben, and Don't Short Bonds-08/01/2006' to VARCHAR
DBD: Column: subCategory3, field: subCategory3, Index: 8,Converting 'Emerging Markets Watch' to VARCHAR
DBD: Column: commItem3, field: commItem3, Index: 9,Converting 'End of the Asset Class...Hardly-06/01/2006' to VARCHAR
DBD: Column: subCategory4, field: subCategory4, Index: 10,Converting 'NFJ's Paying Dividends' to VARCHAR
DBD: Column: commItem4, field: commItem4, Index: 11,Converting 'Dividends: Room to Rise-07/07/2006' to VARCHAR
DBD: Column: subCategory5, field: subCategory5, Index: 12,Converting '(None)' to VARCHAR
DBD: Column: subCategory6, field: subCategory6, Index: 13,Converting '(None)' to VARCHAR
DBD: Column: last_updated, value-from-callout: iwov:dd:java Smiley Tongue

imco.IWDataDeployCurrentTime, Index: 14,Converting '2006-08-09 09:14:03
' to TIMESTAMP
DBD: UPDATE IWT_1D09DBD1EDB6 SET IW_State = ? , category = ? , subCategory1 = ? , commItem1 = ? , subCategory2 = ? , commItem2 = ? ,
subCategory3 = ? , commItem3 = ? , subCategory4 = ? , commItem4 = ? , subCategory5 = ? , commItem5 = ? , subCategory6 = ? , commIte
m6 = ? , last_updated = ? WHERE dcrPath = ? AND IW_State = ? AND category = ? AND subCategory1 = ? AND commItem1 = ? AND subCa
tegory2 = ? AND commItem2 = ? AND subCategory3 = ? AND commItem3 = ? AND subCategory4 = ? AND commItem4 = ? AND subCategory5 =
? AND commItem5 is null AND subCategory6 = ? AND commItem6 is null AND last_updated = ?
DBD: Column: IW_State, field: state, Index: 1,Converting 'Modified' to VARCHAR
DBD: Column: category, field: category, Index: 2,Converting 'Portfolio Manager Newsletters' to VARCHAR
DBD: Column: subCategory1, field: subCategory1, Index: 3,Converting 'Bill Gross's Investment Outlook' to VARCHAR
DBD: Column: commItem1, field: commItem1, Index: 4,Converting 'The End of History and the Last Bond Bull Market-08/01/2006' to VARC
HAR
DBD: Column: subCategory2, field: subCategory2, Index: 5,Converting 'Global Central Bank Focus (formerly Fed Focus)' to VARCHAR
DBD: Column: commItem2, field: commItem2, Index: 6,Converting 'Don't Shoot Ben, and Don't Short Bonds-08/01/2006' to VARCHAR
DBD: Column: subCategory3, field: subCategory3, Index: 7,Converting 'Emerging Markets Watch' to VARCHAR
DBD: Column: commItem3, field: commItem3, Index: 8,Converting 'End of the Asset Class...Hardly-06/01/2006' to VARCHAR
DBD: Column: subCategory4, field: subCategory4, Index: 9,Converting 'NFJ's Paying Dividends' to VARCHAR
DBD: Column: commItem4, field: commItem4, Index: 10,Converting 'Dividends: Room to Rise-07/07/2006' to VARCHAR
DBD: Column: subCategory5, field: subCategory5, Index: 11,Converting '(None)' to VARCHAR
DBD: Column: commItem5, field: commItem5, Index: 12,Converting '' to VARCHAR
DBD: Column: subCategory6, field: subCategory6, Index: 13,Converting '(None)' to VARCHAR
DBD: Column: commItem6, field: commItem6, Index: 14,Converting '' to VARCHAR
DBD: Column: last_updated, value-from-callout: iwov:dd:java Smiley Tongue

imco.IWDataDeployCurrentTime, Index: 15,Converting '2006-08-09 09:14:03
' to TIMESTAMP
DBD: Column: dcrPath, field: path, Index: 16,Converting 'templatedata/commentary/arrange_articles_index/data/PMNIndex' to VARCHAR
DBD: Column: IW_State, field: state, Index: 17,Converting 'Original' to VARCHAR
DBD: Column: category, field: category, Index: 18,Converting 'Portfolio Manager Newsletters' to VARCHAR
DBD: Column: subCategory1, field: subCategory1, Index: 19,Converting 'Bill Gross's Investment Outlook' to VARCHAR
DBD: Column: commItem1, field: commItem1, Index: 20,Converting 'The End of History and the Last Bond Bull Market-08/01/2006' to VAR
CHAR
DBD: Column: subCategory2, field: subCategory2, Index: 21,Converting 'Global Central Bank Focus (formerly Fed Focus)' to VARCHAR
DBD: Column: commItem2, field: commItem2, Index: 22,Converting 'A Kind Word for the Austrian School-07/01/2006' to VARCHAR
DBD: Column: subCategory3, field: subCategory3, Index: 23,Converting 'Emerging Markets Watch' to VARCHAR
DBD: Column: commItem3, field: commItem3, Index: 24,Converting 'End of the Asset Class...Hardly-06/01/2006' to VARCHAR
DBD: Column: subCategory4, field: subCategory4, Index: 25,Converting 'NFJ's Paying Dividends' to VARCHAR
DBD: Column: commItem4, field: commItem4, Index: 26,Converting 'Dividends: Room to Rise-07/07/2006' to VARCHAR
DBD: Column: subCategory5, field: subCategory5, Index: 27,Converting '(None)' to VARCHAR
DBD: Column: subCategory6, field: subCategory6, Index: 28,Converting '(None)' to VARCHAR
DBD: Column: last_updated, value-from-callout: iwov:dd:java Smiley Tongue

imco.IWDataDeployCurrentTime, Index: 29,Converting '2006-08-04 03:08:17
' to TIMESTAMP
DBD: -- Updated
DBD: Filelist walk done
DBD: Filelist /var/tmp/ddt6787.tmp deleted
DBD: UPDATE iwtracker SET UPDATETIME='Wed Aug 09 09:14:03 EDT 2006' WHERE NAME='DEFAULT_COMMENTARY_ARRANGE_ARTICLES_INDEX__MASTER__M
AIN_DEV_WORKAREA_PIMCO'
DBD: 1 row(s) updated.
DBD: Stat for group [Master]:
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 [168.114.240.22:1521 Smiley Tongue

IMWEB]...
DBD: Deployment[submitlist]
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 : Wed Aug 09 09:14:03 EDT 2006
DBD: Finished: Wed Aug 09 09:14:03 EDT 2006
DBD:
### IWDataDeploy DONE ###

Find more posts tagged with

Comments

There are no comments yet