PI06944: INTERMITTENT ORA-01466 WHEN RUNNING AN SQLDATA FUNCTION WITHIN AN SQLFETCH LOOP

APAR status

• Closed as program error.

Error description

• When running a jobstream which contains a condition node which
  calls a function which runs an SQLData function within an
  SQLFetch loop, once out of every four executions, it will fail
  with...??DM-DBM-0400 UDA driver reported the following on
  connection name:??UDA-SQL-0107 A general exception has occurred
  during the operation "open result".??ORA-01466: unable to read
  data - table definition has changed
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2.1 Fix Pack  *
  * 3                                                            *
  ****************************************************************
  

Problem conclusion

• Code Fix
  

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

  COG DATA MGR

• Fixed component ID

  5724W12DM

Applicable component levels