WIN2K
DataDeploy Version 5.5.2 Build 9275 Interwoven 20020617
SQL 2000
When Executing a stored procedure that takes over 30 seconds from data deploy it is failing with the following error. My assumption is that DD is timing out.
How can I fix this, workaround this?
Is there an SQL timeout setting in DD?
Building mappings cache...
Built mapping cache(s) successfully.
# column mappings: 0
# table mappings: 0
# view mappings: 0
# constraint mappings: 0
iwdd-op=do-sql
exec sp_general_content_deploy
*******************************************************
SQLException occured in TDbAgent:ExecUpdate()
Exception Message: [TDS Driver]Query Timeout expired.
Vendor Error Code: 0
SQL state: S1T00
*******************************************************
*******STACK TRACE*************
java.sql.SQLException: [TDS Driver]Query Timeout expired.
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.executeUpdate(Unknown Source)
at com.interwoven.dd100.dd.TDbAgent.ExecUpdate(TDbAgent.java:3039)
at com.interwoven.dd100.dd.TDbAgent.DoSql(TDbAgent.java:3012)
at com.interwoven.dd100.dd.TCommand.Do(TCommand.java:234)
at com.interwoven.dd100.dd.TAgentClient.Go(TAgentClient.java:131)
at com.interwoven.dd100.dd.IWDataDeploy.Go(IWDataDeploy.java:385)
at com.interwoven.dd100.dd.IWDataDeploy.runDeploy(IWDataDeploy.java:409)
at com.interwoven.dd100.dd.IWDataDeploy.main(IWDataDeploy.java:401)
Failed to execute SQL command
done
Error occured in area outside TDbAgent consumer (explicit rollback initiated)
Deployment[general_content_jsppath] Table[IW_DOCUMENT]
-----------------------------------
Tuples inserted : 0
Tuples updated : 0
Tuples deleted : 0
Tuples failed : 0
Tuples rolled back : 0
Tuples skipped : 0
-----------------------------------
Started : Wed Jan 21 13:19:11 EST 2004
Finished: Wed Jan 21 13:19:18 EST 2004
### IWDataDeploy FAILED ###
The Professor- 
