RE: BizTalk Deployment Wizard (BizTalk 2004)


I'm having trouble deploying assemblies on our production server. When I run
the BizTalk Deployment Wizard it fails. I started DebugView and found this:

[5476] Trace switch level:Verbose
[5476] =============== BizTalkAssembly Constructor =================
[5476] Deployment DTC transaction id:
[5476] System.Data.SqlClient.SqlException: Timeout expired. The timeout
period elapsed prior to completion of the operation or the server is not
responding.
[5476] at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
[5476] at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior
behavior)
[5476] at
System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior
behavior)
[5476] at System.Data.Common.DbDataAdapter.FillFromCommand(Object data,
Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command,
CommandBehavior behavior)
[5476] at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable,
IDbCommand command, CommandBehavior behavior)
[5476] at System.Data.Common.DbDataAdapter.Fill(DataTable dataTable)
[5476] at Microsoft.BizTalk.ExplorerOM.BtsAssembly.SelectAll(IRootObject
root)
[5476] at
Microsoft.BizTalk.ExplorerOM.BtsCatalogExplorer.get_Assemblies()
[5476] at
Microsoft.BizTalk.ExplorerOM.BtsCatalogExplorer.GetCollection(CollectionType
enumCollectionType)
[5476] at
Microsoft.BizTalk.Deployment.Explorer.GetNamedAssembly(IBtsCatalogExplorer
explorer, String name, String version, String culture, String token)
[5476] at Microsoft.BizTalk.Deployment.BindingInfo.Select(String
connectionString, BindingInfoOptions options)
[5476] at Microsoft.BizTalk.Deployment.BtsAssembly.DeployEarlyBinding()
[5476] at Microsoft.BizTalk.Deployment.BtsAssembly.Save()
[5476] at
Microsoft.BizTalk.Deployment.BizTalkAssembly.PrivateDeploy(String server,
String database, String assemblyPathname)
[5476] System.Data.SqlClient.SqlError: Timeout expired. The timeout period
elapsed prior to completion of the operation or the server is not
responding.
[5476] BizTalkAssembly.Deactivate: SQLConnection closed

However, running the command prompt (btsdeploy.exe) using the parameters
from BizTalk Deployment Wizard (DEPLOY SERVER="BIZTALK"
DATABASE="BizTalkMgmtDb" etc) it works, with this output:

[648] Trace switch level:Verbose
[648] =============== BizTalkAssembly Constructor =================
[648] Deployment DTC transaction id: f1b2f06b-b87d-4598-a465-da291f998c38
[648] BizTalkAssembly.Deactivate: SQLConnection closed

Why does BizTalk Deployment Wizard fail? Is it possible to get a more
verbose log?

Cheers,
Chris


Many thanks for the "Tips" !!!

BizTalk Utilities - Frustration free BizTalk Adapters
http://www.topxml.com/biztalkutilities
.

Relevant Pages

  • BizTalk Deployment Wizard (BizTalk 2004)
    ... I'm having trouble deploying assemblies on our production server. ... the BizTalk Deployment Wizard it fails. ... Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, ...
    (microsoft.public.biztalk.server)
  • Re: Help - Procedure expects parameter - Its There!!!
    ... Public Property FKJobIDAs String ... here is the sql command from DataAccess.vb that is trying to get ... Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand ... command, CommandBehavior behavior) ...
    (microsoft.public.dotnet.framework.windowsforms)
  • RE: BizTalk Deployment Wizard (BizTalk 2004)
    ... the BizTalk Deployment Wizard it fails. ... Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, ... IDbCommand command, CommandBehavior behavior) ...
    (microsoft.public.biztalk.server)