Home  >  

Tag: Advanced

November 5, 2018

Creating a FitBitAssistantBot using Microsoft Bot Framework and FitBit Web Api : Real Life Example of Authentication Using Azure Bot Service

Time to Read: 14 minutes   Introduction Any business which transacts online requires providing some kind of chat support for the issues related to their business. This can be done by developing chat applications where the consumers directly chat with the agent of the business who then solve their problems. A new alternative to answering frequently asked questions is the use of the Chat Bot...
Categories ASP.NET Core/BotFramework Comments: 2
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 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