IBM Support

WebSphere Adapters V7.5.0.X fix list for IBM Integration Designer V8.x

Product Documentation


Abstract

WebSphere Adapters provide periodic fixes for editions of release version 7.5. The following is a listing of those fixes along with the corresponding IBM Integration Designer versions with which they are packaged.

Content


The following list describes the adapter versions and the fixes for that version packaged with IBM Integration Designer V8.0.1.1 and IBM Integration Designer V8.5

AdapterAPARDescription
AFC V7.5.0.5
SAP node and JMS node in same EG, will result in JMS node getting SAP node's initial context. Need to pass initial context
ECM V7.5.0.5
The ECM adapter now supports IBM CM8 in addition to IBM FileNet P8 for the outbound functionality.

Support for Zipping of Documents in ECM adapter

Support for PDF securing using password
FTP V7.5.0.5
Support uppercase ftp commands for ExecuteFTPScript Outbound operation.

Support file name based retrieve for FTP Adapter Outbound.
IBMi V7.5.0.5JR44902SetFailedException found in processing the outbound response BO, when the top level BO has array of structures as an element which internally contains array of structures as an element.
SAP V7.5.0.5JR45095The QISS interface was failing if the where clause had empty conditions in the middle of a query. This has been fixed
JR43875During SAP adapter outbound, event persistence with JNDI alone doesn't work. This has been fixed
JR43182SAP Adapter artifacts generated on v6.2.x Adapter BAPI interface fails to run as is on V7.5.0.0 Adapter on RAD/WAS8. This has been fixed
JR43846Not able to modify JCo max connections value through JVM property.This has been fixed
JR45581SAP Adapter (input node, idoc processing)7.5, WMB V8001 - workrejected exception if flow is restarted. This has been fixed

To download IBM Integration Designer V8.0.1 Fix Pack 1 for Windows, follow this link:
http://www.ibm.com/support/docview.wss?uid=swg24034460

To download IBM Integration Designer V8.5 for Windows, follow this link:
http://www.ibm.com/support/docview.wss?uid=swg24034320

The following list describes the adapter versions and the fixes for that version packaged with IBM Integration Designer V8.0.1

AdapterAPARDescription
AFC V7.5.0.3
Introduced option to add and remove namespance and type from response xml in case of Cast Iron.

ALEInbound does not work when PI is enabled. This is an issue with the package name generated in RAD when the namespace is URN. This has been fixed.

When regenerating the Business Object classes using an XSD schema file from SAP or PeopleSoft Adapters, an incorrect package name is returned when the targetNamespace does not start with www. This has been fixed.

Added support for enum types for xsd attributes.

Processing methods for illegal XML characters section is seen in WMB in the generated .adapter file. Illegal XML characters property group is meant for WPS only. This has been fixed.
Flat File V7.5.0.3JR43571Performance degradation is observed when the Adapter processes large number of records. This has been fixed.
JDBC V7.5.0.3JR43535StoredFunction for Custom Query in adapter inbound fails with SQL Exception. This has been fixed.
JR43239Inconsistency in standard and custom event table while using custom event query. This has been fixed.
JDE V7.5.0.3JR43298Property name for the table in selection properties screen is translated. The translation has been disabled.
Lotus Domino V7.5.0.3
Added currency support for Lotus Domino Server V8.5.3.
JR43256RetrieveAll operation not working for datetime data type when the value has only time in it or both date and time. This has been fixed.
JR43330Exception 'Class cast exception' occurred while using mail/system.nsf and _Calendar Entry FORM. This has been fixed.
JR42492Date, Time and DateTime data types are wrongly mapped to the Date data type by default resulting in Time and DateTime fields data being corrupted. This has been fixed by providing an option to change the mapping to String during object discovery.
OracleEBS V7.5.0.3
EMD fails when selecting multiple Stored Procedures using Oracle EBS Adapter on Rational Application Developer. This has been fixed.
PeopleSoft V7.5.0.3_IF01
Thread safe implementation of PeopleSoft Adapter for Cast Iron.

While creating Web Page, Web Services or EJB from J2C Java™ Bean for the PeopleSoft Adapter a NullPointerException is encountered on attempting to complete the wizard. This has been fixed.
SAP V7.5.0.3_IF01
Added support for generating schema in SAP PI standards for BAPI inbound.

Send idoc problem (adapter looking for data in the XML even if schema element it is minOccurs=0). This has been fixed.

Send Idoc error while sending ALEAUD01. This has been fixed.
JR42301Segment names in the idoc has randon number appended to it. This has been addressed.

ALEPT Inbound Idoc Data Stream for Packet Idoc does not have complete data. This has been fixed.

With the bapi Bank.Change, user is not able to change the bank details of existing bank. This has been fixed.

ALE Inbound with PI enabled for Extended IDocs throws Exception. This has been fixed.

ALE Inbound with Extension IDoc does not work in RAD/WAS. This has been fixed.

RetrieveAll for QISS table returns all records irrespective of whether child field column value is given or not. This has been fixed.
JR42632When ALE QRFC with audit update is enabled, status code of AUDIT (ALEAUD) idoc on SAP is 75 instead on 64. This has been fixed.
JR42645JCO Resource error when applications have transactionality set to yes as well as no. This has been fixed.
JR42462ALEPT Inbound idoc data stream for packet idoc does not have complete data. This has been fixed.
JR43029When a Sync BAPI is discovered as Async in EMD, it fails during runtime saying TID is null. This has been fixed.

BAPI Inbound with BOR for SAP Naming Convension (PI) fails. This has been fixed.

Iterative Discovery (for PI enabled application) on adding RFC to an existing BOR BAPI module fails. This has been fixed.

PI with BAPI BOR fails at the discovery EMD step and gives a NullPointerException. This has been fixed.

SAP RFC Inbound functionality gives malformed XML whilst running in asynchronous mode. This has been fixed.

ALE Outbound with SAP Naming Convention Failed to delivery the Idoc if we have more than one IDOC configured in a sinlge module. This has been fixed.
JR42189Time datatype of SAP not working properly in CastIron for SAP connector. This has been fixed.
JR42125With DateAsString set, exception is thrown when accessing uninitialised date. This has been fixed.
JR41974CastIron: Item not present in the schema for table type parameter. This has been fixed.
JR42187JCo Repository cache needs to be cleared when EMD is closed. This has been fixed.

CastIron: attributes type in generated schemas of the idoc should be xsd:string but it is anySimpleType. This has been fixed.

Default value should be populated for attributes in the generated schemas for idocs. This has been fixed.
JR42351Old projects using extended idoc does not work for send idoc activity. This has been fixed.

BAPI (BOR) inbound fails if PI is enabled on WAS expecting the BO name to contain dot instead of underscore. This has been fixed.
Siebel V7.5.0.3JR43200Show error on empty result set should be unchecked by default for Business Service but its coming as checked. Also this property should be visible in property tab post EMD completion. This has been fixed.
JR43205In certain cases adapter throws codepage related exception even though the codepage value is correct. This has been fixed.

Enable Inbound Event Monitor not available on Siebel 7.5.0.3. The option has now been added.
IBMi V7.5.0.3JR41731Sample CL program needs to be changed and compiled for different IBM i server date formats. This has been supported.
JR43208IBM i Adapter not polling the events from staging queue if adapter is restarted at 00:00 hours. This has been fixed.

In some recovery(abruptly shutdown) cases, there is inconsistency between staging queue and event table. It may cause duplicate events deliver to end point in recovery. This has been fixed.

To download IBM Integration Designer V8.0 Fix Pack 1 for Windows, follow this link:
http://www.ibm.com/support/docview.wss?uid=swg24033085

The following list describes the adapter versions and the fixes for that version packaged with IBM Integration Designer V8.0

AdapterAPARDescription
Email V7.5.0.2
No updates
Flat File V7.5.0.2
FlatFile Adapter retrieves only one event file at a time 'NO SORT' is selected and Delivery Type is UNORDERED. This has been fixed.

When FlatFile Adapter reads a binary file in binary mode and then writes the file again to the file system (in binary mode) the data is corrupted. This has been fixed.

When splitCriteria is disabled, FlatFile adapter throws NumberFormatException. This has been fixed.

When filename contains invalid characters during Outbound operation, FlatFile adapter throws FileNotFoundException instead of throwing Invalid Property Exception. This has been fixed.

When FlatFile Adapter is configured and run with Outbound Create operation with invalid characters in Sequence filename, it throws an 'error occurred while accessing file' instead of throwing Invalid Property error message. This has been fixed.
FTP V7.5.0.2
Added support for Commons net 3.0.1.

Streamlined adapter tracing with the right trace volume assigned to the right trace levels. Introduced more intelligent tracing with an understanding of frequenctly faced customer problems.

For FTP Adapter, tool tips for all the properties in EMD flow has been revisited and wherever required, changes have been made to enhance the readability.

An additional file size check was introduced along with time interval for file unchanged time interval property. So as per change: If 1 GB files takes 10 mins to be copied to the event directory and the UnchangedTimeinterval is 7 mins, the adapter will pick up the file only if the file has not been changed for 7 mins.

For the following outbound scenarios: 1. Create operation for LocalArchiveDirFor , 2. Retrieve operation for LocalDirectoryPath and 3. Create operation with FileSequenceLog , When all the permission are denied for the directory ,the execution flow was not stopping at directory level check and was going further to check for the File. This has been fixed.

For the following outbound scenarios : 1. When local archive directory is given wrong , 2. When local event directory is given wrong , 3. When Denying all permissions to local archive directory and 4. When Denying all persmissions to local archive directory , The exceptions were thrown more than once. A fix has been provided for this to make trace more readable and proper to customers.

Recovery was not happening properly for the events having EventID 0 and XID non null. This situation occurs whenever wps is restarted after a unexpected wps process kill. An adapter level as well as an AFC and Websphere app server level fix provided for it.

Adapter failed to stop at the deployment time when FTP event or archive or local event or archive directory is given wrong. This has been fixed.

During the first poll cycle ,download process was showing the unexpected behavior. FTP adapter was unable to download the partial file (caused due to unexpected loss of connectivity) first, upon reconnection. This has been fixed.
JDBC V7.5.0.2
Added support for database schema name change at runtime without regenerating the artifacts. This feature is supported for DB2 and ORacle databases. A new property named TableNameEnv is added in the Business Object to support this.
OracleEBS V7.5.0.2
IBM WebSphere Adapter for Oracle EBS discovers boolean variables in a Record Type as decimal when accessed through different schema. This has been fixed.

When retrieving events for event status 0, adapter queries the event table for all records whose event status is 0 irrespective of value of the xid. This situation occurs whenever wps is restarted after a unexpected wps process kill. This has been fixed.

The SQL Script file ibm_websphere_event_table_create.sql shipped with Oracle EBS Adapter has been updated to increase the XID column length from 100 to 200. By default in Oracle EBS, the XID is 132 characters in length. But, this script creates XID column with size 100. Due to this during inbound, delivering an event will fail because adapter cannot update the XID value as Oracle returns length error.

Datasource name is not shown in properties view after configuring inbound service. This has been fixed.
PeopleSoft V7.5.0.2
The ASI 'KeepRelations' is not getting saved for the element which is of type child business object at top level business object after selecting from the advanced property. This has been fixed.

The ASI 'UID' is not getting saved for the element which is selected at the advanced configuraiton screen. This has been fixed.

The user is given an option to select 'Prompt for additional configuration settings when adding business object' which is not needed. The option has been removed.

A 'java.lang.NullPointerException' is thrown while moving the metadata object from left to right panel on the metadata tree panel. This has been fixed.

The ASIs related to effective date configuration are not getting saved at the top level and child business objects. This has been fixed.

Currently, keep relationship flag can only be set for the child business objects and not for grand child business objects. This has been fixed.

The list of 'Alternate key fields for RetrieveAll operation' during metadata configuration of Outbound process should display only FindKeys for component interface and not all the fields. This has been fixed.

The list of 'Fields that represent the generated key in PeopleSoft' property duing metadata configuration for outbound process should display only primary key fields. This has been fixed.
SAP V7.5.0.2
Support has been added for Password-less authentication (SSO / X509) using SAP adapter.

"The option "Send IDoc with Unparsed Data Record" option should be disabled when the "Use SAP Field Names" option is enabled in the "Configuration Properties" panel". This has been fixed.

For ALE, Invalid IDoc version does not throw an error, when IDocs are discovered by file. This has been fixed.

During trfc Inbound calls, the events are duplicated or lost. This has been fixed.
JR40936Data cross over happens when global variables are used in ABAP program. This has been fixed.
JR41367The output schema generated by the Adapter while working with PI style artifacts had a nested structure if one of the table parameter is not specified. This is encountered while working with Cast Iron. This has been fixed.
JR41368Table types in Import and Export parameters should contain an item field during PI standard artifact generation. This has been fixed.

ALE PassThrough with generic idoc fails with the following error "Business object definition for the BO in namespace not found". This has been fixed.

Advanced Configuration Properties does not contain explanation for the individual fields. This has been fixed.

During EMD create Outbound -> ALE -> Orders05/Alereq01 -> Fails with Null Pointer Exception. This has been fixed.

On using language as one of the dynamic parameter for testing it is observed that a new connection is not made in SAP for new language. This has been fixed.

SNC token not getting printed in the traces when the logging is set to finest. This has been fixed.

Optional Parameter information is not synchronized when we do iterative discovery for BAPI. This has been fixed.
JR41324In case of wrong credential it's not showing proper error message but generating FFDC on RAD/WAS. This has been fixed.
JR41974The variables in import and export parameters which contain nested table type parameter is not generated correctly during PI generation. The item element is not generated in the schema. This has been fixed.
JR42125An exception is thrown when serializing a BAPI response containing an uninitialised date field, if the schemas are generated with date field as a string parameter. This problem is now fixed to read the value from the BAPI table only for initialized fields.
Siebel V7.5.0.2
Connection retry was happening for inbound scenario in case of incorrect user or password. This has been fixed.

When retrieving events for event status 0, adapter queries the event table for all records whose event status is 0 irrespective of value of the xid. This situation occurs whenever wps is restarted after a unexpected wps process kill. This has been fixed.
JR42249Siebel inbound scenario fails if number of records exceed 10,000 in event table. This has been fixed.
Lotus Domino V7.5.0.2
When retrieving events for event status 0, adapter queries the event table for all records whose event status is 0 irrespective of value of the xid. This situation occurs whenever wps is restarted after a unexpected wps process kill. This has been fixed.
JDE V7.5.0.2
When UNORDERED delivery is selected, minimum and maximum properties under "Number of connections for event deilivery" are not seen in EMD screen. This has been fixed.

User name and password fields are empty in "deployment properties screen" for outbound scenario. The values entered in discovery properties screen are not carried to deployment properties screen. This has been fixed.

JDE Adapter fails to validate the timeout property properly in deployment properties screen. A positive long value higher than MAX_INT can get cast to a negative integer and result in execptions at runtime. This has been fixed.

When JDE adapter receives an event which is not configured through EMD, it throws a NullPointerException since the BO definition for that event could not be found. This has been fixed by updating the adapter to throw ResourceException when BO definition could not be found.

NullPointerException seen in .log after discovery with XMLLists. This has been fixed.

If the server is terminated while event processing is in progress, any entries with status 1 are left undeleted from the event table. When event processing resumes after server is restarted, the event entries remain in the event table. This has been fixed.

When an instance of JDEInboundHandlerWithXid is created, a failure to create a sync event session can result in connection to JDE server not being logged off. The connection is logged off only when close() is called on the instance. But then an exception thrown by the constructor leaves no chance to call close() thus leading to connection leaks. This has been fixed.
IBMi V7.5.0.2
Upgradation of the third party API(JTOpen) of IBM i adapter to 7.5.1.

IBM i Adapter Certification on IBM i/iSeries V7R1 System.

In Event Delivery properties, Event Type is enabled. This needs to be disabled as it's not applicable for IBMi. This has been fixed.

In some recovery (abruptly shutdown) cases, there is inconsistency between staging queue and event table which can lead to duplicate events being delivered to end point during recovery. This has been fixed.

During discovery, if space is provided for the "folder" field in the Composite Properties screen, adapter is not generating the XSD's and not providing the reason for failure. Now, the adapter displays the error with reason for failure.
ECM V7.5.0.2
No updates.
AFC V7.5.0.2
Connection Leak during XARecovery. AFC recovery implementation modified to handle the connection leak issue.

Adapter was returning both in-doubt and new events to AFC while executing the getEvents API. This has been fixed.

NullPointerExceptions seen in the logs during Inbound processing of events during Commit and Rollback calls when event is null. This has been fixed. With the fix when an event for a requested Xid is not found in the EventStore, an XA exception will be thrown, which will be sent to the container. Depending on the error code set on the XAException based on one phase or two phase commit, the container will send an appropriate call. Example in case of two phase commit the container will reissue a commit call.

Format check for pending xids from adapter was failing, because of which recovery of pending transactions was not taking place. This has been fixed.

Events that have been rolled back during recovery are not picked up for future processing. This has been fixed.

Use of String in CheckIllegalXMLCharacter leads to creation of large number of String objects as String is immutable, heap profiling showed increasing number of String objects that are not getting cleaned up, this has a potential to cause a problem when the input size is large. This has been fixed by replacing String with StringBuffer.

When the retry connection limit is set to a value greater than 0, the connection is checked for validity, If valid, the connection is returned, else null signalling container to create a new connection. This whole process has to be repeated until a valid connection is found in the given candidate connection set before returning null. However, this stops at the first matching connection in the given set of candidate connections by the container. This has been fixed. With the fix when the "retry connection limit" is > 0, you will have the AFC component iterate through all matched managed connections and return one which is valid. If none is found to be valid it would return null.
JR42534WorkRejectedException is seen in logs, followed by adapter stopping to poll. This has been fixed. Work that was rejected was not getting removed from the workInPorgress list which was resulting in no new work to be added for submission, as a result of which adapter could not poll once a poll work was rejected.

The Adapter throws NullPointerException when updating the event persistence table with XID as null on the rollback() method of the XAResource. This has been fixed.

Adapter throws ArrayIndexOutOfBoundException during recovery, if the event being recovered does not exist in the event persistence table. This has been fixed.

While running in a local transaction in a non-auto commit mode, the adapter attempts to close the SQL connection if the SQL operations fails. This results in a DataStoreAdapterException due to attempt to closing a connection which is in transaction. The issue has been fixed so that rollback is called on the failed transaction before closing the transaction.

Adapters require to query all the events in the event persistence table. Currently there is no helper method in foundation classes to retrieve all the events. A method getAllEvents() is provided to retrieve all the events from the event persistence table.

FileNotFound issue when file URL points to file within a jar. Problem was occurring because the AFC code assumed that the URL will also point to a file, support for other protocols was not provided. This is corrected to enable support for all protocols in URL.

To download IBM Integration Designer V8.0 for Windows, follow this link:
http://www.ibm.com/support/docview.wss?uid=swg24031894

[{"Product":{"code":"SSMKUK","label":"WebSphere Adapters Family"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Adapter \u2013 Non-specific","Platform":[{"code":"PF002","label":"AIX"},{"code":"PF012","label":"IBM i"},{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF033","label":"Windows"},{"code":"PF035","label":"z\/OS"}],"Version":"7.5","Edition":"","Line of Business":{"code":"","label":""}},{"Product":{"code":"SSTLXK","label":"IBM Integration Designer"},"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Component":"Not Applicable","Platform":[{"code":"PF033","label":"Windows"},{"code":"PF016","label":"Linux"}],"Version":"8.5;8.0.1.1;8.0.1;8.0","Edition":"","Line of Business":{"code":"LOB45","label":"Automation"}}]

Document Information

Modified date:
17 June 2018

UID

swg27024944