I sometime post my own code here so I can find an example I like in the future, rather than having to search the web. So there’s nothing extraordinary with the program below, just a good example of how to do SQL Server update commands using pypyodbc from Python. It’s using a relation database (RDS) […]
There can be many reasons for the python error “module not found”. In my case, I had a laptop with 2.7 and 3.6 both installed.? ?My windows path contained the 2.7 release, but I was running the 3.6 release.? So when I ran from the command line by just typing in “python myprogram.py” it worked.? […]
I needed to access an RDS database (relational data store) from a C# Lambda function.? It took me a while to figure how how to reference it. Build Error: C# Core:System.Data.SqlClient “Data” does not exist in namespace System Solution: Run the following under the Nuget Package console. Install-Package System.Data.SqlClient -Version 4.1.0 Note, it might not […]
This blog explains in more detail why you are probably getting the error and provides two solutions, depending on whether you want to pass just a string or JSON. Error: </pre> { "errorType": "JsonReaderException", "errorMessage": "Unexpected character encountered while parsing value: {. Path '', line 1, position 1.", "stackTrace": [ "at Newtonsoft.Json.JsonTextReader.ReadStringValue(ReadType readType)", "at Newtonsoft.Json.JsonTextReader.ReadAsString()", […]
Often, after implementing a new system or application on BizTalk, we need to provide a report to management of how many files were processed. If you keep an archive of all files in or out, you can use that with a simple PowerShell to accomplish the report. Here’s an example I found: PowerShell Example 1 […]
cls $filename = "c:\Users\Neal\OneDrive\Documents\myFile.html" #example of what I'm trying to pick out <strong>mydomainname.com</strong> $regexPattern = "<strong>(.*?)</strong></a>" gc $filename | Select-String -Pattern $regexPattern -AllMatches | ForEach-Object {$_.matches.groups[1].value} Note that the Matches returns two groups with subscripts 0 and 1. The subscript 0 contains the tags “strong” around the match. the subscript 1 contains just the captured […]
If you are interesting in using C# to Monitor Biztalk, instead of Powershell to Monitor BizTalk, or Powershell to Monitor Diskspace, or Powershell to Monitor EventLogs (and send out emails) then check out this blog and sample code: https://prashantbiztalkblogs.wordpress.com/2017/08/30/monitoring-biztalk-resources-programmatically-using-c/ I didn’t run it, but it looks like a good sample to get started with.
With the SFTP ports in BizTalk 2013, we are using the log function. BizTalk appends each SFTP log to the end of the existing log file. So I created a Powershell Script to take an array of directory names, and run the same re-run and delete logic for each. I also include the logic to […]
You get the following error when you do a BTDF deploy. Error: x does not belong to the same application as “Y” or its references. Full example of error Information: Importing bindings "C:\Users\…\Projects\MyEDIProject\MyEDIProject.Deployment\PortBindings.xml" into application "MyEDIProject" in BizTalk configuration database (server="MyServer1", database="BizTalkMgmtDb")… Error: Failed to update binding information. "Microsoft.BizTalk.Edi.DefaultPipelines.EdiSend" could not be bound to […]
NOTE: If have a newer blog that uses what is demonstrated in this blog to format and rename all EDI files in a disk directory The one thing I didn’t account for (yet), is the case where different files can have different EDI delimiters. Technically, you should look for the end of the ISA segment […]