APAR status
Closed as program error.
Error description
After applying connector rollup patch 2 for Information Server 8.1, Oracle connector returns the following error when configured to perform partitioned reads from a database table: "Error code: 923, Error message: ORA-00923: FROM keyword not found where expected" When partitioned reads are disabled, the connector functions correctly.
Local fix
Problem summary
**************************************************************** USERS AFFECTED: Users of Oracle Connector who are reading data from a database table with partitioned reads enabled in the connector **************************************************************** PROBLEM DESCRIPTION: When the connector is configured to read data from a database table and partitioned reads are enabled in the connector, the connector does not fetch any rows from the table but instead reports Oracle error ORA-00923 which causes the job to abort. This happens only in some cases when the table contains columns whose names as their part contain keywords that are used for the SQL SELECT statement clauses, such as WHERE, GROUP, ORDER and HAVING words. **************************************************************** RECOMMENDATION: Apply the patch for this APAR (JR34293). This change is included in 8.1 Fix Pack 1. ****************************************************************
Problem conclusion
When the connector is configured to perform partitioned reads, it modifies the SELECT statement that is used for reading data from the table by adding WHERE clause to it which results in each of the connector processing nodes fetching a subset of the table rows in parallel. The problem was that in some cases described in the problem description the connector was inserting the WHERE clause at the wrong location which resulted in invalid SELECT statement for which Oracle reported error ORA-00923. The connector was fixed to correctly locate the position in the SELECT statement at which to insert the necessary WHERE clause.
Temporary fix
Comments
APAR Information
APAR number
JR34293
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
751
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-09-16
Closed date
2009-09-27
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":"7.5.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
15 December 2009