The BizTalk roundingfunctoid uses “Banker’s rounding” by default. That means if you have odd numbers round away from zero, and even numbers round towards zero. For example, 1.5 rounds to 2, and 2.5 rounds to 2. This is the a “fair” way of rounding, so that neither party in a business transaction benefits. I’m currently […]
Error A message sent to adapter "BiztalkMessagingEngine" on send port "XX.FMA.Extract_1.0.0.0_XX.FMA.Extract.SendExtract_DynamicFTP_f136abb33540170c" with URI "ftp://1.2.3.101:21/%SourceFileName%" is suspended. Error details: Unknown Error Description MessageId: {28F29FA5-18EF-4FE7-B6CC-E03F4E2AA26F} InstanceID: {C09E16A5-11AB-46AF-980A-7826772EEF0B} Background We moved code to a new target environment, where the Host-Instances didn’t match the source environment. We reconfigured some of the HostInstances to allow for a default 32-bit host instance, […]
In the place where I work, we have numerous SendPorts that we sometimes enable that create copies of BizTalk messages on the disk, in a directory called D:\MessageLog (with various sub-directories). Rarely do we need to go back more than 2 or 3 days to see these files. We have a Powershell script in place […]
I finally found the dream tool I have been wanting to work with the Application Event Log (for BizTalk, or for any other server related issues). FSPRO Labs makes a tool called “Event Log Explorer” http://www.eventlogxp.com/ How it is useful to me: 1) Most often, I have the same bogus error or warning occurs 1000s […]
Here’s a great checklist for a BizTalk Adminstrator to install BizTalk: http://biztalkadmin.com/setting-up-a-new-biztalk-2010-environment/?goback=.gde_1893939_member_224699608 by Tord Glad Nordahl
Today, I recycled one of my host instances, and it didn’t start. Then I tried all of them, and several had issues. Finally, it dawned on me that I had changed the 64-bit config file: “c:Program Files (x86)Microsoft BizTalk Server 2010BTSNTSvc64.exe.config”. The 32-bit host-instances were all starting fine, because it uses a different config file […]
— MSSQL Server string to date conversion – datetime string format sql server — MSSQL string to datetime conversion – convert char to date sql server SELECT convert(datetime, ‘Oct 23 2012 11:01AM’, 100) — mon dd yyyy hh:mmAM (or PM) SELECT convert(datetime, ‘Oct 23 2012 11:01AM’) — 2012-10-23 11:01:00.000 — Without century (yy) string date […]
We have one table with about 120 columns in it. I was just curious what the average row size was, and found this slick solution: Use DBCC to find the “Average Size of a Row” Syntax: dbcc showcontig (‘your_table_name‘) with tableresults My tablename=’Transaction’, so substitute your tablename there. Example: dbcc showcontig (‘Transaction’) with tableresults Enlarged: […]
Below is a code fragment I use to extract a matching string using RegEx (C# Regular Expression). I put it in a class library, and make it available to BizTalk Orchestrations, Pipeline, and Map Scripting functoids that might need to call it. <pre> //using System.Text.RegularExpressions; <– put this above your class, put the method below in […]
Error: Failed to load Group xxxx.BizTalkMgmtDb] data providers (in BTSAdmin Console) Solution: Verify SQL Server is available, if not, start-it. Screen shot below shows trying to connect to the SQL server; it might be on the same machine as BizTalk or it might be on another machine. The above error could also indicate a communication […]