Note The same issue may be seen if you use Unconfigure Feature on the Data Integration Feature.
When you configure the distributed transaction, you have to specify an instance of SQL Server. A SQL Server database named MSHIS_DATA will be created on the configured instance of SQL Server to hold the following tables:
When you now try to upgrade Host Integration Server 2009 to Host Integration Server 2010, the Setup program uninstalls Host Integration Server 2009 as part of the upgrade process. This causes the DUWTCPLog and DUWTCPReferences tables that were created in the MSHIS_DATA database to be dropped. After the tables are dropped, other distributed transactions that are running on different instances of Host Integration Server in the multiserver environment no longer work correctly. This occurs because the other distributed transactions are supposed to use the SQL Server tables that were dropped.
- Open Windows Explorer, and then locate the Microsoft Host Integration Server\System folder.
- Open the DuwTcpCleanup.sql file.
- Locate line 11, where you see the following statements:
DELETE FROM "DUWTCPReferences" WHERE NAME = HOST_NAME()
IF EXISTS (SELECT COUNT(*) FROM "DUWTCPReferences")
- Change the second line to the following:
IF NOT EXISTS (SELECT * FROM "DUWTCPReferences")
Article ID: 2592837 - Last Review: Sep 20, 2011 - Revision: 1