Host Integration Server does not trace 32-bit processes in a 64-bit version of a Windows operating system

This article also applies to the following product:

  • Microsoft OLE DB Provider for DB2 3.0

Symptoms

Microsoft Host Integration Server does not generate tracing files for any 32-bit processes that are running on a 64-bit version of Windows.

Note SQL Server Business Intelligence Development Studio (BIDS) is a 32-bit process. When you start a package in debug mode, BIDS generates a 32-bit process that runs the package. Therefore, the 32-bit process for a SQL Server Integration Service project may encounter this issue when BIDS is in debug mode.

Cause

This issue occurs because the SysWOW32 processes cannot read the registry values that are used by the tracing tools in Host Integration Server.

Resolution

A supported hotfix is available from Microsoft. However, this hotfix is intended to correct only the problem that is described in this article. Apply this hotfix only to systems that are experiencing the problem described in this article. This hotfix might receive additional testing. Therefore, if you are not severely affected by this problem, we recommend that you wait for the next software update that contains this hotfix.

If the hotfix is available for download, there is a "Hotfix download available" section at the top of this Knowledge Base article. If this section does not appear, contact Microsoft Customer Service and Support to obtain the hotfix.

Note If additional issues occur or if any troubleshooting is required, you might have to create a separate service request. The usual support costs will apply to additional support questions and issues that do not qualify for this specific hotfix. For a complete list of Microsoft Customer Service and Support telephone numbers or to create a separate service request, visit the following Microsoft website:

http://support.microsoft.com/contactus/?ws=supportNote The "Hotfix download available" form displays the languages for which the hotfix is available. If you do not see your language, it is because a hotfix is not available for that language.

Restart requirement

You may have to restart the computer after you install this hotfix.

More information about this hotfix package



To resolve this issue for Microsoft OLE DB Provider for DB2 3.0, follow these steps on a computer that is running Windows Vista or a later version of Windows Vista:

  1. Apply this hotfix package.

  2. For the applications that use the data provider, assign the Read, Modify, and Write permissions to the tracing directory for the administrators, user, or service accounts that run the applications.

    Note If this step is not performed, 0 KB tracing files are usually generated.

  3. Start the application of the 32-bit process by using an administrator account.

    Note If this step is not performed, no tracing files are usually generated.

Note You do not have to follow these steps if you run Microsoft Host Integration Server 2009 or Microsoft Host Integration Server 2010. In these versions of Host Integration Server, Host Integration Server runtime and the Administrator groups have the required permissions to start tracing. The OLE DB Provider for DB2 does not setup these permissions. Therefore, user accounts that start applications do not have the permissions to write the tracing logs, and additional steps are necessary to assign the permissions.

File information

The English (United States) version of this hotfix uses a Microsoft Windows Installer package to install the hotfix. The dates and the times for these files are listed in Coordinated Universal Time (UTC) in the following table. When you view the file information, the date is converted to local time. To find the difference between UTC and local time, use the Time Zone tab in the Date and Time item in Control Panel.

For all supported x86-based versions of OLE DB Provider for DB2

File name

File version

File size

Date

Time

Platform

dbgtrace.dll

8.0.4303.0

46,928

14-Oct-2010

18:40

x86

For all supported x64-based versions of OLE DB Provider for DB2

File name

File version

File size

Date

Time

Platform

dbgtrace.dll

8.0.4303.0

61,264

14-Oct-2010

18:41

x64

For all supported IA-64-based versions of OLE DB Provider for DB2

File name

File version

File size

Date

Time

Platform

dbgtrace.dll

8.0.4303.0

106,320

14-Oct-2010

18:42

IA-64

For all supported x86-based versions of Host Integration Server 2009

File name

File version

File size

Date

Time

Platform

dbgtrace.dll

8.0.3781.2

41,808

12-Oct-2010

15:13

x86

For all supported x64-based versions of Host Integration Server 2009

File name

File version

File size

Date

Time

Platform

dbgtrace.dll

8.0.3781.2

63,824

20-Oct-2010

14:55

x64

For all supported x86-based versions of Host Integration Server 2010

File name

File version

File size

Date

Time

Platform

dbgtrace.dll

8.5.4244.2

51,024

12-Oct-2010

14:51

x86

snalink.dll

8.5.4244.2

63,312

12-Oct-2010

14:51

x86

For all supported x64-based versions of Host Integration Server 2010

File name

File version

File size

Date

Time

Platform

dbgtrace.dll

8.5.4244.2

63,824

20-Oct-2010

12:09

x64

snalink.dll

8.5.4244.2

69,968

20-Oct-2010

12:09

x64

Status

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

Need more help?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.

×