Hello,
I'm trying to datadeploy to a table. In the past it has been working fine, however, I just added a field (dcr_filepath) to the table and am setting
it to the "path" field in my dbschema. I have another field (guid) which is the primary key, however, when it checks for an existing row, it
is selecting on dcr_filepath instead of guid....any idea why? I've attached some snippets below:
--- BEGIN DBSCHEMA SNIPPET ---
<source>
<!-- Pull data tuples from TeamSite Extended Attributes -->
<teamsite-templating-records custom="yes" options="full,wide" area="$area" print-parse-debug="yes" include-extended-attributes="yes" >
<path filelist="$filelist" visit-directory="deep" delete-after-use="no"/>
</teamsite-templating-records>
</source>
<destinations>
<!-- include the DB stuff from the include file -->
<database use="$db^">
<dbschema>
<!-- ASSET TABLE -->
<group name="asset" table="ASSET" root-group="yes">
<attrmap>
<column name="active_flag" value="Y" />
<column name="last_update_user" value="teamsite" />
<column name="theme_uid" value-from-field="TeamSite/Metadata/global/theme"/>
<column name="asset_url" value-from-field="TeamSite/Metadata/generated_page_url" />
<column name="asset_type_uid" value="20" /> <!-- Type 20 is Article -->
<column name="dcr_filepath" value-from-field="path" /> <column name="guid" value-from-field="TeamSite/Metadata/global/guid"/>
</attrmap>
<keys>
<primary-key>
<key-column name="guid" /> </primary-key>
</keys>
</group>
--- DBSCHEMA SNIPPET END --
--- BEGIN LOG SNIPPET---
TTableSchemaHelper object for [ASSET] found in cache.
RowsExistForPath
ELECT COUNT(*) FROM ASSET WHERE dcr_filepath = ?INSERT:INSERT INTO ASSET(active_flag,last_update_user,theme_uid,asset_url,asset_type_uid,dcr_filepath,guid) VALUES (?,?,?,?,?,?,?)
Column: active_flag, literal: Y, Index: 1,Converting 'Y' to VARCHAR
Column: last_update_user, literal: teamsite, Index: 2,Converting 'teamsite' to VARCHAR
Column: theme_uid, field: TeamSite/Metadata/global/theme, Index: 3,null
Column: asset_url, field: TeamSite/Metadata/generated_page_url, Index: 4,Converting '/test_me.html' to VARCHAR
Column: asset_type_uid, literal: 20, Index: 5,Converting '20' to DECIMAL
Column: dcr_filepath, field: path, Index: 6,Converting 'templatedata\WeddingChannel.com Assets\article_1e\data\iwDCR0_121452' to VARCHAR
Column: guid, field: TeamSite/Metadata/global/guid, Index: 7,Converting '496' to DECIMAL
*******************************************************
SQLException occured in TDbSchemaGroupCfg
Exception Message: ORA-00001: unique constraint (DELLAJAMES.ASSET_PK) violated
Vendor Error Code: 1
SQL state: 23000
*******************************************************
*******STACK TRACE*************
java.sql.SQLException: ORA-00001: unique constraint (DELLAJAMES.ASSET_PK) violated
at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:168)
at oracle.jdbc.ttc7.TTIoer.processError(TTIoer.java:208)
at oracle.jdbc.ttc7.Oall7.receive(Oall7.java:543)
at oracle.jdbc.ttc7.TTC7Protocol.doOall7(TTC7Protocol.java:1405)
at oracle.jdbc.ttc7.TTC7Protocol.parseExecuteFetch(TTC7Protocol.java:822)
at oracle.jdbc.driver.OracleStatement.executeNonQuery(OracleStatement.java:1446)
at oracle.jdbc.driver.OracleStatement.doExecuteOther(OracleStatement.java:1371)
at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1900)
at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:363)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsertForColumnArray(TDbSchemaGroupCfg.java:1273)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsert(TDbSchemaGroupCfg.java:1151)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoInsert(TDbSchemaGroupCfg.java:1063)
at com.interwoven.dd100.dd.TDbSchemaCfg.InsertWithGroupTree(TDbSchemaCfg.java:456)
at com.interwoven.dd100.dd.TDbSchemaCfg.Insert(TDbSchemaCfg.java:409)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:474)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:333)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:398)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:387)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:962)
at com.interwoven.dd100.dd.TAgentClient.ProcessOneFileList(TAgentClient.java:569)
at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:529)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:474)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:256)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:188)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:520)
at com.interwoven.dd100.dd.TWorkItem.DoIt(TWorkItem.java:165)
at com.interwoven.dd100.dd.TLonelyWorker.run(TLonelyWorker.java:49)
at java.lang.Thread.run(Thread.java:479)
ERROR
oInsert() failed for group [asset].
-- Failed
--- END LOG SNIPPET ---
