JR55212: Modulus Partitioned Read broken when table alias not specified in 'Table name for partitioned reads'

IBM InfoSphere Information Server, Version 11.5.0.1 (Fix Pack 1)

APAR status

• Closed as program error.

Error description

• Message Id: IIS-CONN-ORA-01003
  
     Message: DB_In_PRTY_NM,0: The OCI function OCIStmtExecute
  returned
     status -1. Error code: 904, Error message: ORA-00904:
  "T1"."PRTY_ID":
     invalid identifier. (CC_OraStatement::executeSelect, file
  
     CC_OraStatement.cpp, line 3,900)
  

Local fix

• The property "Table name for partitioned reads" set to
  SORITMOD.PRTY_IDNTFN.
  The work around is to add the alias to the table name.  For
  example...
  "Table name for partitioned reads" = SORITMOD.PRTY_IDNTFN
  PRTY_IDNTFN
  

Problem summary

• A job's complicated SELECT statement using modulus read
  partitioning strategy doesn't work unless the table's ALIAS is
  specified in the TableNameForPartionedRead property. In
  addition, a SELECT statement may have mutiple tables, where a
  later table's ALIAS is the one needed, but the method
  determineTableNameFromStatement() always returns the first TABLE
   and ALIAS.
  

Problem conclusion

• A new method called
  CC_OraUtils::determineAliasNameFromStatement() was developed. In
   the constructor of CC_OraPartitionedReadsHelper(), call the new
   method to find the ALIAS instead of calling the method
  determineTableNameFromStatement().
  

Temporary fix

• Specify the table's ALIAS in the Oracle Connector stage editor
  in the property 'Table name for partitioned reads'.
  

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

• R910 PSY

     UP

• R912 PSY

     UP

• RB30 PSY

     UP

• RB31 PSY

     UP

• RB50 PSY

     UP