Hey,
We have an implementation where we run an "archive workflow" on a particular DCR. It copies the DCR to data/archive folder, deletes the original DCR and then invokes datadeploy. Intention is to delete the specific record from database as well. But I'm getting following datadeploy error:
DBD: extraction type=full
DBD: tuple mode=wide
DBD: area=/default/main/Content/WORKAREA/en_US
DBD: filelist=[/opt/iw-home/servletd/temp/dd-891425-59032.list]
DBD: /default/main/Content/WORKAREA/en_US/templatedata/Spas/TourSpa/data/en_US/11111_TourSpa
DBD: Generate DirectoryContents start:Thu Jun 17 01:05:52 CDT 2010
DBD: Generate DirectoryContents end :Thu Jun 17 01:05:52 CDT 2010
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/Spas/TourSpa/data/en_US/11111_TourSpa}
DBD: TTableSchemaHelper not found in cache for [ts_dcr_map]. Creating new.
DBD: SELECT
ELECT ctyhocn,path,locale,dcr_id FROM ts_dcr_map WHERE path = ?
DBD: Recurse select: pIndex = 0, value = templatedata/Spas/TourSpa/data/en_US/11111_TourSpa
DBD: BuildTuples:executeQuery returned valid result set
DBD: TTableSchemaHelper object for [ts_dcr_map] found in cache.
DBD: BuildTuples:BuildRows returned: true
DBD: TTableSchemaHelper not found in cache for [ts_spa_page_cd]. Creating new.
DBD: ERROR:NumberFormatException occured while converting [null] for column [spa_id].
DBD: TTableSchemaHelper object for [ts_spa_page_cd] found in cache.
DBD: SELECTELECT spa_id,page_cd, dcr_id FROM ts_spa_page_cd WHERE spa_id = ? AND page_cd = ?
DBD: ERROR:Exception occured: null
DBD: ERROR:
java.lang.NullPointerException
at com.interwoven.dd100.dd.TDbSchemaGroupInfoNode.BuildTuples(TDbSchemaGroupInfoNode.java:142)
at com.interwoven.dd100.dd.TDbSchemaGroupInfo.ProcessTopLevelGroups2(TDbSchemaGroupInfo.java:608)
at com.interwoven.dd100.dd.TDbSchemaGroupInfo.PrepareForDelete(TDbSchemaGroupInfo.java:93)
at com.interwoven.dd100.dd.TDbSchemaCfg.BuildGroupInfo(TDbSchemaCfg.java:709)
at com.interwoven.dd100.dd.TDbSchemaCfg.DeleteUsingPathColumnInRootGroup(TDbSchemaCfg.java:616)
at com.interwoven.dd100.dd.TDbSchemaCfg.Delete(TDbSchemaCfg.java:569)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:410)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:336)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:399)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:388)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:978)
at com.interwoven.dd100.dd.TAgentClient.ProcessOneFileList(TAgentClient.java:624)
at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:581)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:526)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:289)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:178)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:582)
at com.interwoven.dd100.dd.IWDataDeploy.run(IWDataDeploy.java:608)
at java.lang.Thread.run(Thread.java:595)DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:Unable to process TeamSite source templatedata/Spas/TourSpa/data/en_US/11111_TourSpa, obtained from filelist=/opt/iw-home/servletd/temp/dd-891425-59032.list. However if I directly run datadeploy from cmd prompt, it successfully deletes the record. Please help.
