June 2008 Entries

Biztalk Host Instances not starting

Our production BIZTALK 2006 R2 machine was restarted today but the Biztalk Host Instance services did not start automatically. There was an Event in the Systems Log that stated: The Enterprise Single Sign-On Service service hung on starting When I looked the SSO was started. From prior experiences this tells me that the service depends on another service but the registry did not contain that service. I'm assuming that SSO depends on MSDTC because the SSO db is on another machine. So I added MSDTC ......

Tracking EDI Control Numbers in R2 EDISend Pipelines

After months of working on Biztalk 2006 R2 EDI tracking I'm still not sure how the inbound EDI 997s are correlated to outbound EDI transactions. I need to track certain message properties in the outgoing EDI transactions. For some reason one of our trading partners is not sending 997s for all of the EDI messages we transmit. But I can query their system and see that the transactions were received. So my problem is now finding the outbound EDI messages and somehow resolving the open status. Using ......

VBScript to copy a file to Sharepoint

I searched for some vbscript code to copy a file to a Sharepoint Document Library. This code is based on MS KB 826993 option explicit Dim xmlhttp Dim sharepointUrl Dim fileName Dim tsIn Dim sBody fileName = wscript.arguments(0) Dim ofc Dim ofile set ofc = createobject("Scripting.Fil... set ofile = ofc.getfile(fileName) set tsIn = ofile.openAsTextstream sBody = tsIn.readAll tsIn.close sharepointUrl = http:// Dim sharepointFileName sharepointFileName = sharepointUrl & "/" & ofile.name ......