|
Home > Archive > BizTalk Server > July 2007 > BizTalk Deployment Wizard (BizTalk 2004)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
BizTalk Deployment Wizard (BizTalk 2004)
|
|
| Christoffer 2007-01-09, 1:32 am |
| 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
| |
|
|
> 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
| |
|
|
> 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
>
Thanks, i had the same error, but using btsdeploy.exe in the cmd window solved it...
BizTalk Utilities - Frustration free BizTalk Adapters
http://www.topxml.com/biztalkutilities
|
|
|
|
|