Article ID: 943355 - Last Review: November 19, 2007 - Revision: 1.2

Event ID 0 is logged in the Application log when you use Microsoft BizTalk Adapter for Oracle Database on a 64-bit server

View products that this article applies to.
System TipThis article applies to a different operating system than the one you are using. Article content that may not be relevant to you is disabled.
Important This article contains information about how to modify the registry. Make sure that you back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:
322756  (http://support.microsoft.com/kb/322756/ ) How to back up and restore the registry in Windows
Expand all | Collapse all

SYMPTOMS

When you use Microsoft BizTalk Adapter for Oracle Database on a 64-bit server, event ID 0 is logged in the Application log. Specifically, this problem occurs as follows:
  • When you use the Add Generated Items Wizard at design time, the following event is logged in the Application log:

    Event Type: Error
    Event Source: Microsoft BizTalk Adapters for Enterprise Applications
    Event Category: None
    Event ID: 0
    User: Not applicable
    Description:
    Exception occurred:
    Error Code: 12154 (0x2f7a)
    08004 : [Oracle][ODBC][Ora]ORA-12154: TNS:could not resolve service name

  • When you run a Microsoft BizTalk Server application that uses the BizTalk Adapter for Oracle Database, an event that resembles the following event is logged in the Application log:

    Event Type: Error
    Event Source: Microsoft BizTalk Adapters for Enterprise Applications
    Event Category: None
    Event ID: 0
    User: Not applicable
    Description:
    Invalid target:
    Remove@OracleDb://ServerName/UserSchema/Tables/TableName

Back to the top

CAUSE

This problem occurs because some versions of the Oracle client software cannot handle the parenthesis in the value of the InstallPath registry entry in the following registry key:
HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\BizTalkAdapters\
The following value is the default value of the InstallPath registry entry:
C:\Program Files (x86)\Common Files\Microsoft BizTalk Adapters for Enterprise Applications\
Back to the top

WORKAROUND

Warning Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.

To work around this problem, follow these steps:
  1. Click Start, click Run, type regedit, and then press ENTER.
  2. In Registry Editor, locate the InstallPath registry entry in the following registry key:
    HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\BizTalkAdapters\
  3. Change the value of the registry entry as follows:
    C:\Progra~2\Common Files\Microsoft BizTalk Adapters for Enterprise Applications\
  4. Exit Registry Editor.
Back to the top

STATUS

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
Back to the top

MORE INFORMATION

After you change the value of the InstallPath registry entry, the BizTalk Adapter for Oracle Database should work correctly. However, when you install or uninstall a hotfix for BizTalk Adapter for Oracle Database, the registry entry may be changed back to the default value. If this occurs, you have to change the value of the registry entry again.
Back to the top
APPLIES TO
  • Microsoft BizTalk Adapter for Oracle Database
Back to the top
Keywords: 
kbtshoot kbexpertiseadvanced kbprb KB943355
Back to the top