nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

IW_State Exception

Bhargav Coca

Can anyone help me out of this, I am on TS6.5, win2k3 with DAS on OD 6.0.2. Here is the only exception i am getting.

java.sql.SQLException: [BLSFODEVSQL02]Invalid column name 'IW_State'.
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.b.new(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.PerformInsert(TDbSchemaGroupCfg.java:1160)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoInsert(TDbSchemaGroupCfg.java:1072)
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 Smiley Very Happy

oInsert() failed for group [NewsDetails].
DAS: -- Failed
DAS: ERROR:WriteTuple failure to consumer[0]
DAS: ERROR:Unable to process TeamSite source templatedata/general/News Details/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 15:37:10 CDT 2005' WHERE NAME='DEFAULT_GENERAL_NEWS_DETAILS__NEWSDETAILS__MAIN_MARKETING_STAGING'

Thank you
In Advance

Find more posts tagged with

Comments

stefanmaier

Hi,
with which mechanism did you setup your datatables?
Did you use iwsyncdb -initial ... ?
Do you have a IW_STATE column in your tables?

Regards
Stefan

Bhargav Coca

yes i do see my IW_State column in my base table, should this column be in the dbschema? I am seeing it in the generated *_dd.xml though. Please help me.
Thank you

jbyork

Perhaps the space in the directory name is **** things up.

DAS: ERROR Smiley Very Happy

oInsert() failed for group [NewsDetails].
DAS: -- Failed
DAS: ERROR:WriteTuple failure to consumer[0]
DAS: ERROR:Unable to process TeamSite source templatedata/general/News Details/data

I've seen instances where spaces in directory paths and file names screw up things between TeamSite, OpenDeploy, DataDeploy, and DAS.