Xpath – selecting element by attribute value

Using the sample data below, I wanted to get all the Link node that have LinkID = 13 (not the Junk node). Sample data <whatever>   <Links>       <Link LinkID='13' />       <Junk LinkID='13' />       <Link LinkID='1' />       <Link LinkID='13' />   </Links> </whatever> What fails are these: //*[local-name()=’Link’]/*[@LinkID=’13’] (XPath returned 0 items) //*[local-name()=’Links’]/[local-name()=’Links’ and @LinkID=’13’] ( Unexpected token […]

Take Inventory of Your BizTalk Artifacts

Do you need to “take inventory” of your BizTalk artifacts (assets)? I.e. Get a simple count or high-level summary for your BizTalk Artifacts? For years, we’ve had tools like BizTalk Documenter (free on CodePlex), but that just works for one application. What if you walk into a client site and you want to know in […]

How I Found a SQL Injection Hacker

This is how I found a SQL Injection Hacker who was changing all the product titles in my custom shopping cart using a diabolical injection technique. First, I knew the problem was happening, because I saw HTML inserted into my product titles and product descriptions of my database and website. My application was written in […]

Two BTDF Mistakes SSOSettingsFileImport.exe and Cannot Enlist Orchestration

Error: SSOSettingsFileImport.exe /userGroupName:"BizTalk Application Users" /adminGroupName:"BizTalk Server Administrators" exited with code 1 Solution: In this case, you probably didn’t change the values of the SsoAppUserGroup and SsoAppAdminGroup in the default SettingsFileGenerator.xml, and your site has different user groups for SSO. Error: Could not enlist orchestration… Solution: This can happen when you forget to change the […]

Configuring Windows 2012 SMTP for CDONTS (Classic ASP)

I spent about three hours chasing down these errors Three Different Errors in my IIS Log When using Port: 80040213 The_transport_failed_to_connect_to_the_server. 8004020f [no text, just this code] When using Pickup Directory” 80040222 The_pickup_directory_path_is_required_and_was_not_specified So when reading other blogs, they often tell you to change from Pickup Directory to Port or vise versa. Context This code […]

Passing Custom WCF Soap Headers from BizTalk

How to Pass Custom WCF Soap Headers from BizTalk using WCF.OutboundCustomHeaders I needed to call a WCF webservice from BizTalk that required three SOAP fields. In addition to Username and Password (standard), they had one custom field called ApplicationID. Code in Message Assignment Shape xmlDocSoapHeader.LoadXml( "&lt;headers&gt;" + " &lt;Username&gt;" + strSOAPUserFromSSO + "&lt;/Username&gt;" + " […]

BizTalk: Errors exist for one or more children

The error “Errors exist for one or more children” can often be tricky to uncover. Usually, when I get this error, I double click on it, and an orchestration shape will be slightly highlighted or bolder than normal, and it will have a red exclamation point on it. You then open it, look for a […]

Setting up GoDaddy to work with Amazon AWS EC2

Here are the steps I used to setup GoDaddy to use my Amazon EC2 Instance (running Windows 2012 with IIS). I first tested with an old domain that I was no longer using called Discount-Protein.com. First I created a new “Elastic IP Address” and assigned it to my EC2 Instance.  After setting it up, it […]

BizTalk AllowUnrecognizedMessage – Cannot Locate Document Specification

Error to Solve “Cannot locate document specification because multiple schemas matched the message type” as shown in context here: 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: “sp_someWebServiceSendPortName” URI: “http://MyServer/MyDir/MyService.svc.svc?wsdl” Reason: Cannot locate document specification because multiple schemas matched the message type “http://tempuri.org/#SendMessageResponse”. One Possible […]

Error: IDENTITY_INSERT is already ON for table. Cannot perform SET operation for table

T-SQL Error IDENTITY_INSERT is already ON for table schema.SomeTableName. Cannot perform SET operation for table Table Name. Solution At any time, only one table in a session can have the IDENTITY_INSERT property set to ON.  So when you try to set it ON for another table, without turning if off for the first table, this […]