Every case is unique, but here’s what happened to me. My goal was to receive a CSV file, and have it split into multiple output files in the Send Port. I did specify my CSV flat-file pipeline in my Receive Location’s Pipeline. I took over a project at a new client. And while re-writing the […]
I got this error from the following Scripting Functoid with inline C# script: <pre> public int PutHL03() { if (hl01 > 2) return "I"; else if (hl01 == 1) return "S"; return "0"; } </pre> You can see it is returning string, but I specified the return type as “int”. Just changed […]
Error Message on dropping an EDI file: The interchange had a structural error in-before the first functional group The issue was that I had taken a large 846 inventory file that had 1000s and 1000s of rows and I just took the first 10 or 20 rows using a text editor. So what I had […]
The following is the generally document way fo doing this: System.Convert.ToString(Microsoft.XLANGs.Core.Service.RootService.InstanceId); However, sometimes, for no apparent reason, it won’t compile, or at least shows a “red dot” on the upper right corner of the expression shape, even though it is technically correct. Sometimes if you open it, and close it, or move it and move […]
I deleted a BizTalk SendPort from the EDI agreement, but when trying to delete the same SendPort from the EDI Party, got the cryptic error: “Sequence contains no elements”. I had been doing a proof of concept with Role Links, and turned out that I still had the roles enlisted. I found that out when […]
The following Powershell function will add all files not yet added, then do a commit with the message provided in the call to the function, then do the push. The prerequisite is that the “GIT” command line is installed and available. I was earlier looking for an API, but I think this is the apparently […]
Full Error System.InvalidCastException: Failed to convert parameter value from a String to a IEnumerable`1. —> System.InvalidCastException: Invalid cast from ‘System.String’ to ‘System.Collections.Generic.IEnumerable`1 [[System.Data.Common.DbDataRecord, System.Data, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]]’. at System.Convert.DefaultToType(IConvertible value, Type targetType, IFormatProvider provider) at System.Convert.ChangeType(Object value, Type conversionType, IFormatProvider provider) at System.Data.SqlClient.SqlParameter.CoerceValue(Object value, MetaType destinationType, Boolean& coercedToDataFeed, Boolean& typeChanged, Boolean allowStreaming) — End of […]
The field “FilterBytes” contains the subscription filters for batching. We are converting from 2010 to 2013, and I need the a report of the “source of truth” as to which of our customers goes to which party, so we build the same parties correctly in 2013. <pre> select top 1000 p1.Name as PartnerNameA, p2.Name as […]
I needed a list of files from a huge directory of file for certain companies, and the company name was the prefix of the filename. The company names are added to an array of strings. This script recursively gets all filenames in a given directory, tests them to see if the start with any of […]
BTDF deploy on local machine in Visual Studio by using “Tools”, “Deployment Framework for BizTalk”, “Deploy BizTalk Solution” failed with the following error in XmlPreprocess.exe /s:: Argument expects a parameter What caused the error for me was that I in the SettingsFileGenerator.xml spreadsheet, I had renamed all the “Settings File Names” for each environment. I […]