APAR status
Closed as program error.
Error description
The issue involves Oracle Connector stage, or Distributed Transaction Stage configured to use Oracle Connector. The stage is configured to perform Insert then update operation on the target table, and the Array size is set to a value greater than 1. The target table contains one or more Timestamp columns with fractional seconds. The job fails with the error: The OCI function OCIDateTimeConstruct returned status -2: OCI_INVALID_HANDLE. The job works correctly if Array size is set to 1.
Local fix
N/A
Problem summary
**************************************************************** USERS AFFECTED: DataStage users with jobs that use Oracle Connector stage or Distributed Transaction Stage configured to use Oracle Connector **************************************************************** PROBLEM DESCRIPTION: The Oracle Connector stage is used to write data to the database in Insert then update write mode. One or more columns on the input link of the stage are defined as Timestamp columns with the Scale greater than 0. The Array size property in the stage is set to a value greater than 1. In some cases, the job fails with the error message reporting that the Oracle OCI method returned status OCI_INVALID_HANDLE. **************************************************************** RECOMMENDATION: Install patch JR37478. ****************************************************************
Problem conclusion
A bug in the connector was fixed which was causing incorrect handling of records that failed to be inserted to the target table due to unique constraint violation and that then had to be reused to update the corresponding existing rows in the target table.
Temporary fix
Comments
APAR Information
APAR number
JR37478
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2010-08-12
Closed date
2010-08-19
Last modified date
2010-08-19
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R810 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
19 August 2010