Hi,
I am using datadeploy to deploy the content to DB. While writing using the CLOB datatype to one of the columns , i get the error:
DBD: ERROR:Error writing to CLOB : (Teamsite Path of the form) (The parameter is incorrect)
DBD:
DBD: *******************************************************
DBD: SQLException occured in TDbSchemaGroupCfg
DBD: Exception Message: SQL string creation failure when converting value of column: (Column_name)
DBD: Vendor Error Code: 0
DBD: SQL state: null
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: SQL string creation failure when converting value of column: (Column_name)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.UpdateOneRow(TDbSchemaUpdateHelper.java:912)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.DoUpdate(TDbSchemaUpdateHelper.java:763)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoRealUpdate(TDbSchemaGroupCfg.java:846)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoUpdate(TDbSchemaGroupCfg.java:871)
at com.interwoven.dd100.dd.TDbSchemaCfg.InsertWithGroupTree(TDbSchemaCfg.java:448)
at com.interwoven.dd100.dd.TDbSchemaCfg.Insert(TDbSchemaCfg.java:409)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:457)
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:1083)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:530)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:290)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:181)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:601)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)
DBD: ERROR:DoUpdate() failed for group [page].
DBD: -- Failed
DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:Unable to process TeamSite source
templatedata/
DBD: ERROR:deployment [DeployDCRs] FAILED
DBD: Error occured in area outside TDbAgent consumer (explicit rollback initiated)
DBD: Stat for group [page]:
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
The XML responsible for deployment reads:
<column name="column_name" allows-null="yes" is-url="yes" data-type="CLOB" value="file://$mycfile/>
It was running perfectly fine and was able to convert to CLOB and was able to write to DB table but started failing all of a sudden few days back.
