Release Notes for Version 2.4.0 of the IBM WebSphere Business Integration Adapter for i2 Active Data Warehouse

These release notes cover release information for version 2.4.0 of the IBM(R) WebSphere(R) Business Integration Adapter for i2 Active Data Warehouse. They contain the following sections:

New in this release WebSphere Business Integration Adapters API and run time
Product fix history Known problems and workarounds
Hardware and software requirements Documentation
Installation, migration, upgrade, configuration

Note: Important information about this product may be available in Technical Support Flashes issued after these release notes were published. These can be found on the WebSphere Business Integration support Web site, http://www.ibm.com/websphere/integration/wbiserver/support. Select the component area of interest and search the flashes section.

New in this release

This section lists the new features and improvements made in this release.

Refer to the Adapter for i2 Active Data Warehouse User Guide for detailed information about the adapter and the new features.

Product fix history

Between release 2.3.0 and 2.4.0, the following CRs, based on customer-reported cases, were fixed.

Tracking
number
Description
13779 A new verb, DeltaUpdate, is supported on the adapter. If this verb is specified on the parent, users can specify individual verbs on the children .The adapter will do operations on each child based on the verb set on that child.Fixed in 2.3.4.
22193 In previous versions, when attempting a delete operation, if the business object was not found, a message was logged to that effect in the log file. This behavior has been modified to return a failure notification if the business object does not exist in the database. The business object is sent to the Fault Queue. Fixed in 2.3.2.
22924 To support Trusted authentication, userID and password are no longer mandatory properties.
23142 Insert and update operations of clob data larger than 4k is now supported, but only with Oracle.Fixed in 2.4.0.
25034 Previously, if the connector received a return status as CONNECTOR_NOT_ACTIVE on gotApplEvent call, the adapter would archive the event with a status 0. In this release, the adapter does not archive events with a status of 0 but instead retains them in the event table so that they are processed when the adapter is restarted. Fixed in 2.3.1.
25163 The DB400 database does not support variable length strings, so ObjectName and ObjectVerb fields retrieved from the event table needed to be trimmed to remove the extra spaces before the events could be processed. Fixed in 2.3.3.
26156 When retrieving child business objects using stored procedure, in certain cases, the result set was closed before the data was retrieved, indicating that the result set handle was invalid when an attempt was made to retrieve the data from the result set. Fixed in 2.3.3.
26296 The code used to generate the printable query for tracing referred to key values, and since only foreign keys were present it returned errors. Fixed in 2.3.2.
26551 In adapter patch 2.2.8, you had the option of using output parameters to populate attributes in an N-cardinality business object. In adapter version 2.3.0, returning a result set as an output parameter was introduced. There was a conflict in handling both the options simultaneously in adapter patch 2.3.1. Fixed in 2.3.2.
26870 When UseDefaultsForRetrieve was set to true, the default values were not being set on the business object for the verb RetrieveByContent. Fixed in 2.3.3.
28415 The start scripts supported launching of JAR files beginning with CW only. They have been modified to launch jar files beginning with BIA_ as well. Fixed in 2.3.3.
28620 The ASI retriever called the get attribute name instead of GetAttributeType() and this caused an error if the object attribute name and its type had different names for a single cardinality child. Fixed in 2.3.3.
29539 On delete and retrieve operations, if one of keys is CxIgnore it will be ignored and not considered for the where clause.Fixed in 2.3.4.

Hardware and software requirements

Hardware and software requirements are included in the product documentation. See Installation, migration, upgrade, and configuration information for links to those guides.

Installation, migration, upgrade, and configuration

Whether you are installing the software from the CD or downloading it from Passport Advantage and installing it from a local directory, refer to the appropriate guide for your Integration broker:

These guides also include general migration, upgrade, and configuration information.

For hardware and software requirements and configuration information specific to this adapter, refer to the Adapter for i2 Active Data Warehouse User Guide.

Upgrade notes

WebSphere Business Integration Adapters API and run time

Make sure that you run this version of the adapter with WebSphere Business Integration Adapters run-time version 1.6.0 or later.

The WebSphere Business Integration API .jar files and the associated scripts (CWConnEnv.bat and CWODAEnv.bat for Windows(R); CWConnEnv.sh and CWODAEnv.sh for UNIX platforms) are installed by the WebSphere Business Integration Adapters API. Before installing the adapter, make sure that the WebSphere Business Integration Adapters run time is installed. If the version is not 1.6.0 or later, you must download the latest API. This section provides instructions for verifying the API version, downloading the latest version, and enabling the adapter to run on various versions of WebSphere InterChange Server and Adapter Development Kit (ADK).

Verifying the run-time version

To check the run-time version, locate the manifest file (ProductDir\lib\WBIA.jar) and open it in a suitable Java JAR editor. Look for the following lines:

Implementation-Title: "CWConnectorAPI"
Implementation-Version: 1.6.0

Implementation-version indicates the installed version of the API. If the version is not 1.6.0 or later, you must download the latest run time.

Downloading the run time

To download the latest version of the run time:

  1. Go to http://www.ibm.com.
  2. Click the Support & downloads tab.
  3. Under the Downloads heading, click Downloads & drivers.
  4. In the Enter search terms field, type "wbia api" and click Submit.

After you download and install the run time, you should see the following files:

lib\WBIA.jar
lib\WBIA\3.0.0\WBIA.jar
lib\WBIA\4.0.0\WBIA.jar
lib\WBIA\4.1.1\WBIA.jar
lib\WBIA\4.2.0\WBIA.jar
bin\CWConnEnv.bat (Windows)
bin/CWConnEnv.sh (UNIX)
bin\CWODAEnv.bat (Windows)
bin/CWODAEnv.sh (UNIX)
connectors\messages\CwConnectorAgentMessages.txt

Enabling adapters for earlier versions of Adapter Development Kit and WebSphere InterChange Server

To enable an adapter to work with various versions of ADK or WebSphere InterChange Server, follow the appropriate procedure below:

InterChange Server versions 4.1.x (except 4.1.0), ADK versions 2.1.x
InterChange Server versions 4.2.0 and 4.2.1, ADK versions 2.3.0 and 2.3.1
Running an Object Discovery Agent (ODA) against InterChange Server versions 4.1.x (except 4.1.0) and ADK versions 2.1.x
Running an Object Discovery Agent (ODA) against InterChange Server versions 4.2.0 and 4.2.1, ADK versions 2.3.x

Known problems and workarounds

The following problems have been found in this release:

Tracking
number
Description
30523 When processing a RetrieveSP, if one of the input parameters has a value of CxIgnore, the adapter does not set the values on the remaining input parameters, so the stored procedure is called with null values on the remaining input parameters.
31301 When using resultset as an output parameter (for the Oracle database), the error "Attribute RS not found" is returned.
31633 In a UNIX environment, a connector_manager_adapter script is generated by the installer program. The script references adapterEnv.sh, which was introduced with version 2.4.0 of Adapter Framework. If you are running an older version of Adapter Framework, adapterEnv is not available. To run this version of the adapter with a pre-2.4.0 version of the framework, change the reference from adapterEnv.sh to CWSharedEnv.sh in the connector_manager_adapter script.

Documentation

Product documentation is not included as part of the product package, either by CD or by electronic product distribution. The documentation for this product can be found in the following InfoCenters:

To obtain the product documentation, visit the Web site and download the current documentation set for the release that you are using. Follow the instructions provided on the InfoCenter page to complete the installation.

Copyright IBM Corp. 1997, 2003