Hi,
I am running a standalone deployment to SQL server 2000. The deployment works fine under few conditions. One of the field in DCR is
detail body. The field is mapped to column
Body in a table in database. The data type of the column is
char(5000). Now, if I put character till 4000 characters, DD works fine. But, asa I put 4001 charaters it throws a daty type conversion error. Log says
DBD:
DBD: *******************************************************
DBD: SQLException occured in TDbSchemaGroupCfg
DBD: Exception Message: [WNY02KDEV3]Disallowed implicit conversion from data type ntext to data type char, table 'XXXX.XXXX.ctmContent', column 'Body'. Use the CONVERT function to run this query.
DBD: Vendor Error Code: 260
DBD: SQL state: 42000
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: [WNY02KDEV3]Disallowed implicit conversion from data type ntext to data type char, table 'MHRSGEO.mhrsuser.ctmContent', column 'Body'. Use the CONVERT function to run this query.
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.executeUpdate(Unknown Source)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.InsertOneRow(TDbSchemaUpdateHelper.java:1138)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.InsertNewRows(TDbSchemaUpdateHelper.java:1305)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoRealUpdate(TDbSchemaGroupCfg.java:824)
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.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.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:545)
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 [ctmContent].
DBD: -- Failed
DBD: ERROR:WriteTuple failure to consumer[0]
DBD: Rollback batch...
DBD: Committing database [10.203.61.62:1433?database=MHRSGEO]...
DBD: Deployment[Article_Text]
DBD: -----------------------------------
DBD: DCRs inserted : 0
DBD: DCRs updated : 0
DBD: DCRs deleted : 0
DBD: DCRs failed : 1
DBD: DCRs rolled back : 1
DBD: DCRs skipped : 0
DBD: -----------------------------------
DBD: Started : Fri Aug 31 12:28:09 EDT 2007
DBD: Finished: Fri Aug 31 12:28:10 EDT 2007
DBD:
### IWDataDeploy Completed With Failures ###
Does anybody got in to same problem?
Why DD takes the field detail body filed as ntext ?
Is there any way, we can use the DB functions in DD config xml?
Env: teamsite 6.5 on windows server 2003
OD 6.1.0 to SQL server 2000
Thanks in advance,
Amit
