I am on TS6.7.1 with OD6.1 on win 2003 sp1
I am trying to do a general DAS deployment , for starting it works fine.
I am with a simple DCT which has a Text field ( Visual format text field).
As long as the end user cut and pastes text into this field the text get deployed into database with out a problem.But if there is an Image in the text field deployment fails.
I have defined data-type="text" for this field, but it still gives an error, i know somany have seen this problem, whats w rok around please??
here is the error.
DBD: ERROR:
java.sql.SQLException: [DLINT05]The text, ntext, and image data types cannot be compared or sorted, except when using IS NULL or LIKE operator.
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.g.if(Unknown Source)
at com.inet.tds.g.a(Unknown Source)
at com.inet.tds.g.for(Unknown Source)
at com.inet.tds.b.new(Unknown Source)
at com.inet.tds.b.executeQuery(Unknown Source)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.DoesRowExist(TDbSchemaUpdateHelper.java:1505)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.UpdateOneRow(TDbSchemaUpdateHelper.java:807)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.DoUpdate(TDbSchemaUpdateHelper.java:728)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoRealUpdate(TDbSchemaGroupCfg.java:827)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoUpdate(TDbSchemaGroupCfg.java:852)
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:455)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:334)
at com.interwoven.dd100.dd.TDbSchemaSynchronizer.WriteTupleInternal(TDbSchemaSynchronizer.java:259)
at com.interwoven.dd100.dd.TDbSchemaSynchronizer.WriteTuple(TDbSchemaSynchronizer.java:178)
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:974)
at com.interwoven.dd100.dd.TAgentClient.ProcessOneFileList(TAgentClient.java:581)
at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:538)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:483)
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
oUpdate() failed for group [PressRelease].
DBD: -- Failed
DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:Unable to process TeamSite source templatedata/Upload/PressRelease/data/gfsgfdsgfd, obtained from filelist=C:\WINDOWS\Temp\ddt37798.tmp
DBD: Filelist walk done
DBD: Filelist C:\WINDOWS\Temp\ddt37798.tmp deleted
DBD: ERROR:deployment [deltaupdate] FAILED
DBD: Error occured in area outside TDbAgent consumer (explicit rollback initiated)
Thanks
