September 10, 2019 MS BRE Demystified – Part 2 Custom Tracking in BRE Policies Time to Read: 4 minutes In this post, I will talk about how we can implement correlated tracking while executing BRE Policies from C# code. Categories BizTalk/MS BRE Comments: 0
September 4, 2019 MS BRE Demystified – Part 1 Forward Chaining for optional XML Facts Time to Read: 8 minutes For past few months I have been working on a big project in my organization where we are using Microsoft Business Rules engine for the conditional evaluation of incoming payloads. There are few lessons that I have learnt along the way and I will present them as a part of a blog series centered around the Business Rules Engine. I... Categories BizTalk/MS BRE Comments: 0
August 30, 2018 Could not load file or assembly ‘SSOSettingsFileReader, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b9585ffc9d454e4a’ or one of its dependencies. The located assembly’s manifest definition does not match the assembly reference. (Exception from HRESULT: 0x80131040) Time to Read: 2 minutes Today during my work schedule, I was approached by one of the Front End users and the y complained that BizTalk services were returning faults to them. Upon checking up the logs for the BizTalk application, I came across following error. “Could not load file or assembly ‘SSOSettingsFileReader, Version=1.0.0.0, Culture=neutral, PublicKeyToken=b9585ffc9d454e4a’ or one of its dependencies. The located assembly’s manifest... Categories BizTalk Comments: 0
August 21, 2018 BizTalk DTA Purge And Archive Job Error: Unspecified error occurred on SQL Server. Connection may have been terminated by the server. [SQLSTATE HY000] (Error 0) Unable to find index entry in index ID 1, of table xyz, in database ‘BizTalkDTADb’. The indicated index is corrupt or there is a problem with the current update plan. Run DBCC CHECKDB or DBCC CHECKTABLE. If the problem persists, contact product support. [SQLSTATE HY000] (Error 8646). The step failed. Time to Read: 6 minutes Problem Statement Today when I ran the BHM to check the health of my BizTalk development box, I found that the BizTalk job DTAPurgeAndArchive job was failing continuously. When I opened the history for the job, I found following error logged in the history. “Current Error: ABC\BiztalkService. Unspecified error occurred on SQL Server. Connection may have been terminated by the... Categories BizTalk Comments: 2
July 11, 2018 Understanding BizTalk Oracle Adapter Perfmon Counter and Removing Performance Bottlenecks by Creating Low Latency System Time to Read: 8 minutes Problem Recently I was working on a complex project where I was working on an orchestration which executes a stored procedure in an oracle database. The stored procedure has a simple select query that brings back data for a particular id. We executed the stored procedure from BizTalk using standard WCF-Custom adapter with oracle binding. The stored procedure when executed... Categories BizTalk Comments: 0
July 10, 2018 A peculiar case of Host Instance Shutdown and Stack Overflow Exception Time to Read: 2 minutes Scenario Recently I was working on a complex BizTalk orchestration which calls multiple services and has to catch and parse the particular responses and exceptions received during the service call. The parsing is taken care of by a helper method to which we passed the unique response ids/ soap fault caught on service port and depending upon the business rules... Categories BizTalk Comments: 0
July 6, 2018 BizTalk : Analysis of Direct Mapping vs XDocument Pipeline vs Streaming Pipeline To Process Large Messages for SQL Bulk Insert Time to Read: 17 minutes Introduction Sometimes while developing BizTalk applications, there are requirements where BizTalk developers have to write custom code that will help them achieve the functionality they want. e.g, functionality to process data from excel sheet or to process pdf documents . While in some requirements it becomes necessary that BizTalk developers write custom components which help them, make the BizTalk application... Categories BizTalk Comments: 0
July 6, 2018 A Beginner’s Guide To Logging In BizTalk Using log4net and BTDF Time to Read: 7 minutes Introduction Often is the requirement in software development that the developer trace the flow of the developed application to track any bugs or issues that are raised during the testing or production run. At other times the requirement can be that the developer want to track some mission critical data to files or to custom database for future use or... Categories BizTalk Comments: 2
