APAR status
Closed as program error.
Error description
The user has configured Oracle Connector stage to read data from a table that contains columns of LONG data type. The number of records in the source table is smaller than the Array size property value of 2000. The job fails with the Oracle native error ORA-01003.
Local fix
Set Array size property value to 1.
Problem summary
**************************************************************** USERS AFFECTED: Users of Oracle Connector who are extracting data from Oracle tables that contain LONG and LONG RAW columns. **************************************************************** PROBLEM DESCRIPTION: The connector would return error in cases when the total number of rows that it fetched from the source table was smaller than the value specified for the array size to use for array reads. The connector was not properly distinguishing between the total size of the array and the count of records that were actually fetched from the table. This was happening in cases when the connector was reading from a table that contained columns of LONG or LONG RAW data types. **************************************************************** RECOMMENDATION: Install Connector Rollup Patch 2 (CCRP2). This change is included in 8.1 Fix Pack 1. ****************************************************************
Problem conclusion
The connector was fixed to correctly determine the number of rows that were fetched in the initial array from the table with LONG and LONG RAW columns and to handle the situation in which that number was smaller than the array size.
Temporary fix
Comments
APAR Information
APAR number
JR34045
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
810
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-08-18
Closed date
2009-09-28
Last modified date
2009-12-15
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:
15 December 2009