Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
THRUST SERVICES & TOOLS
CLOUD EDITIONS
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Web CMS (TeamSite)
repetitive column in DAS table exception
Bhargav Coca
I am on TS 6.5 win 2k3 with od6.0.2, I have this exception in my generated table, can any one help me out from this. Thank you in advance
java.sql.SQLException: [BLSFODEVSQL02]Column names in each table must be unique. Column name 'path' in table 'DEFAULT_GENERAL_WEBCONTENT__RELATEDATTACHMENTS__MAIN_MARKETING_WORKAREA_CPP' is specified more than once.
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.a.a(Unknown Source)
at com.inet.tds.a.executeUpdate(Unknown Source)
at com.interwoven.dd100.dd.TableSchema.CreateViaSql(TableSchema.java:294)
at com.interwoven.dd100.dd.TableSchema.CreateViaSql(TableSchema.java:257)
at com.interwoven.dd100.dd.TDbSchemaAgent.CreateTableForGroup(TDbSchemaAgent.java:257)
at com.interwoven.dd100.dd.TDbSchemaAgent.CreateTablesWithHierarchy(TDbSchemaAgent.java:222)
at com.interwoven.dd100.dd.TDbSchemaAgent.Prepare(TDbSchemaAgent.java:191)
at com.interwoven.dd100.dd.TDbSchemaAgent.<init>(TDbSchemaAgent.java:131)
at com.interwoven.dd100.dd.TDbSchemaSynchronizer.<init>(TDbSchemaSynchronizer.java:48)
at com.interwoven.dd100.dd.TConsumerManager.getDbAgentBasedOnGroupUpdate(TConsumerManager.java:528)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumer(TConsumerManager.java:586)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumersForOneDeployment(TConsumerManager.java:191)
at com.interwoven.dd100.dd.TConsumerManager.SetupConsumers(TConsumerManager.java:133)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:105)
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)
DAS: ERROR:ERROR:Failed to create [DEFAULT_GENERAL_WEBCONTENT__RELATEDATTACHMENTS__MAIN_MARKETING_WORKAREA_CPP].
DAS: Error occured in TDbSchemaSynchronizer
DAS: ERROR:TDbSchemaSynchronizer create failure.
Thank you
Find more posts tagged with
Comments
stefanmaier
Hi,
if you generate the datadeploy tables, you get the following things in your sql server:
- two tables for template and branch (one for workarea, one for staging)
- one table view
- three data records in the iwtracker table (one for the table view, two for the tables)
Check, if one of these things already exists in your environment.
Regards
Stefan
Bhargav Coca
There is no entry for my table for my WEBCONTENT tmeplate in my iwtracker. I got rid of the exception above now. cuz i have a field called "path" which was duplicated, so i changed its name. Now i have a different exception now, please look at the attached logfile. Thanks in advance.
stefanmaier
Hi,
reason is given in log:
DAS: WARNING:Value for [BodyContent] exceeds column width [ 990 > 255]
...
DAS: *******************************************************
DAS: SQLException occured in TDbSchemaGroupCfg
DAS: Exception Message: [BLSFODEVSQL02]String or binary data would be truncated.
DAS: Vendor Error Code: 8152
Regards
Stefan
Bhargav Coca
no, thats just a warning, not creating any big errors, but i have this major exception need to take care, please tell me where this exception is coming from.
java.sql.SQLException: [BLSFODEVSQL02]String or binary data would be truncated.
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.b.byte(Unknown Source)
at com.inet.tds.b.executeUpdate(Unknown Source)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformInsertForColumnArray(TDbSchemaGroupCfg.java:1284)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.InsertForSingleReplicant(TDbSchemaGroupCfg.java:1523)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.PerformReplicantInsert(TDbSchemaGroupCfg.java:1339)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoInsert(TDbSchemaGroupCfg.java:1135)
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:475)
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.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)
DAS: ERROR
oInsert() failed for group [Body].
DAS: -- Failed
DAS: ERROR:WriteTuple failure to consumer[0]
DAS: ERROR:Unable to process TeamSite source templatedata/general/webcontent/data
DAS: ERROR:deployment [basearea] FAILED
DAS: Error occured in area outside TDbAgent consumer (explicit rollback initiated)
DAS: UPDATE iwtracker SET UPDATETIME='Thu May 19 08:46:53 CDT 2005' WHERE NAME='DEFAULT_GENERAL_WEBCONTENT__WEBCONTENT__MAIN_MARKETING_STAGING'
DAS: 1 row(s) updated.
DAS: UPDATE iwtracker SET UPDATETIME='Thu May 19 08:46:53 CDT 2005' WHERE NAME='DEFAULT_GENERAL_WEBCONTENT__BODY__MAIN_MARKETING_STAGING'
DAS: 1 row(s) updated.
DAS: UPDATE iwtracker SET UPDATETIME='Thu May 19 08:46:53 CDT 2005' WHERE NAME='DEFAULT_GENERAL_WEBCONTENT__RELATEDATTACHMENTS__MAIN_MARKETING_STAGING'
DAS: 1 row(s) updated.
DAS: Stat for group [webcontent]:
thank you
