OD 6.1 DAS Error (Exception occured while executing deployment [deltagen])

Hi Guys,

I am facing problem with OD DAS Deployments

TS 6.7 + OD 6.1 on Win 2000 SP4

I am trying to configure DAS for my DCT through OD GUI by selecting workarea. The deployment runs fine for Base table and creates an entry into "IWTRACKER" table. When it starts deployment for Delta table it rollbacks the deployment.

Logs from iwddd* file:

DBD: Thread for [/default/main/test]: Wed Sep 13 11:58:31 GMT+05:30 2006 Smiley Tongue rocessing item [3].
DBD: args[0]:iwdd=basearea
DBD: args[1]:cfg=Y:/default/main/test/STAGING/templatedata/news/PressRelease/PressRelease_dd.cfg
DBD: args[2]:mytemplatepath=templatedata/news/PressRelease/data
DBD: args[3]:mybasetablenameprefix=DEFAULT_NEWS_PRESSRELEASE
DBD: args[4]:mybasetable=DEFAULT_NEWS_PRESSRELEASE__MAIN_TEST_STAGING
DBD: args[5]:mybasearea=/default/main/test/STAGING
DBD: args[6]:mybasetablenamesuffix=MAIN_TEST_STAGING
DBD: args[7]:need-result=yes
DBD: numArgs=8
DBD: Configuration File: Y:/default/main/test/STAGING/templatedata/news/PressRelease/PressRelease_dd.cfg
DBD: Deployment : basearea
DBD: Deployment : basearea
DBD: Database Vendor set to microsoft-inetuna
DBD: Max Identifier length set to 128 characters.
DBD: SQL datatype for column Path is varchar(255)
DBD: SQL datatype for column IW_State is varchar(255)
DBD: SQL datatype for column articletitle is VARCHAR(255)
DBD: SQL datatype for column articleauthor is VARCHAR(255)
DBD: SQL datatype for column articletopic is VARCHAR(255)
DBD: SQL datatype for column pressrelease is VARCHAR(255)
DBD: SQL datatype for column articlereview1 is VARCHAR(255)
DBD: SQL datatype for column articlereview2 is VARCHAR(255)
DBD: SQL datatype for column articlereview3 is VARCHAR(255)
DBD: SQL datatype for column companyname is VARCHAR(255)
DBD: SQL datatype for column companyurl is VARCHAR(255)
DBD: SQL datatype for column stocksymbol is VARCHAR(255)
DBD: SQL datatype for column logo is VARCHAR(255)
DBD: # of columns: 13
DBD: # of primary key columns specified: 1
DBD: # of groups defined in element: 1
DBD: [Wed Sep 13 11:58:31 GMT+05:30 2006] Begin executing basearea
DBD: Area VPath:/default/main/test/STAGING
DBD: Setting up TDbSchemaSynchronizer.
DBD: Validating cached connection...
DBD: Cached connection OK
DBD: Connected to [mohit-w2ks:1433?database=safari-db]
DBD: Table [DEFAULT_NEWS_PRESSRELEASE__REVIEWS__MAIN_TEST_STAGING] exists.
DBD: Over-riding CREATE statement specified for IWTRACKER.
DBD: Table [iwtracker] exists.
DBD: DEFAULT_NEWS_PRESSRELEASE__REVIEWS__MAIN_TEST_STAGING registered
DBD: Running deployment [basearea]
DBD: extraction type=default
DBD: tuple mode=wide
DBD: area=/default/main/test/STAGING
DBD: /default/main/test/STAGING/templatedata/news/PressRelease/data
DBD: Generate DirectoryContents start:Wed Sep 13 11:58:31 GMT+05:30 2006
DBD: Generate DirectoryContents end :Wed Sep 13 11:58:31 GMT+05:30 2006
DBD: Generate TDCRTupleProducer start:Wed Sep 13 11:58:31 GMT+05:30 2006
DBD: Generate TDCRTupleProducer end :Wed Sep 13 11:58:31 GMT+05:30 2006
DBD: No DCR's found in directory path or visit-directory mode should be modified [Y:/default/main/test/STAGING/templatedata/news/PressRelease/data]
DBD: Stat for group [Reviews]:
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 [mohit-w2ks:1433?database=safari-db]...
DBD: Deployment[basearea]
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: -----------------------------------
DBD: Started : Wed Sep 13 11:58:31 GMT+05:30 2006
DBD: Finished: Wed Sep 13 11:58:31 GMT+05:30 2006
DBD:
### IWDataDeploy DONE ###

DBD: Thread for [/default/main/test]: Wed Sep 13 11:58:31 GMT+05:30 2006 Smiley Tongue rocessing item [4].
DBD: args[0]:mybasetablenameprefix=DEFAULT_NEWS_PRESSRELEASE
DBD: args[1]:need-result=yes
DBD: args[2]:mytemplatepath=templatedata/news/PressRelease/data
DBD: args[3]:iwdd=deltagen
DBD: args[4]:mytablenamesuffix=MAIN_TEST_WORKAREA_TEST_DD
DBD: args[5]:myarea=/default/main/test/WORKAREA/test_dd
DBD: args[6]:mytable=DEFAULT_NEWS_PRESSRELEASE__MAIN_TEST_WORKAREA_TEST_DD
DBD: args[7]:mybasearea=/default/main/test/STAGING
DBD: args[8]:mytablenameprefix=DEFAULT_NEWS_PRESSRELEASE
DBD: args[9]:cfg=Y:/default/main/test/WORKAREA/test_dd/templatedata/news/PressRelease/PressRelease_dd.cfg
DBD: args[10]:mybasetablenamesuffix=MAIN_TEST_STAGING
DBD: args[11]:mybasetable=DEFAULT_NEWS_PRESSRELEASE__MAIN_TEST_STAGING
DBD: numArgs=12
DBD: Configuration File: Y:/default/main/test/WORKAREA/test_dd/templatedata/news/PressRelease/PressRelease_dd.cfg
DBD: Deployment : deltagen
DBD: Deployment : deltagen
DBD: Database Vendor set to microsoft-inetuna
DBD: Max Identifier length set to 128 characters.
DBD: SQL datatype for column Path is varchar(255)
DBD: SQL datatype for column IW_State is varchar(255)
DBD: SQL datatype for column articletitle is VARCHAR(255)
DBD: SQL datatype for column articleauthor is VARCHAR(255)
DBD: SQL datatype for column articletopic is VARCHAR(255)
DBD: SQL datatype for column pressrelease is VARCHAR(255)
DBD: SQL datatype for column articlereview1 is VARCHAR(255)
DBD: SQL datatype for column articlereview2 is VARCHAR(255)
DBD: SQL datatype for column articlereview3 is VARCHAR(255)
DBD: SQL datatype for column companyname is VARCHAR(255)
DBD: SQL datatype for column companyurl is VARCHAR(255)
DBD: SQL datatype for column stocksymbol is VARCHAR(255)
DBD: SQL datatype for column logo is VARCHAR(255)
DBD: # of columns: 13
DBD: # of primary key columns specified: 1
DBD: # of groups defined in element: 1
DBD: [Wed Sep 13 11:58:31 GMT+05:30 2006] Begin executing deltagen
DBD: Area VPath:/default/main/test/WORKAREA/test_dd
DBD: Setting up TDbSchemaSynchronizer.
DBD: Validating cached connection...
DBD: Cached connection OK
DBD: Connected to [mohit-w2ks:1433?database=safari-db]
DBD: Table [DEFAULT_NEWS_PRESSRELEASE__REVIEWS__MAIN_TEST_WORKAREA_TEST_DD] exists.
DBD: Over-riding CREATE statement specified for IWTRACKER.
DBD: Table [iwtracker] exists.
DBD: DEFAULT_NEWS_PRESSRELEASE__REVIEWS__MAIN_TEST_STAGING registered
DBD: DEFAULT_NEWS_PRESSRELEASE__REVIEWS__MAIN_TEST_WORKAREA_TEST_DD not registered
DBD: Registering DEFAULT_NEWS_PRESSRELEASE__REVIEWS__MAIN_TEST_WORKAREA_TEST_DD
DBD: INSERT INTO iwtracker (NAME,BASE,UPDATETIME,BRANCH) VALUES('DEFAULT_NEWS_PRESSRELEASE__REVIEWS__MAIN_TEST_WORKAREA_TEST_DD','DEFAULT_NEWS_PRESSRELEASE__REVIEWS__MAIN_TEST_STAGING',0, '/DEFAULT/MAIN/TEST/WORKAREA')
DBD: Rows updated: 1
DBD: Running deployment [deltagen]
DBD: extraction type=differential
DBD: tuple mode=wide-diff
DBD: area=/default/main/test/WORKAREA/test_dd
DBD: base area=/default/main/test/STAGING
DBD: /default/main/test/WORKAREA/test_dd/templatedata/news/PressRelease/data

DBD: ERROR:Exception occured while executing deployment [deltagen]: com.interwoven.ju100.util.TFSPoint is in error state - vpath not found (No server found)
DBD: ERROR:
java.lang.IllegalArgumentException: com.interwoven.ju100.util.TFSPoint is in error state - vpath not found (No server found)
at com.interwoven.ju100.util.TSCIUser.Validate(TSCIUser.java:117)
at com.interwoven.ju100.util.TFSPoint.IsArea(TFSPoint.java:169)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:755)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:474)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:261)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:194)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:542)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)

DBD: Error occured in area outside TDbAgent consumer (explicit rollback initiated)
DBD: Stat for group [Reviews]:
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 [mohit-w2ks:1433?database=safari-db]...
DBD: Deployment[deltagen]
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: -----------------------------------
DBD: Started : Wed Sep 13 11:58:31 GMT+05:30 2006
DBD: Finished: Wed Sep 13 11:58:31 GMT+05:30 2006
DBD:
### IWDataDeploy FAILED ###

Any pointers to resolve this issue?

Thanks much,

Mohit

Find more posts tagged with

Comments

Nidhi_Agrawal

Hi mohit,

In ur log the insert command is generating as
INSERT INTO iwtracker (NAME,BASE,UPDATETIME,BRANCH) VALUES('DEFAULT_NEWS_PRESSRELEASE__REVIEWS__MAIN_T EST_WORKAREA_TEST_DD','DEFAULT_NEWS_PRESSRELEASE__ REVIEWS__MAIN_TEST_STAGING',0, '/DEFAULT/MAIN/TEST/WORKAREA')

for branch parameter u r passing a workarea path.

Better put here code snippet from deployment configuration file.

mohit_maniar

Hi Nidhi,

I have attached configuration file [PressRelease_dd.txt] which DAS created at path Y:\default\main\test\WORKAREA\test_dd\templatedata\news\PressRelease.

Thanks much,

Mohit