ERROR: java.sql.SQLException: [TDS Driver]Read timed out

System

We are getting the following error when deploying large amounts of data with DataDeploy - any help would be greatly appreciated. our DBAs ran traces and couldnt find anything on the Database side

log file attached - it appears to be happening when a DD deployment is running, and is using the Table, then another deployment is kicked off that utilizes the same table. shouldnt DD handle concurrency? is there any DB queueing? would enabling real-updates be of any help as i see DBD: Performing delete+insert in the logs...

DBD: Recurse select: pIndex = 559, value = CU2322
DBD: Recurse select: pIndex = 560, value = FB3310
DBD: Recurse select: pIndex = 561, value = FB4320
DBD: Recurse select: pIndex = 562, value = FN4385
DBD: Recurse select: pIndex = 563, value = S4412
DBD: Recurse select: pIndex = 564, value = 4
DBD:
DBD: *******************************************************
DBD: SQLException occured in TDbSchemaGroupInfoNode
DBD: Exception Message: [TDS Driver]Read timed out
DBD: Vendor Error Code: 0
DBD: SQL state: S1T00
DBD: *******************************************************
DBD:
DBD: *******STACK TRACE*************
DBD: ERROR:
java.sql.SQLException: [TDS Driver]Read timed out
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.e.a(Unknown Source)
at com.inet.tds.b.new(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:84)
at com.interwoven.dd100.dd.TDbSchemaCfg.BuildGroupInfo(TDbSchemaCfg.java:709)
at com.interwoven.dd100.dd.TDbSchemaCfg.DeleteUsingRootPrimaryKeys(TDbSchemaCfg.java:790)
at com.interwoven.dd100.dd.TDbSchemaCfg.DeleteUsingDelTracker(TDbSchemaCfg.java:818)
at com.interwoven.dd100.dd.TDbSchemaCfg.Delete(TDbSchemaCfg.java:576)
at com.interwoven.dd100.dd.TDbSchemaAgent.BasicWriteTuple(TDbSchemaAgent.java:450)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:336)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumerInternal(TConsumerManager.java:399)
at com.interwoven.dd100.dd.TConsumerManager.WriteConsumers(TConsumerManager.java:388)
at com.interwoven.dd100.dd.TAgentClient.DoOneTeamSiteSource(TAgentClient.java:1018)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:502)
at com.interwoven.dd100.dd.TAgentClient.DoOneDeployment(TAgentClient.java:289)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:178)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:582)
at com.interwoven.dd100.dd.TDASThread.ProcessItem(TDASThread.java:203)
at com.interwoven.dd100.dd.TDASThread.run(TDASThread.java:128)


DBD: ERROR:Error occured while trying to delete before update
DBD: -- Failed
DBD: ERROR:WriteTuple failure to consumer[0]
DBD: ERROR:Unable to process TeamSite source templatedata/internet/Courses/data/AllCourses
DBD: ERROR:deployment [news_qa] FAILED
DBD: Error occured in area outside TDbAgent consumer (explicit rollback initiated)
DBD: Stat for group [Root]:
DBD: -----------------------------------
DBD: Rows inserted : 0
DBD: Rows updated : 0
DBD: Rows deleted : 0
DBD: Rows failed : 0
DBD: Rows rolled back : 0
DBD: Rows skipped : 0
DBD: -----------------------------------
DBD: Stat for group [CoursePreRequisites]:
DBD: -----------------------------------
DBD: Rows inserted : 0
DBD: Rows updated : 0
DBD: Rows deleted : 0
DBD: Rows failed : 0
DBD: Rows rolled back : 0
DBD: Rows skipped : 0
DBD: -----------------------------------
DBD: Rollback database [AMSWebPreProd?database=EDMCCommonContent]...
DBD: Deployment[news_qa]
DBD: -----------------------------------
DBD: DCRs inserted : 0
DBD: DCRs updated : 0
DBD: DCRs deleted : 0
DBD: DCRs failed : 0
DBD: DCRs rolled back : 0
DBD: DCRs skipped : 0
DBD: -----------------------------------
DBD: Started : Wed Oct 21 15:09:38 EDT 2009
DBD: Shutting down DDD PublisherThread
DBD: Finished: Wed Oct 21 15:09:57 EDT 2009
DBD:
### IWDataDeploy FAILED ###