PM43387: UDA-SQL-0328 ERROR WHILE VALIDATING ON DATE ITEMS IN C10.1 FRAMEWORK MANAGER

APAR status

• Closed with unknown close code.

Error description

• Client received UDA-SQL-0328 Unable to find the column ?column
  name? error message while validating on certain data items in
  C10.1 Framework Manager. The certain column does exist in the
  database. ????The data items are from two query subjects which
  have full outer join relationship. Session parameter applied in
  the Cognos SQL to reach the data security aim. If we publish the
  related query subjects to Cognos connection and create a report
  in Report studio, the report failed on validation but could be
  executed and returned the correct result. ??
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See error description.                                       *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Business Intelligence 10.2 Refresh     *
  * Pack 1                                                       *
  ****************************************************************
  

Problem conclusion

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

Applicable component levels

• RA21 PSN

     UP