You are currently offline, waiting for your internet to reconnect

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

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
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: 11/19/2007 18:10:19 - Revision: 1.2

Microsoft BizTalk Adapter for Oracle Database

  • kbtshoot kbexpertiseadvanced kbprb KB943355
Feedback