DD read timeout ?

Trying to load a new system with DD. Win 2003, SQL 2005 DD/OD 6.2

db.xml:
[html]

[/html]

conf.xml:
[html]

plus lots of mappings....

[/html]

I can look at the DB and view my columns without trouble. I am using sa which has complete rights.

But when I run DD, I get this error, OD hangs and keeps the DB locked:

DBD: login : sa
DBD: login timeout=3
DBD: Connecting to the database...
DBD: Try connecting using jdbc:inetdae Smiley Frustrated

ERVER:1433?database=DemoDB&sql7=true...
DBD:
Connected to jdbc:inetdae Smiley Frustrated

ERVER:1433?database=DemoDB&sql7=true
DBD: Driver i-net UNA 2000
DBD: Version 4.18
DBD: Connected to [SERVER:1433?database=DemoDB]
DBD: Creating identifier mapping table: IWOV_IDMAPS
DBD: CREATE TABLE IWOV_IDMAPS (TYPE INT NOT NULL, SHORTID VARCHAR(30) NOT NULL, LONGID VARCHAR(1024) NOT NULL)
DBD: Created identifier mapping table: IWOV_IDMAPS Successfully
DBD: Creating index on IWOV_IDMAPS
DBD: CREATE TABLE IWDELTRACKER ( PATH VARCHAR(255) NOT NULL , AREA VARCHAR(255) NOT NULL , KEYCOLNAME VARCHAR(255) NOT NULL , KEYCOLVALUE VARCHAR(255) NOT NULL )
DBD: CREATE INDEX iwdelt_idx ON IWDELTRACKER( PATH , AREA )
DBD: IWDELTRACKER created successfully.
DBD: Table [Category] exists.
DBD: Running deployment [NAV]
DBD: extraction type=default
DBD: tuple mode=wide
DBD: area=/default/main/DotCom/WORKAREA/Content
DBD: filelist=[d:/interwoven/iw-home/tmp/thisevent.txt]
DBD: /default/main/DotCom/WORKAREA/Content/templatedata/Admin/NavigationMenu/data/en-US/NavigationMenu.xml
DBD: Generate DirectoryContents start:Thu Sep 04 11:16:59 PDT 2008
DBD: Generate DirectoryContents end :Thu Sep 04 11:16:59 PDT 2008
DBD: Building replicant order column information.
DBD: Building replicant order column information... Done.
DBD:

... lots of data log removed......

DBD: TDbSchemaGroupCfg:RowsExistForTuple Smiley Frustrated

ELECT COUNT(*) FROM Category WHERE CategoryID IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
DBD: Starting SchemaHelperCache Cleanup Thread...
DBD: TTableSchemaHelper not found in cache for [Category]. Creating new.
DBD: Performing delete+insert
DBD: Only one group is defined. Skipping delete for update.
DBD: TTableSchemaHelper object for [Category] found in cache.
DBD: TTableSchemaHelper object for [Category] found in cache.
DBD: SELECT KEYCOLNAME , KEYCOLVALUE FROM IWDELTRACKER WHERE PATH = ? AND AREA = ? AND KEYCOLNAME IN ( 'CategoryID')
DBD: 0 PK values retrieved from iwdeltracker for templatedata\Admin\NavigationMenu\data\en-US\NavigationMenu.xml, /default/main/DotCom/WORKAREA/Content
DBD: TTableSchemaHelper object for [Category] found in cache.
DBD: SelectCurrentRows Smiley Frustrated

ELECT ClassificationID,Title,Link,Img,BYO,CategoryID FROM Category WHERE CategoryID IN ( ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ORDER BY CategoryID

.... more data log removed .....

DBD: SelectCurrentRows: 16 rows selected.
DBD: Building Row map tree for group [Category].
DBD: This may take a while....
DBD: Row map tree for group [Category] built.
DBD: TTableSchemaHelper object for [Category] found in cache.
DBD: Loading com.inet.tds.TdsDriver
DBD: url : jdbc:inetdae Smiley Frustrated

ERVER:1433?database=DemoDB&sql7=true
DBD: login : sa
DBD: login timeout=3
DBD: Connecting to the database...
DBD: Try connecting using jdbc:inetdae Smiley Frustrated

ERVER:1433?database=DemoDB&sql7=true...
DBD:
Connected to jdbc:inetdae Smiley Frustrated

ERVER:1433?database=DemoDB&sql7=true
DBD: Driver i-net UNA 2000
DBD: Version 4.18
DBD:
DBD: *******************************************************
DBD: SQLException occured in TableSchema:Exists()
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.a.a(Unknown Source)
at com.inet.tds.a.if(Unknown Source)
at com.inet.tds.h.a(Unknown Source)
at com.inet.tds.h.getTables(Unknown Source)
at com.interwoven.dd100.dd.TableSchema.Exists(TableSchema.java:121)
at com.interwoven.dd100.dd.TableSchema.Exists(TableSchema.java:54)
at com.interwoven.dd100.dd.TDbSchemaRowSort.BuildTempTableName(TDbSchemaRowSort.java:180)
at com.interwoven.dd100.dd.TDbSchemaRowSort.BuildTempTable(TDbSchemaRowSort.java:157)
at com.interwoven.dd100.dd.TDbSchemaRowSort.PerformSort(TDbSchemaRowSort.java:75)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.PerformSort(TDbSchemaUpdateHelper.java:137)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.GetOperationRequired(TDbSchemaUpdateHelper.java:157)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoRealUpdate(TDbSchemaGroupCfg.java:826)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoUpdate(TDbSchemaGroupCfg.java:860)
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:457)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:336)
at com.interwoven.dd100.dd.TTupleSubstitutor.WriteTuple(TTupleSubstitutor.java:113)
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.ProcessOneFileList(TAgentClient.java:609)
at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:566)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:511)
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:
DBD: *******************************************************
DBD: SQLException occured in TableSchema:Exists()
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.a.a(Unknown Source)
at com.inet.tds.a.if(Unknown Source)
at com.inet.tds.h.a(Unknown Source)
at com.inet.tds.h.getTables(Unknown Source)
at com.interwoven.dd100.dd.TableSchema.Exists(TableSchema.java:121)
at com.interwoven.dd100.dd.TableSchema.Exists(TableSchema.java:54)
at com.interwoven.dd100.dd.TDbSchemaRowSort.BuildTempTableName(TDbSchemaRowSort.java:180)
at com.interwoven.dd100.dd.TDbSchemaRowSort.BuildTempTable(TDbSchemaRowSort.java:157)
at com.interwoven.dd100.dd.TDbSchemaRowSort.PerformSort(TDbSchemaRowSort.java:75)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.PerformSort(TDbSchemaUpdateHelper.java:137)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.GetOperationRequired(TDbSchemaUpdateHelper.java:157)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoRealUpdate(TDbSchemaGroupCfg.java:826)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoUpdate(TDbSchemaGroupCfg.java:860)
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:457)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:336)
at com.interwoven.dd100.dd.TTupleSubstitutor.WriteTuple(TTupleSubstitutor.java:113)
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.ProcessOneFileList(TAgentClient.java:609)
at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:566)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:511)
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:
DBD: *******************************************************
DBD: SQLException occured in TableSchema:Exists()
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.a.a(Unknown Source)
at com.inet.tds.a.if(Unknown Source)
at com.inet.tds.h.a(Unknown Source)
at com.inet.tds.h.getTables(Unknown Source)
at com.interwoven.dd100.dd.TableSchema.Exists(TableSchema.java:121)
at com.interwoven.dd100.dd.TableSchema.Exists(TableSchema.java:54)
at com.interwoven.dd100.dd.TDbSchemaRowSort.BuildTempTableName(TDbSchemaRowSort.java:180)
at com.interwoven.dd100.dd.TDbSchemaRowSort.BuildTempTable(TDbSchemaRowSort.java:157)
at com.interwoven.dd100.dd.TDbSchemaRowSort.PerformSort(TDbSchemaRowSort.java:75)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.PerformSort(TDbSchemaUpdateHelper.java:137)
at com.interwoven.dd100.dd.TDbSchemaUpdateHelper.GetOperationRequired(TDbSchemaUpdateHelper.java:157)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoRealUpdate(TDbSchemaGroupCfg.java:826)
at com.interwoven.dd100.dd.TDbSchemaGroupCfg.DoUpdate(TDbSchemaGroupCfg.java:860)
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:457)
at com.interwoven.dd100.dd.TDbSchemaAgent.WriteTuple(TDbSchemaAgent.java:336)
at com.interwoven.dd100.dd.TTupleSubstitutor.WriteTuple(TTupleSubstitutor.java:113)
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.ProcessOneFileList(TAgentClient.java:609)
at com.interwoven.dd100.dd.TAgentClient.ProcessFileList(TAgentClient.java:566)
at com.interwoven.dd100.dd.TAgentClient.DoTeamSiteSources(TAgentClient.java:511)
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)

Find more posts tagged with

Comments

There are no comments yet