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; } } }

DAS Error

Bhargav Coca

I am TS6.5sp2 on win2000 with od6.0.2 with DAS deployments . There is no extra "E" anywhere in my db_schema or my xx_dd.cfg. Can any one see where i am going wrong. All i did was , when i ran DAS it gave me the general "DATE" exception, so i chabged my variable date to "DATETIME" cuz i am on MS sql. I thought i would use varchar(255) for date too. but still it gives an error if i do so. Any help please


DAS:*******STACK TRACE*************
java.sql.SQLException: [DLINT05]Line 1: Incorrect syntax near 'E'.
 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.executeQuery(Unknown Source)
 at com.interwoven.dd100.dd.TDbSchemaGroupInfoNode.BuildTuples(TDbSchemaGroupInfoNode.java:161)
 at com.interwoven.dd100.dd.TDbSchemaGroupInfo.PrepareForDelete(TDbSchemaGroupInfo.java:83)
 at com.interwoven.dd100.dd.TDbSchemaCfg.BuildGroupInfo(TDbSchemaCfg.java:707)
 at com.interwoven.dd100.dd.TDbSchemaCfg.DeleteUsingPathColumnInRootGroup(TDbSchemaCfg.java:614)
 at com.interwoven.dd100.dd.TDbSchemaCfg.Delete(TDbSchemaCfg.java:569)
 at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:447)
 at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:333)
 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:962)
 at com.interwoven.dd100.dd.TAgentClient.ProcessOneFileList(TAgentClient.java:569)
 at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:529)
 at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:474)
 at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:256)
 at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:188)
 at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:512)
 at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:202)
 at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:127)
DAS:ERROR:Error occured while trying to delete before update
DAS: -- Failed

Thank you

Find more posts tagged with

Comments

akshathp

can you attach the code for dbschema and cfg too as a file in this thread?

Attachment1.jpg

Attachment2.jpg

Bhargav Coca

opps forgot attaching them previously

ITM.rptdesign

akshathp

opps forgot attaching them previously

I looked at it briefly. Can you test by adding data-format="yyyy-mm-dd" to the DATETIME field?

Bhargav Coca

Not it doesn't solve the issue. Now getting a java.lang exception for DATE type..
Thanks

Migrateduser

Unless I am very much mistaken, MSSQL doesn't have a data type called DATE. DATETIME and TIMESTAMP are the two date related data types.

See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_7msw.asp

akshathp

Unless I am very much mistaken, MSSQL doesn't have a data type called DATE. DATETIME and TIMESTAMP are the two date related data types.

See http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_da-db_7msw.asp

In the code that lilleywhite posted, I don't see any where DATE being used. It's all DATETIME as much as I can see in the 2 cfg files in attached zip file.