August 27, 2018

Versioning in LUIS: How to update current LUIS application to add/remove artifacts

Time to Read: 9 minutes Introduction Recently while going through the Microsoft Forums on Language Understanding Intelligent Service (LUIS), I came across a question where the OP(original Poster) was asking it if possible to update the LUIS application with new data without loosing the old data that was used to train the application. In this post I will try to answer the question by using...
Categories Language Understanding Intelligent Service 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 9, 2018

Logic Apps 101: Inserting Data Into Multiple Tables Using SQL Connector and Trigger(SQL)

Time to Read: 6 minutes Introduction In modern day integration, there are many cases where the front end(web app/api) is hosted in cloud and some or whole part of the data store is on cloud or on premises and the integration code has to populate the data /fetch and perform the CRUD operations on the tables based upon the request. In such scenarios, Logic Apps...
Categories Logic Apps 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