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(CommandBehav
ior
cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
[5476]    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehav
ior
behavior)
[5476]    at
System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(Comman
dBehavior
behavior)
[5476]    at System.Data.Common.DbDataAdapter.FillFromCommand(Object dat
a,
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(IRootObj
ect
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 per
iod
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-da291f998c3
8
[648] BizTalkAssembly.Deactivate: SQLConnection closed

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

Cheers,
Chris

[ Post a follow-up to this message ]

> I'm having trouble deploying assemblies on our production server. When I r
un
> 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 timeo
ut
> period elapsed prior to completion of the operation or the server is not
> responding.
> [5476]    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBeh
avior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
> [5476]    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBeh
avior
> behavior)
> [5476]    at
> System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(Comm
andBehavior
> behavior)
> [5476]    at System.Data.Common.DbDataAdapter.FillFromCommand(Object d
ata,
> 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(IRootO
bject
> root)
> [5476]    at
> Microsoft.BizTalk.ExplorerOM.BtsCatalogExplorer.get_Assemblies()
> [5476]    at
> Microsoft.BizTalk.ExplorerOM.BtsCatalogExplorer.GetCollection(CollectionTy
pe
> 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.DeployEarlyBindi
ng()
> [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 p
eriod
> 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-da291f998
c38
> [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

[ Post a follow-up to this message ]

> I'm having trouble deploying assemblies on our production server. When I r
un
> 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 timeo
ut
> period elapsed prior to completion of the operation or the server is not
> responding.
> [5476]    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBeh
avior
> cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
> [5476]    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBeh
avior
> behavior)
> [5476]    at
> System.Data.SqlClient.SqlCommand.System.Data.IDbCommand.ExecuteReader(Comm
andBehavior
> behavior)
> [5476]    at System.Data.Common.DbDataAdapter.FillFromCommand(Object d
ata,
> 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(IRootO
bject
> root)
> [5476]    at
> Microsoft.BizTalk.ExplorerOM.BtsCatalogExplorer.get_Assemblies()
> [5476]    at
> Microsoft.BizTalk.ExplorerOM.BtsCatalogExplorer.GetCollection(CollectionTy
pe
> 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.DeployEarlyBindi
ng()
> [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 p
eriod
> 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-da291f998
c38
> [648] BizTalkAssembly.Deactivate: SQLConnection closed
>
> Why does BizTalk Deployment Wizard fail? Is it possible to get a more
> verbose log?
>
> Cheers,
> Chris
>

Thanks, i had the same error, but using btsdeploy.exe in the cmd window solv
ed it...

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

[ Post a follow-up to this message ]