Monthly Archives: April 2013

BizTalk : EDISend 71: Transaction Set or Group Control Number Mismatch

Whilst assembling EFACT_D03B_INVOIC messages today with the EDISend pipeline I received the below error. If populating the UNH segment be sure to set the UNH1 field to *. E.g. <UNH1>*</UNH1> Error: 1 (Miscellaneous error) 71: Transaction Set or Group Control … Continue reading

Posted in BizTalk Server | Leave a comment

BizTalk : BAM Add Users to Views

Logging here for my own future reference as I always seem to forget the syntax.

Posted in BizTalk Server | Leave a comment

C# Convert between Gregorian and JDE Dates

JDE supports a julian type date format counting days from the year 1900 in the format CYYDDD. Below are helpers that may be used when mapping to and from JDE. Convert Gregorian to JDE Julian Convert from JDE Julian to … Continue reading

Posted in .NET, BizTalk Server | 2 Comments

BizTalk BAM : The server encountered a critical failure while trying to access the list of Views

To fix this error first unconfigure the BAM Portal feature via the BizTalk Configuration wizard. Then delete the BAMPortal application pool and BAM virtual directory. You may receive an error indicating there are applications still in the application pool. If … Continue reading

Posted in BizTalk Server | Leave a comment

BizTalk DB2 Adapter SQLCODE 510

When trying to use the DB2 adapter on a receive location with the Update Command and receiving the below error, be sure your have FOR UPDATE and WITH NC on your select statement. “The adapter “DB2” raised an error message. … Continue reading

Posted in BizTalk Server | Leave a comment

BizTalk Tip : XPATH to Update Messages

The XPath xLangs function allows us to set message fields when using untyped messages. OrderMetadata.BodyPart is of type System.Xml.XmlDocument.

Posted in BizTalk Server | Leave a comment

BizTalk Tip : Calling Rules from an Expression Shape

See below from an orchestration expression shape to call a BRE policy. Add a reference to the Microsoft.RuleEngine assembly which you will most likely find in :\Program Files (x86)\Common Files\Microsoft BizTalk\Microsoft.RuleEngine.dll. In the below after calling the Policy.Execute method from … Continue reading

Posted in BizTalk Server | Leave a comment