We can correlate a 997 with corresponding EDI request message by looking at AK2 segment (AK2:02 = ST02 in request), but by default BizTalk generates AK2 only for failed transactions, thus makes it difficult to correlate 997 with corresponding request in Async setup. To bring AK2 in 997, enable from Parties configuration
I was stuck with this error when starting BizTalk host instances after database connectivity was lost and resumed,
event log:
A failure occurred when executing a Windows service request.
Service request: Start
BizTalk host name: BizTalkServerApplication
Windows service name: BTSSvc$BizTalkServerApplication
Additional error information:
Error code: 0×80131604
Error source: mscorlib
Error description: Exception has been thrown by the target of an invocation.
one of possible reasons (among other is a reported issue in BizTalk – and MS provides CU for it) is a new section in BizTalk config file that is not declared in machine.config. In my case, I added a new config section to define appSettings configuration keys – but I forgot to update machine.config first
<system.configuration> </system.configuration>
The E-Myth Revisited: Why Most Small Businesses Don’t Work and What to Do About It
If your business depends on you, you don’t own a business – you have a job. (and you’re working for a lunatic)
The purpose of going into business is to get free of a job so you can create jobs for other people.
A business that "gets small again" is a business reduced to the level of its owner’s personal resistance to change – its owner’s comfort zone. (works and waits for something positive to happen)
Your business is not your life.
Your business is something apart from you, with its own rules and its own purposes. An organism that will live or die according to how well it performs its sole function : find and keep customers.
The primary purpose of your business is to serve your life (not vice-versa)
Typical owner of a small business prefers highly skilled people because he believes they make his job easier – he can simply leave the work to them.
Unfortunately then the business grows to depend on the whims and moods of its people.
If they’re in the mood, the job gets done. If they’re not, it doesn’t.
In this kind of business, "How do I motivate my people?" comes up : "How do I keep them in the mood?"
It is literally impossible to create a consistent result in a business that depends on extraordinary people.
When you intentionally build your business around the skills of ordinary people, you will be forced to ask the difficult questions about how to produce a result without the extraordinary ones.
You will be forced to find a system that leverages your ordinary people to the point where they can produce extraordinary results over and over again.
Most small businesses are started by people who are skilled at something and who enjoy doing that thing. When these people strike out on their own, they tend to continue doing the work they are skilled at, and ignore the overarching aspects of business. Without clear goals and quantification benchmarks, they soon find themselves overworked, understaffed, and eventually broke.
Every business owner needs to simultaneously be an entrepreneur, a manager and a technician. The technician is the worker-bee, the manager makes sure operations and finances run smoothly. The entrepreneur formulates the goals, and steers the business in the direction needed to reach those goals. Of these three personalities, the entrepreneur is key- -without it, the technician will work to death or bankruptcy. As the business grows, the business owner will need to draw away from the technician work and manager work and delegate this work to others.
here is how to use Exception Handling framework from Orchestration
This post is about couple of errors that consumed lots of time to figure out when testing an implementation that uses ESB Exception Handling framework.
|
in windows event log (BizTalk ESB Toolkit 2.1): Object reference not set to an instance of an object. Source: Microsoft.Practices.ESB.ExceptionHandling.PipelineComponents.ProcessFault Method: Microsoft.BizTalk.Message.Interop.IBaseMessage Execute(Microsoft.BizTalk.Component.Interop.IPipelineContext, Microsoft.BizTalk.Message.Interop.IBaseMessage) Error Source: Microsoft.Practices.ESB.ExceptionHandling.PipelineComponents Error TargetSite: Void WriteHeaderFailedMessageRouting(System.Xml.XmlTextWriter, Microsoft.BizTalk.Message.Interop.IBaseMessage, System.Object ByRef) Error StackTrace: at Microsoft.Practices.ESB.ExceptionHandling.PipelineComponents.ProcessFault.WriteHeaderFailedMessageRouting(XmlTextWriter writer, IBaseMessage pInMsg, Object& portName) |
Reason: // Add the message to the Fault Message
Microsoft.Practices.ESB.ExceptionHandling.ExceptionMgmt.AddMessage(MsgFaultMultipart, MsgInboundMessage);
this line is required in Orchestration code for ProcessFault pipeline component to work. |
| in windows event log: xlang/s engine event log entry: Uncaught exception (see the ‘inner exception’ below) has suspended an instance of service (a42d0855-ec7c-3dc7-5e9f-442c84746e85)’. If resumed the instance will continue from its last persisted state and may re-throw the same unexpected exception. InstanceId: 003a57d2-42b3-4a20-8cfa-a03b810df217 Shape name: Send_1 ShapeId: ad8c422b-4b45-41c5-bd0b-5ce958491e1e Exception thrown from: segment 5, progress 8 Inner exception: Exception occurred when persisting state to the database. Source: Microsoft.XLANGs.BizTalk.Engine Target Site: Void Commit() The following is a stack trace that identifies the location where the exception occured at Microsoft.BizTalk.XLANGs.BTXEngine.BTXXlangStore.Commit() at Microsoft.XLANGs.Core.ServiceContext.PendingCommit(Boolean ignore, XMessage msg) at Microsoft.XLANGs.Core.ExceptionHandlingContext.PendingCommit(Boolean ignoreCommit, XMessage msg) at Microsoft.XLANGs.Core.ExceptionHandlingContext.PendingCommit(Boolean ignoreCommit, XMessage msg) at Microsoft.BizTalk.XLANGs.BTXEngine.BTXPortBase.SendMessage(Int32 iOperation, XLANGMessage msg, Correlation[] initCorrelations, Correlation[] followCorrelations, Context cxt, Segment seg, ActivityFlags flags) at XX.segment5(StopConditions stopOn) at Microsoft.XLANGs.Core.SegmentScheduler.RunASegment(Segment s, StopConditions stopCond, Exception& exp) Additional error information: A batch item failed persistence Item-ID 5f10694f-5a1f-4b05-ab88-6c9edbd1140d OperationType MAIO_CommitBatch Status -1061151998 ErrorInfo The published message could not be routed because no subscribers were found. . Additional error information: Failed to publish (send) a message in the batch. This is usually because there is no one expecting to receive this message. The error was The published message could not be routed because no subscribers were found. with status -1061151998.
|
| Reason: 1. Add Microsoft.Practices.ESB in your Application’s References 2. configure a SQL send port with ProcessFault pipeline component to insert exception in ExceptionDB. (Alternatively, we can use All.Exceptions send port that was created with ESB Core installation)
|
After installation and configuration of ESB Toolkit 2.1, ESB Portal gives this error. I tried to debug ESB.Portal solution but unfortunately Microsoft does not provide source code for BizTalk Operations Service and we are left with trying different options.
The reason in this case was that BizTalk Operations Service Application Pool user should be member of BizTalk Administrator group (or some other BizTalk group who has permissions to retrieve list of installed BizTalk applications.
HL7 Disassembler writes parsing errors in windows event log and there is no documented way to get those error through code to log in custom database or some other data store.
Here is what HL7 pipeline writes into event log:
we can get these error in code by writing a wrapper disassembler component on top of HL7 OOTB Disassembler
Omitting details about how to write a custom pipeline component, we just need to override Disassemble and GetNext methods
public HL7DASM()
{
HL7Dasm = new HL72fDasm();
}
public new void Disassemble(IPipelineContext pContext, IBaseMessage pInMsg)
{
HL7Dasm.Disassemble(pContext, pInMsg);
}
If HL7 party is configured to return ACKs, GetNext() method will execute multiple times.
public new IBaseMessage GetNext(IPipelineContext pContext)
{
IBaseMessage msg = HL7Dasm.GetNext(pContext);
if (msg != null && !msg.BodyPart.Data.CanSeek) //if parsing fails, stream is not seekable
{
FieldInfo ParserErrorField = HL7Dasm.GetType().GetField("mBodyErrors", BindingFlags.NonPublic | BindingFlags.Instance);
var ParserError = (System.Collections.ArrayList)ParserErrorField.GetValue(HL7Dasm);
StringBuilder errorList = new StringBuilder();
foreach (HL7Error error in ParserError)
{
errorList.AppendLine(error.ToString());
}
// now errorList string contains all parsing errors details in same format as in windows event log
}
}
return msg;
}
The most common cause of following errors are if same schema deployed multiple time in BizTalk. Sometimes this is desirable behavior, for example, if same schema is shared by two different BizTalk application.
Since BizTalk applications are just logical grouping of BizTalk artifacts, schemas deployed for one application will be visible to other applications and might create this type conflict.
========================================================================
There was a failure executing the send pipeline: "Microsoft.BizTalk.DefaultPipelines.XMLTransmit, Microsoft.BizTalk.DefaultPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Source: "XML assembler" Send Port: "PCISendPort" URI: "oracledb://x:1521/X/Dedicated" Reason: This Assembler cannot retrieve a document specification using this type: http://Microsoft.LobServices.OracleDB/2007/03/PC/Package/STORED_PROCEDURES_2#STOP_LIST
There was a failure executing the response(receive) pipeline: "Microsoft.BizTalk.DefaultPipelines.XMLReceive, Microsoft.BizTalk.DefaultPipelines, Version=3.0.1.0, Culture=neutral, PublicKeyToken=31bf3856ad364e35" Source: "XML disassembler" Send Port: "PCISendPort" URI: "oracledb://x:1521/PCI/Dedicated" Reason: Cannot locate document specification because multiple schemas matched the message type http://Microsoft.LobServices.OracleDB/2007/03/PC/Package/STORED_PROCEDURES_2#STOP_LISTResponse.
========================================================================
Solution:
Create a new send port for service, go to send pipeline properties and set DocumentSpecNames property to fully qualified name of schema in format <schema type>+<root name> ,<schema assembly full name>. This Pipeline property tells BizTalk exact location of schema to be loaded and thus avoid conflict
for example: ReportLostV2.CardReportLostPC_Package_STORED_PROCEDURES_2+STOP_LIST, Card.ReportLostV2, Version=1.0.0.0, Culture=neutral, PublicKeyToken=9b51853b6987xxxx
you can get DocumentSpecNames value from SchemStrongName context property.
