Error: The document specification <ddlname.schemaName+SchemaRootNode> from assembly <etc…> failed to load. Verify the schema for this document specification is deployed and is in the Global Assembly Cache. Solution 1: In our case, this happened when we ran a C# client tester program that called an orchestration published as a WCF service. The Application Pool was […]
I think most blogs talk about requiring that the PortType be “Public” instead of “Internal”. However, today I learned that not only do you have to build (compile) the orchestration, you must also deploy it. Even though I compiled, the new port was not appearing in the WCF Publishing Wizard. I was getting desparate, finally […]
When trying to export an MSI from BizTalk Admin Console for an application, I got this error: “Unable to serialize web directory… Verify the location exists and it is accessible” Example of error in BizTalk Admin Console In my case, we had SharePoint on the same machine as BizTalk, and thus a coworker set […]
CodePlex is long gone, but the script can now be found here: https://github.com/koenmd/AutoAudit/blob/master/README.md A few years ago I discovered a great utility called “Auto Audit” on CodePlex by Paul Nielson (author of “Sql Bible”) and John Sigouin. The best thing is that it creates triggers that audit insert, update, and deletes on any desired table. […]
Powershell can be useful for parsing or harvesting data from the web via means of the “Invoke-WebRequest”. Among other things, it can return a collection of links. The code below loads a page from Wikipedia and loops through the collection of links, looking for a certain pattern to find all the cities in a state. […]
Today’s Powershell example is something that I know I will re-use, so I wanted to put it in a place where I could always find it, i.e. on my blog. The main purpose of this example is to show how to route output from a cmdlet to a formatted or “pretty” output, such as as […]
What is SpinTax? SpinTax is a way of “spinning” text. It’s often used by somewhat spammy marketing programs to post different words, phrase, or articles to different web or social media sites. It is designed to create somewhat readable but yet random text, based on changing synonyms for various words. There are actually programs that […]
It’s a fairly common practice to change the Deploy Server from a specific machine name to “.” or “(local)”. I’m at a new client, where the security isn’t all set up properly. So when I changed the server name to “(local”) I got the error: No BizTalk Configuration database(s) found on server ‘(local)’ Since I’m […]
For a while, I’ve been wanting to explore deeper or “hack” into the internals of the BizTalk Databases, i.e. BizTalkMsgBox and BizTalkDTA. When do records gets stored in these database, how long do they stay there, and when do they get “cleaned-up”. So here is my first scenario. I use a SQL command to Find […]
In this blog, I’ll be showing how a Microsoft cursor in T-SQL is similar to and different from the most similar cursor in Oracle. Oracle actually has 3 or 4 ways to do “explicit” cursors, so in this blog, we will look only at the one that is most similar. I tried to format […]