JR52472: ALLOW ORACLE CONNECTOR TO SUPPRESS ORACLE WARNING ORA-24347: WARNING OF A NULL COLUMN IN AN AGGREGATE FUNCTION.

IBM InfoSphere Information Server, Version 11.3.1.2 (Fix Pack 2)

APAR status

• Closed as program error.

Error description

• In some cases, reading from a view that is located on a
  different database, produces successful result sets, but also
  produces the SUCCESS WITH INFO message from Oracle:
  ORA-24347: Warning of a NULL column in an aggregate function.
  
  Setting this environment variable to TRUE reduces that warning
  message to a information message in the DataStage Director for
  Oracle Connector.  For example, set this in the job properties
  or project:
  CC_ORA_IGNORE_ORA_CODE_24347=TRUE
  

Local fix

Problem summary

• In some cases, reading from a view that is located on a
  different database, produces successful result sets, but also
  produces the SUCCESS WITH INFO message from Oracle:
  ORA-24347: Warning of a NULL column in an aggregate function.
  Customer only sees this issue when the table is in one schema
  and the view is in another table.
  

Problem conclusion

• Setting this environment variable to TRUE reduces that warning
  message to a information message in the DataStage Director for
  Oracle Connector. For example, set this in the job properties
  or project:
  CC_ORA_IGNORE_ORA_CODE_24347=TRUE
  

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 PSY

     UP

• R850 PSY

     UP

• R870 PSY

     UP

• R910 PSY

     UP

• R912 PSY

     UP

• RB30 PSY

     UP

• RB31 PSY

     UP