Today, I was looking into an issue where a property was getting promoted with a null value though we were expecting property to not get promoted as the element was not present in the input message. Due to this, our subscription criteria at the Send Port...

Today I was looking into an issue where we were receiving following error in the event log while trying to start the SSO Service. Event Type:    Error Event Source:    ENTSSO Event Category:    Enterprise Single...

I was working with a customer recently where they do not want to install SSIS on the SQL Server hosting BizTalk databases, instead the requirement was to have a separate server dedicated to SSIS which will run the BAM packages. At the first instinct,...

I have seen many BizTalk customers running into OutofMemory Exception while calling a map from inside the Orchestration, so I thought this blog post should help. Typically, this happens when we are calling a map from inside the Orchestration and the map...

Have you seen the below error? If yes, may be this post helps. My customer was receiving below error and the strange thing was that though we receive this error in the event log, but we do not see any suspended or dehydrated orchestration in the BizTalk...

Just wanted to point you all to http://blogs.msdn.com/biztalkcrt/archive/2009/10/28/biztalk-and-net-4-0.aspx , which says not to install .NET 4.0 on existing Biztalk installations. This is still being investigated.

There would be scenarios where you are inserting into a Parent table which have got an auto incrementing or an Identity field and you need to get this identity value back and use it to insert into child table records. And that too all, in a single transaction...

If you are trying to send or receive message to MQ Server using the MQSeries Adapter, and receiving following errors in the application event log: on BizTalk Server Event ID: 5740 Description: The adapter "MQSeries" raised an error message....

Recently, I was working on a support incident where the customer have modified 837I HIPPA schema by adding a child node under DTP segment. But, while we tried to validate an instance against the schema at both design time and run time, we will get error...

Sometime back I worked on a case where the spool would go very high and I have been thinking to blog this for some time now and today I decided I will process this awaiting queued item in my mind. I had a customer who was seeing a surge in the spool count...

Recently, I worked on a BAM issue and I wanted to share with you all some interesting facts which I found while researching on this. Customer implemented BAM Activities with Event Streams. They were using OrchestrationEventStreams within Orchestrations...

This was an interesting issue on which I worked with Shaheer (Biztalk Escalation Engineer) for 2 customers, so I thought I would share it with all. Customer is using File Adapter at Send Port to write files to a file server. Sometimes, the send message...

Receiving German Characters in the EDI message received by Biztalk 2006 R2. We have set the character set to "Extended" in the receive pipeline but it still fails in the receive pipeline. Solution: Found that the char set ‘Extended’ does not...

Receiving following error at the Receive Pipeline while using MSMQ adapter in Biztalk 2006: A message received by adapter "MSMQ" on receive location "xxxxxxxxxxx" with URI "xxxxxxxxxxx" is suspended. Error details: There...

Recently, I saw an issue where we were observing deadlocks between the stored procedures 'bts_InsertTrackingData' and 'TDDS_GetTrackingRecord' and this happens when there is a huge load for BizTalk to process. What we found that Tracking was enabled on...

If we are using Multi-part Message inside Orchestration and we have any part which is of simple type, then we cannot directly access any message part of this Multi-part Message from the transform shape inside Orchestration. This is a limitation with the...

Ever wondered why the BAM SSIS packages for archiving (BAM_DM_<activity_name>) is not archiving the data from BAMPrimaryImport DB to BAMArchive DB though we see that the package executes successfully. Ok. This may be the reason. The BAM SSIS packages...

Yesterday, KB 952555 got published which talks about how to maintain and troubleshoot Biztalk Server databases. This is a very useful article and must to be followed if you want Biztalk to be in good shape specially if performance is a key factor. Thank...

Problem Statement: I will be receiving two different messages (Message1 and Message2) inside orchestration each with multiple records. Now, I have to join these messages in a map inside orchestration based on TRANID and PROCID. So basically, I have to...

Recently, I was working on an interesting case where we were not able to configure Biztalk Rules Engine in Biztalk Server 2006. All the other components got configured sucesfully but BRE was failing with error "Rule Engine Update Service is not a valid...

I have seen most of the issues coming with slow processing of messages in production by Biztalk where the root cause is only due to large size of Biztalk databases. Though, Biztalk comes with SQL Jobs which maintains the Biztalk databases and keep...

I am very excited about starting my own msdn blog. Here I will be posting my experiences and new problem solutions that I provided to my customer as a Biztalk Support Professional.