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

Article translations Article translations
Article ID: 943355 - View products that this article applies to.
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 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

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\

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.

STATUS

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

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.

Properties

Article ID: 943355 - Last Review: November 19, 2007 - Revision: 1.2
APPLIES TO
  • Microsoft BizTalk Adapter for Oracle Database
Keywords: 
kbtshoot kbexpertiseadvanced kbprb KB943355

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com