Microsoft KB Archive/943355

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

Article ID: 943355

Article Last Modified on 11/19/2007

-

APPLIES TO


 * Microsoft BizTalk Adapter for Oracle Database

-



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 XP and Windows Vista



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:

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:  Click Start, click Run, type regedit, and then press ENTER. In Registry Editor, locate the InstallPath registry entry in the following registry key:

 Change the value of the registry entry as follows:

C:\Progra~2\Common Files\Microsoft BizTalk Adapters for Enterprise Applications\

</li> Exit Registry Editor.</li></ol>

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section.

<div class="moreinformation_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.

Keywords: kbtshoot kbexpertiseadvanced kbprb KB943355

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.