Description

IBM WebSphere Business Integration Collaborations for RosettaNet PIPs on RNIF 1.1 - Patch Note

Prerequisites

• IBM WebSphere Interchange Server 4.2.*
• One of the following products:
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 2A1 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 2A12 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 3A1 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 3A2 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 3A4 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 3A5 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 3A6 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 3A7 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 3A8 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 3A9 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 3B2 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 3B3 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 3B5 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 3C1 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 3C3 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 3C4 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 3C6 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 3D8 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 4A1 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 4A3 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 4A4 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 4A5 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 4B2 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 4C1 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 5C1 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 5C2 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 5C4 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 5D1 on RNIF 1.1
  • IBM WebSphere Business Integration Collaboration for RosettaNet PIP 7B1 on RNIF 1.1

APARs Included

2.1.1.1

CR 24806/JR18819

Stored Proc problem with MS SQL Server 2000

The SqlServer_SP_retrieveState.sql stored procedure, was generating a DB error when a call is made. This happens when there are no matching rows available for the select query. Included a check condition before making the select query.

Installation Instructions

CR 24806/JR18819

To install this fix do the following:

1. The infrastructure version must be 4.2 or higher.
2. Copy the SqlServer_SP_retrieveState.sql file to %CROSSWORLDS%\collaborations\dependencies\mssqlserver directory
3. Deploy the stored procedure to the Interchange repository database on MS SQL Server 2000.
4. Restart Interchange Server