JR48743: ORACLE CONNECTOR STAGE WITH DUPLICATE DATETIME COLUMNS FAILS WITH ERROR "CAN NOT CONVERT TO FRAMEWORK TYPE"

InfoSphere Information Server, Version 11.3 for Microsoft Windows
InfoSphere Information Server, Version 11.3 for AIX
InfoSphere Information Server, Version 11.3 for Linux
IBM InfoSphere Information Server Enterprise Edition V11.3 for Windows

APAR status

• Closed as program error.

Error description

• DataStage job with Oracle Connector Stage fails with error "Can
  not convert to framework type" when connector stage has
  duplicate datetime columns.  For example, if two tables have a
  TIMESTAMP column with the same name, and the job performs a
  SELECT * with RCP on those two tables, there will be two
  TIMESTAMP columns in the result set with the same name (but only
  one DataStage column).
  

Local fix

• It is not recommended to have SQL that produces more than one
  result with the same column name either explicitly (e.g. SELECT
  TABLE1.C1, TABLE2.C1 ... FROM TABLE1, TABLE2) or implicitly
  (e.g. SELECT * FROM TABLE1, TABLE2  where TABLE1 and TABLE2
  contain columns with the same name).
  

Problem summary

• When the SQL executed by the connector contains multiple columns
  with the same name, only the first one will generate a value on
  the link. With the Big Buffer API implementation in 9.1,
  however, these extra parameters can cause issues when the
  columns are of a datetime type.
  

Problem conclusion

• The extra datetime parameters, which were not being populated by
  Oracle, were failing conversion. Code was fixed so that these
  extra parameters are not processed.
  

Temporary fix

• Do not use duplicate columns in SQL.
  

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