JR34293: ORACLE CONNECTOR ERROR ORA-00923 RETURNED WHEN PERFORMING PARTITIONED READS

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 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