February, 2010

We are just putting together the details for the SBUG meeting in April, the registration page is already open on the following link http://sbugapril2010.eventbrite.com/

We have an SBUG meeting in may planned where Udi Dahan (nServiceBus) will join us. Check out the following for details: http://sbugmay2010.eventbrite.com/

I recently built a POC that wrapped an SAP RFC call in a WCF Service exposed by BizTalk. I exposed schemas as WCF services instead of opting for exposing the Orchestration as a WCF Service. The purpose of the Service was to validate a utility meter’s status inside of SAP.  Some of the statuses may include active/inactive/meter not found.  The RFC that I used is called RFC_Read_Table.  This is a pretty generic, out of box,  RFC that allows you to query SAP tables.  The RFC...

[In addition to blogging, I am also now using Twitter for quick updates and to share links. Follow me at: twitter.com/scottgu ] Patrick recently posted about something he found odd when installing the VS 2010 RC – which was that code intellisense for...

I ran into a situation where I needed to get the last value from a re-occurring node that SAP was returning. In order to extract the last record, I utilized the Record Count functoid and fed that value into the Index functoid. The Index functoid is also fed with the value from the "WA" element that I am really interested in. The result is then passed to a String Concatenate functoid where the data is enriched before being assigned to the destination document.

Hotfix for resolving issues with references between projects: http://support.microsoft.com/?kbid=977428 Hotfix for problem with orchestrations saying “The expression that you have entered is not valid.” when they are in fact valid: http://support.microsoft...

The San Diego .NET User Group will be hosting our first Azure day-long conference on March 6th. This first one will be more overview level, we’re planning at least one other which will be more focused and deeper for later this year, and then perhaps more after that. For this first one, we will be covering:   Azure Intro (David Chou) Azure Development (Daniel Egan) SQL Azure (Lynn Langit) Azure AppFabric (Brian Loesgen)   And yes, the way it turned out, all speakers for this are from Microsoft...

Pure XSLT is very powerful but it definitely has its weaknesses (I’ve written about how to extend XSLT using mapping and BizTalk previously here) … One of those are handling numbers that uses a different decimal-separator than a point (“.”). Take for...

BizTalk: Compensation Model Charles Young mentioned, the Compensation is one of the most under-used features of the BizTalk. [“ BizTalk Server 2006: The Compensation Model ” http://geekswithblogs.net/cyoung/articles/100424.aspx ] If you didn’t read his...

When deploying the Microsoft.BizTalk.ESB.BAM.Exceptions.xml BAM activity (as part of the Core ESB Toolkit install) we ran into this error: --- OLE DB error: OLE DB or ODBC error: DBNETLIB][ConnectionOpen (Connect()).]SQL Server does not exist or access...

A couple of people have reported a nasty bug in the PowerShell Provider version 1.0 Beta. The provider doesn’t seem to work when SQL Server (hosting the BizTalk management database) is on a remote SQL Server. Although we will have this fixed in the 1...

This is part ten of a twelve part series that introduces the features of WCF WebHttp Services in .NET 4. In this post we will cover: Generating and including ETags in responses from a WCF WebHttp Service Adding Conditional GET support to a WCF WebHttp Service using ETags Over the course of this blog post series, we are building a web service called TeamTask . TeamTask allows a team to track tasks assigned to members of the team. Because the code in a given blog post builds upon the code from the...

I had this exception in the Application Event Log after trying to bring up the portal in IE (after a newly installed and configured BizTalk & ESB platform): --- Exception information: Exception type: WebException Exception message: The remote server...

The following warning is often seen on servers running Microsoft Host Integration Server: Log Name: Application Source: SNA Base Service Date: date Event ID: 561 Task Category: None Level: Warning Keywords: Classic User: user Computer: computer Description: Write to mailslot or socket failed, rc = 64 EXPLANATION A Win32 WriteFile() or winsock sendto() call failed. The return code is shown. ACTION Provide network support personnel with the event log file(s) related to SNA, and the return code included...

When adding a Web reference to a BizTalk project, the following message appears: There is a problem with the WSDL but you don't get any extra information. The cause was this part in the WSDL: <port binding="tns:TestServicePortBinding" name="TestServicePort"> <soap:address location=" REPLACE_WITH_ACTUAL_URL "/> </port> Apparently a BizTalk project can't handle an invalid location (a Console project doesn't have any problem with this!). The...

Look at the next version of BizTalk 2009 R2, coming soon, and then think what else would I like to ...

WSCF.blue v1.0.7 now supports VS10 RC in addition to VS2008. There are no new features as such although v1.0.6 which we released a short while ago fixes a number of important bugs in data contract generation. Alex , our code-master extraordinaire, blogged...

Haven’t blog for awhile since I am preparing for a session I giving on Monitoring Business Integration Suite (branded for SQL Server, BizTalk Server and MOSS in an integration context). This session will be given during the Dutch Application Platform Event . Will be my second talk I ever done for general public so one way I am quite excited (only time preparing a lot of stuff (demo’s) is hard task to do). Now I am enjoying my holiday currently in Chester (UK) and still cannot stay away from my laptop...

While browsing Microsoft's Virtualization site, I stumbled across an upcoming event: Looking at Desktop Virtualization including VDI? Thinking about Windows 7 migration; wants savings, but wondering about ROI? Join Microsoft, industry experts and...

Last week, I spent some time looking at a problem with a customer's orchestration. In one place, the developer had made use of the infamous BizTalk xpath() function to assign a value in one message to a decimal field in another message. He got an...