PH24776: %{NUM} WARNING WHEN LOAD METADATA FROM DB SCHEMA WITH SYNONYMS

APAR status

• Closed as fixed if next.

Error description

• MS SQL synonym that points to a table in different schema does
  not work with Load Metadata. If the synonym points to the table
  object within the same DB schema, than the metadata can be
  imported, but if the table object resides in a separate schema,
  then metadata import doesn't work. Load Metadata seems to be
  completed successfully but with error message.
  "SUCCESS" and "Metadata Import import is complete" but also
  "%{NUM} Warning" and "The following tables can't be imported
  because they don't contain any columns: " , " "
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * See Error Description                                        *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IBM Cognos Analytics 11.2.4                       *
  ****************************************************************
  

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