How to remove blank namespace when retrieving data using WCF-SQL adapter with FOR XML clause stored procedure

Problem Description ==================     When using BizTalk WCF-SQL adapter to retrieve data fromSQL, there is a known issue that a blank namespace may be generated when a FORXML clause stored procedure is used. For example, the empty xmlns=”” on FTP_KC_SERIAL_NO_HEAD in thefollowing XML instance.     <?xml version=”1.0″ encoding=”utf-8″?> – <Root xmlns=”http://TestEDI.SP_GetDataFromFTPKCSerialNo“> – <FTP_KC_SERIAL_NO_HEAD…

1

When configuring FTPS in BizTalk Server 2010, there is an error "The client and server cannot communicate, because they do not possess a common algorithm"

Problem Description ==================   When configuring the new feature FTPS adapter (receive or send) to connect FTP server in BizTalk Server 2010, there may raise the following error in the event log on BizTalk Server:   “The client and server cannot communicate, because they do not possess a common algorithm”   Problem Analysis ================  …

0

Introduction for Anxin Service Program of Microsoft APGC CSS – 微软亚太区全球技术支持中心 安心服务简介

Dear Customer, Microsoft APGC CSS is now promoting a new customer program named Anxin Service(安心服务). Currently, this program is only open for GCR customers, so the following introduction will be written in Chinese Simplified. If any of you come from SEA or ANZ area, that also want to get more information about this Anxin Service,…

1

"Object reference not set to an instance of an object” (NullReference Exception) was intermittently reported when executing a customized receiving pipeline when de-batch an incoming message

Problem: ======== “Object reference not set to an instance of an object” was intermittently reported when executing a customized receiving pipeline when de-batch an incoming message. Analysis: ======== 1.       The error was caused by the following first chance Access Violation.   (2fac.347c): Access violation – code c0000005 (first/second chance not available) eax=1e0a7a40 ebx=1e09d858 ecx=00000000 edx=00078272…

0

PSSDIAGForBizTalk Error enumerating virtual servers

  Problem ======== When running PSSDiagForBizTalk in a BizTalk cluster which is not SQL cluster(no SQL server resource in the cluster), the following error is reported: 2011/02/25 15:14:35.48 PSSDIAG Error enumerating virtual servers.  Is your SQL Server instance clustered? 2011/02/25 15:14:35.48 PSSDIAG Error retrieving servers from the configuration file.  Aborting.  Please see Microsoft Knowledge Base…

0

How to remove invalid character in incoming XML message using custom pipeline component

<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> NOTE: This article is migrated from Blog AsiaTech Date: 2010-6-16 3:49 PM Orignal URL: http://blogs.msdn.com/b/asiatech/archive/2010/06/16/remove-invalid-character-in-incoming-xml-message-using-custom-pipeline-component.aspx <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> BizTalk server is usually used as message bus for different platforms and applications. In most scenarios, BizTalk stores and processes messages in XML format. Internally, it calls .NET XML library to do the job. Thus it follows W3C…

2

How does BizTalk detect if a host instance is dead in BTS2K6, 2K6R2 and 2K9?

<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> NOTE: This article is migrated from Blog AsiaTech Date: 2009-11-25 5:39 PM Orignal URL: http://blogs.msdn.com/b/asiatech/archive/2009/11/25/how-does-biztalk-detect-if-a-host-instance-is-dead-in-bts2k6-2k6r2-and-2k9.aspx <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> This job is done by the cooperation between the front end BizTalk host instance process and the backend BizTalk SQL job MessageBox_DeadProcesses_Cleanup_BizTalkMsgBoxDb.   1.       When a BizTalk host instance is started, it will call the store procedure bts_ProcessHeartbeat_<HostName> once…

0

Unable to suspend or terminate active service instance in Biztalk

 <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> NOTE: This article is migrated from Blog AsiaTech Date: 2009-11-25 10:24 AM Orignal URL: http://blogs.msdn.com/b/asiatech/archive/2009/11/25/unable-to-suspend-or-terminate-active-service-instance-in-biztalk.aspx <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> Symptom   When try to suspend or terminate a active service instance, the instance can not be suspended or terminated for a long time, it keeps active with Pending Job of the instance is set to Suspend or…

0

0x800706D9 when contact a SSO master secret cluster

<><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> NOTE: This article is migrated from Blog AsiaTech Date: 2009-11-24 8:43 PM Orignal URL: http://blogs.msdn.com/b/asiatech/archive/2009/11/24/0x800706d9-when-contact-a-sso-master-secret-cluster.aspx <><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><><> Symptom: ==========   You may see the following warning event in a BizTalk machine.   Event Type: Warning Event Source: ENTSSO Event ID: 10536 Description: SSO AUDIT Function: GetConfigInfo Tracking ID: xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx Client Computer: xxx.xxx.xxx (BTSNTSvc.exe:1234) Client User:…

0