Saturday, July 11, 2015

CannotOpenBizTalkHostInstance






TITLE: BizTalk Server Administration
------------------------------
Could not display property pages.

For help, click: http://go.microsoft.com/fwlink/?LinkId=47400&ProdName=Microsoft+BizTalk+Server+2010&ProdVer=3.9.469.0&EvtSrc=Microsoft.BizTalk.SnapIn.Framework.Properties.ErrorMessages&EvtID=CouldNotDisplayProperties&EvtChain=BTSAdminMsg+%2c9528
------------------------------
ADDITIONAL INFORMATION:

For help, click: http://go.microsoft.com/fwlink/?LinkId=47400&ProdName=Microsoft+BizTalk+Server+2010&ProdVer=3.9.469.0&EvtSrc=BTSAdminMsg&EvtID=9528
------------------------------
Instance of the WMI class is not found. (WinMgmt).More than one instance was found with the specified key.
------------------------------
BUTTONS:
OK
------------------------------

Solution:
Go to [BizTalkMgmtDb].[dbo].[adm_HostInstance]
Search for any duplicateNames Present

In My case BizTalkServer Application both were having same name ".....05" and "..........05"
I updated query to reflect other server isntance name "06" so that I have unique entry for BizTalk Server Application Host Instance





So with Updated query - Issue resolved !
 
 
 

Friday, March 1, 2013

BizTalk Notification Receive Location channel Error

 Resolution: Use Different Hosts for SQL Notification receive location in SAME APPLICATION.

http://seroter.wordpress.com/2009/01/12/query-notification-capability-in-wcf-sql-adapter/
http://www.codeproject.com/Articles/144344/Query-Notification-using-SqlDependency-and-SqlCach
http://social.msdn.microsoft.com/Forums/en-ZA/biztalkgeneral/thread/6a0628c3-4e8b-4a39-960f-2de83914fd6c




System.InvalidOperationException: The ChannelDispatcher at 'mssql://Database1/repository/Profiles?InboundId=ERPAccountsID' with contract(s) '"IOneWayAsyncTxn"' is unable to open its IChannelListener. ---> System.InvalidOperationException: SqlDependency does not support calling Start() with different connection strings having the same server, user, and database in the same app domain.

Log Name:      Application
Source:        BizTalk Server
Date:          3/1/2013 2:03:05 PM
Event ID:      5644
Task Category: BizTalk Server
Level:         Error
Keywords:      Classic
User:          N/A
Computer:      xxxxxx.xxx.local
Description:
The Messaging Engine failed to add a receive location "rloc_NotificationERPAccounts" with URL "mssql://Database1/repository/Profiles?InboundId=ERPAccountsID" to the adapter "WCF-Custom". Reason: "System.InvalidOperationException: The ChannelDispatcher at 'mssql://Database1/repository/Profiles?InboundId=ERPAccountsID' with contract(s) '"IOneWayAsyncTxn"' is unable to open its IChannelListener. ---> System.InvalidOperationException: SqlDependency does not support calling Start() with different connection strings having the same server, user, and database in the same app domain.
   at System.Data.SqlClient.SqlDependency.Start(String connectionString, String queue, Boolean useDefaults)
   at Microsoft.Adapters.Sql.SqlAdapterInboundHandler.StartListener(String[] actions, TimeSpan timeout)
   at Microsoft.ServiceModel.Channels.Common.Channels.AdapterChannelListener`1.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at System.ServiceModel.Dispatcher.ChannelDispatcher.OnOpen(TimeSpan timeout)
   --- End of inner exception stack trace ---
   at System.ServiceModel.Dispatcher.ChannelDispatcher.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at System.ServiceModel.ServiceHostBase.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfReceiveEndpoint.Enable()
   at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfReceiveEndpoint..ctor(BizTalkEndpointContext endpointContext, IBTTransportProxy transportProxy, ControlledTermination control)
   at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfReceiver`2.AddReceiveEndpoint(String url, IPropertyBag adapterConfig, IPropertyBag bizTalkConfig)".
Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="BizTalk Server" />
    <EventID Qualifiers="49344">5644</EventID>
    <Level>2</Level>
    <Task>1</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2013-03-01T19:03:05.000000000Z" />
    <EventRecordID>1819748</EventRecordID>
    <Channel>Application</Channel>
    <Computer>xxxxxx.xxx.local</Computer>
    <Security />
  </System>
  <EventData>
    <Data>rloc_NotificationERPAccounts</Data>
    <Data>mssql://Database1/repository/Profiles?InboundId=ERPAccountsID</Data>
    <Data>WCF-Custom</Data>
    <Data>System.InvalidOperationException: The ChannelDispatcher at 'mssql://Database1/repository/Profiles?InboundId=ERPAccountsID' with contract(s) '"IOneWayAsyncTxn"' is unable to open its IChannelListener. ---&gt; System.InvalidOperationException: SqlDependency does not support calling Start() with different connection strings having the same server, user, and database in the same app domain.
   at System.Data.SqlClient.SqlDependency.Start(String connectionString, String queue, Boolean useDefaults)
   at Microsoft.Adapters.Sql.SqlAdapterInboundHandler.StartListener(String[] actions, TimeSpan timeout)
   at Microsoft.ServiceModel.Channels.Common.Channels.AdapterChannelListener`1.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at System.ServiceModel.Dispatcher.ChannelDispatcher.OnOpen(TimeSpan timeout)
   --- End of inner exception stack trace ---
   at System.ServiceModel.Dispatcher.ChannelDispatcher.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at System.ServiceModel.ServiceHostBase.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfReceiveEndpoint.Enable()
   at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfReceiveEndpoint..ctor(BizTalkEndpointContext endpointContext, IBTTransportProxy transportProxy, ControlledTermination control)
   at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfReceiver`2.AddReceiveEndpoint(String url, IPropertyBag adapterConfig, IPropertyBag bizTalkConfig)</Data>
  </EventData>
</Event>

BizTalkNotification Receive Location NotificationStatement from SQL query to Stored Procedure


Resolution:
http://www.codeproject.com/Articles/12335/Using-SqlDependency-for-data-change-events
Update: Thanks to DylanTheDeveloper for finding this resource describing valid queries: Special Considerations When Using Query Notifications. Also, using SET NOCOUNT ON in your stored procedure will invalidate it for usage in Query Notifications.
http://msdn.microsoft.com/en-us/library/aewzkxxh.aspx


The Messaging Engine failed to add a receive location "rloc_sqlNotificationOrgProfiles" with URL "mssql://Database1/Repository/Profiles?InboundId=OrgProfileNotification" to the adapter "WCF-Custom". Reason: "Microsoft.ServiceModel.Channels.Common.TargetSystemException: The notification callback returned an error. Info=Invalid. Source=Statement. Type=Subscribe.
   at Microsoft.Adapters.Sql.SqlAdapterInboundHandler.StartListener(String[] actions, TimeSpan timeout)
   at Microsoft.ServiceModel.Channels.Common.Channels.AdapterChannelListener`1.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at System.ServiceModel.Dispatcher.ChannelDispatcher.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at System.ServiceModel.ServiceHostBase.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfReceiveEndpoint.Enable()
   at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfReceiveEndpoint..ctor(BizTalkEndpointContext endpointContext, IBTTransportProxy transportProxy, ControlledTermination control)
   at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfReceiver`2.AddReceiveEndpoint(String url, IPropertyBag adapterConfig, IPropertyBag bizTalkConfig)".


Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="BizTalk Server" />
    <EventID Qualifiers="49344">5644</EventID>
    <Level>2</Level>
    <Task>1</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2013-02-28T19:14:14.000000000Z" />
    <EventRecordID>1817702</EventRecordID>
    <Channel>Application</Channel>
    <Computer>xxxxx.xxxx.local</Computer>
    <Security />
  </System>
  <EventData>
    <Data>rloc_sqlNotificationOrgProfiles</Data>
    <Data>mssql://Database1/Repository/Profiles?InboundId=OrgProfileNotification</Data>
    <Data>WCF-Custom</Data>
    <Data>Microsoft.ServiceModel.Channels.Common.TargetSystemException: The notification callback returned an error. Info=Invalid. Source=Statement. Type=Subscribe.
   at Microsoft.Adapters.Sql.SqlAdapterInboundHandler.StartListener(String[] actions, TimeSpan timeout)
   at Microsoft.ServiceModel.Channels.Common.Channels.AdapterChannelListener`1.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at System.ServiceModel.Dispatcher.ChannelDispatcher.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at System.ServiceModel.ServiceHostBase.OnOpen(TimeSpan timeout)
   at System.ServiceModel.Channels.CommunicationObject.Open(TimeSpan timeout)
   at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfReceiveEndpoint.Enable()
   at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfReceiveEndpoint..ctor(BizTalkEndpointContext endpointContext, IBTTransportProxy transportProxy, ControlledTermination control)
   at Microsoft.BizTalk.Adapter.Wcf.Runtime.WcfReceiver`2.AddReceiveEndpoint(String url, IPropertyBag adapterConfig, IPropertyBag bizTalkConfig)</Data>
  </EventData>
</Event>



Friday, September 14, 2012

MSDTC Error


Change the Setting to Default as shown in above Image. Again make the changes you want to make in MSDTC, restart the service.

If you dont do this, how much you try to resolve each error from bundle of error you get, you are not going to come out it.

f


-------------------------------------------------------------------------

Log Name:      Application

Source:        Microsoft-Windows-MSDTC

Date:          6/19/2012 7:12:28 AM

Event ID:      4358

Task Category: MSDTC Proxy

Level:         Error

Keywords:      Classic

User:          N/A

Computer:      DevelopmentBox

Description:

The MS DTC Connection Manager is unable to register with RPC to use one of LRPC, TCP/IP, or UDP/IP. Please ensure that RPC is configured properly. If "ServerTcpPort" registry key is configured(DWORD value under the HKEY_LOCAL_MACHINE\Software\Microsoft\MSDTC for local DTC instance or under cluster hive for clustered DTC instance), please verify if the configured port is valid and the port is not already in use by a different component. Error Specifics:hr = 0x80004005, d:\w7rtm\com\complus\dtc\dtc\cm\src\iomgrsrv.cpp:2523, CmdLine: C:\Windows\System32\msdtc.exe, Pid: 2440

Event Xml:

<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

  <System>

    <Provider Name="Microsoft-Windows-MSDTC" Guid="{719BE4ED-E9BC-4DD8-A7CF-C85CE8E4975D}" EventSourceName="MSDTC" />

    <EventID Qualifiers="49152">4358</EventID>

    <Version>0</Version>

    <Level>2</Level>

    <Task>10</Task>

    <Opcode>0</Opcode>

    <Keywords>0x80000000000000</Keywords>

    <TimeCreated SystemTime="2012-06-19T14:12:28.000000000Z" />

    <EventRecordID>28248</EventRecordID>

    <Correlation />

    <Execution ProcessID="0" ThreadID="0" />

    <Channel>Application</Channel>

    <Computer>DevelopmentBox</Computer>

    <Security />

  </System>

  <EventData>

    <Data Name="param1">hr = 0x80004005, d:\w7rtm\com\complus\dtc\dtc\cm\src\iomgrsrv.cpp:2523, CmdLine: C:\Windows\System32\msdtc.exe, Pid: 2440</Data>

    <Binary>4D005300440054004300</Binary>

  </EventData>

</Event>

--------------------------------------------------------------------------------------

Log Name:      Application

Source:        Microsoft-Windows-MSDTC

Date:          6/19/2012 9:12:16 AM

Event ID:      4441

Task Category: SVC

Level:         Error

Keywords:      Classic

User:          N/A

Computer:      ComputerName

Description:

A MS DTC component has encountered an internal error. The process is being terminated. Error Specifics: DtcSystemShutdown (d:\w7rtm\com\complus\dtc\dtc\msdtc\src\msdtc.cpp@2539): Shutting down with an error

Event Xml:

<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

  <System>

    <Provider Name="Microsoft-Windows-MSDTC" Guid="{719BE4ED-E9BC-4DD8-A7CF-C85CE8E4975D}" EventSourceName="MSDTC" />

    <EventID Qualifiers="49152">4441</EventID>

    <Version>0</Version>

    <Level>2</Level>

    <Task>1</Task>

    <Opcode>0</Opcode>

    <Keywords>0x80000000000000</Keywords>

    <TimeCreated SystemTime="2012-06-19T16:12:16.000000000Z" />

    <EventRecordID>30768</EventRecordID>

    <Correlation />

    <Execution ProcessID="0" ThreadID="0" />

    <Channel>Application</Channel>

    <Computer>ComputerName</Computer>

    <Security />

  </System>

  <EventData>

    <Data Name="param1">DtcSystemShutdown (d:\w7rtm\com\complus\dtc\dtc\msdtc\src\msdtc.cpp@2539): Shutting down with an error</Data>

    <Binary>

    </Binary>

  </EventData>

</Event>

--------------------------------------------------------------

Log Name:      Application

Source:        Microsoft-Windows-MSDTC

Date:          6/19/2012 7:50:50 PM

Event ID:      4358

Task Category: MSDTC Proxy

Level:         Error

Keywords:      Classic

User:          N/A

Computer:      ComputerName

Description:

The MS DTC Connection Manager is unable to register with RPC to use one of LRPC, TCP/IP, or UDP/IP. Please ensure that RPC is configured properly. If "ServerTcpPort" registry key is configured(DWORD value under the HKEY_LOCAL_MACHINE\Software\Microsoft\MSDTC for local DTC instance or under cluster hive for clustered DTC instance), please verify if the configured port is valid and the port is not already in use by a different component. Error Specifics:hr = 0x80004005, d:\w7rtm\com\complus\dtc\dtc\cm\src\iomgrsrv.cpp:2523, CmdLine: C:\Windows\system32\msdtc.exe, Pid: 1316

Event Xml:

<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">

  <System>

    <Provider Name="Microsoft-Windows-MSDTC" Guid="{719BE4ED-E9BC-4DD8-A7CF-C85CE8E4975D}" EventSourceName="MSDTC" />

    <EventID Qualifiers="49152">4358</EventID>

    <Version>0</Version>

    <Level>2</Level>

    <Task>10</Task>

    <Opcode>0</Opcode>

    <Keywords>0x80000000000000</Keywords>

    <TimeCreated SystemTime="2012-06-20T02:50:50.000000000Z" />

    <EventRecordID>45990</EventRecordID>

    <Correlation />

    <Execution ProcessID="0" ThreadID="0" />

    <Channel>Application</Channel>

    <Computer>ComputerName</Computer>

    <Security />

  </System>

  <EventData>

-------------------------------------------------------------

http://msdn.microsoft.com/en-us/library/aa561924%28v=bts.20%29.aspx

Links:

http://social.technet.microsoft.com/Forums/eu/winservergen/thread/cc0089e1-b72a-4cf1-95c0-69f5156d79fc

http://blogs.msdn.com/b/distributedservices/archive/2009/11/05/event-id-4156-with-rpc-s-invalida-arg-is-logged-periodically-in-the-event-log-when-msdtc-mutual-authentication-is-not-required.aspx

http://social.technet.microsoft.com/Forums/en/winserverClustering/thread/cd18cf04-3e3d-403b-8e18-4397731ec0cd

http://social.msdn.microsoft.com/Forums/en-CA/winserver2008appcompatabilityandcertification/thread/23dfb4df-ad24-459e-9fe6-c77acaa204ae

http://social.msdn.microsoft.com/forums/en-US/windowstransactionsprogramming/thread/b740a129-c319-4e4c-a6a8-59540b61dd10/

http://blogs.msdn.com/b/narahari/archive/2009/11/25/how-to-configure-msdtc-on-a-ccr-cluster-cluster-continuous-replication.aspx

SSO encryption

 1. If you dont  have Master Secret Server Back up , you will Have to do fresh Install : Complete Install of BizTalk from scratch, No There is No other way.

Dont forget to take Master Secret key back up if you change Admin Password or Single Sign On Service Password

Log Name:      Application
Source:        ENTSSO
Date:          6/15/2012 3:28:40 AM
Event ID:      10536
Task Category: Enterprise Single Sign-On
Level:         Warning
Keywords:      Classic
User:          N/A
Computer:      ComputerName
Description:
SSO AUDIT
 Function: GetConfigInfo ({68A2F2B6-6A66-42DC-AF81-36A6349BB72B})
 Tracking ID: 14ca694f-e7c8-4df9-bc16-3a79f4e1a198
 Client Computer: ComputerName (BTSNTSvc64.exe:2336)
 Client User: ComputerName\Servicename
 Application Name: {444691BA-A7BC-457D-AF34-38881A1CDBED}
 Error Code: 0xC0002A1F, Cannot perform encryption or decryption because the secret is not available from the master secret server. See the event log for related errors.

Event Xml:
<Event xmlns="http://schemas.microsoft.com/win/2004/08/events/event">
  <System>
    <Provider Name="ENTSSO" />
    <EventID Qualifiers="32768">10536</EventID>
    <Level>3</Level>
    <Task>1</Task>
    <Keywords>0x80000000000000</Keywords>
    <TimeCreated SystemTime="2012-06-15T10:28:40.000000000Z" />
    <EventRecordID>14092</EventRecordID>
    <Channel>Application</Channel>
    <Computer>ComputerName</Computer>
    <Security />
  </System>
  <EventData>
    <Data>GetConfigInfo ({68A2F2B6-6A66-42DC-AF81-36A6349BB72B})</Data>
    <Data>14ca694f-e7c8-4df9-bc16-3a79f4e1a198</Data>
    <Data>ComputerName (BTSNTSvc64.exe:2336)</Data>
    <Data>ComputerName\Servicename</Data>
    <Data>{444691BA-A7BC-457D-AF34-38881A1CDBED}</Data>
    <Data>0xC0002A1F, Cannot perform encryption or decryption because the secret is not available from the master secret server. See the event log for related errors.
</Data>
  </EventData>
</Event>