We’ve encountered a few quirky things with the Oracle database adapter for BizTalk, so I thought I’d point out a few Microsoft KB articles and hotfixes that you should be aware of if you’re using this adapter.
- FIX: One of the Microsoft BizTalk Adapters for Enterprise Applications stops processing incoming messages until you restart the BizTalk Host instance. I’ve gotten this one a couple of times in production under high load situations. I’ll probably reduce the number of “concurrent connections” to 1 for each individual send port.
- FIX: Error message when you use Microsoft BizTalk Adapter for Oracle Database and when you call a stored procedure on an Oracle server: “Error Code 6550”. This has to do with using the NUMBER data type in Oracle.
- FIX: An event may be logged when you use BizTalk Adapter for Oracle Database. This is a horrible article name (could it BE any more generic), but has to do with not passing in DATE values when doing inserts into Oracle tables.
- FIX: The Runtimeagent.exe process stops responding when you make concurrent calls by using BizTalk adapter. I really dislike that all I see in the Windows “Processes” pane is a bunch of “runtimeagent.exe” and there’s no way to see which .exe is doing what. This is another KB that has to do with concurrency.
- FIX: You receive an “Import Error” error message when you try to import an .msi file for a BizTalk application. I’m actually not sure why this is a hotfix. Anytime you have a binding with passwords, the actual password is replaced with “******”. I’ve gotten into the habit of keeping my binding files separate from my MSI when using the Oracle or Siebel adapters. That way, I never have an MSI with passwords embedded in clear text.
FIX: BizTalk Adapter for Oracle Database modifies the data in the DateTime field when you use the Insert method, the Update method, or the Query method. Read that again. The adapter assumes everything is in GMT time. So, when doing inserts or queries, the date is converted to a local time. Big ramifications if you don’t realize that (or apply the hotfix).
For some reason you need a compass and secret handshake to find these freakin’ things on the Microsoft website, so to grab the full list of Oracle adapter KB articles, visit here.
Technorati Tags: BizTalk