PI63310: XQE-PLN-0011 IN UPGRADED MODEL WHEN QUERYING FROM AN ORACLE SYNONYM IF THE SCHEMA PROPERTY IS NOT SET

APAR status

• Closed as suggestion for future release.

Error description

• An FM model is created and synonyms are imported from an Oracle
  data source.  The schema property in the model data source is
  cleared to allow for portability.  When testing a query subject
  based on a synonym, an error is thrown: XQE-PLN-0011 The
  relation '<synonym>' could not be found in the model.
  

Local fix

• Enter a valid schema name in the schema property of the data
  source, or use the Compatible Query Mode.
  

Problem summary

Problem conclusion

Temporary fix

Comments

• The Product is working as designed. Please refer to
  http://www-01.ibm.com/support/docview.wss?uid=swg21960629 for
  ambiguous metadata issues in DQM.
  
  How to resolve this ambiguity:
   Qualify a value for the Catalog and Schema properties on the
  data source in the package
   Review if the data source errantly has two or more tables or
  views with the same names and rename or delete the duplicate
  objects as applicable
   Review if the data source errantly granted select privileges
  to two or more tables or views with the same names and remove
  those grants as applicable
  

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