PI99739: AMBIGUOUS CONNECTION ERROR IN FRAMEWORK MANAGER

APAR status

• Closed as fixed if next.

Error description

• Import or update of metadata fails in Framework Manager, because
  schema user or command blocks are ignored.
  This happens when:
  - the schema information is not present in the FM datasource
  connection
  - the table name exists in more than one schema on the database
  - datasource connection is limited to one schema by either using
  a command session block with set current schema command or a
  schema user is used to connect to the datasource
  - definition of query item does not match select * from
  [datasource].table
  
  Error: XQE-PLN-0011 The relation '<table>' could not be found in
  the model. Reason: 'MFW-UT-1103 Details: "Ambiguous SQL query!
  The query has matched multiple objects ...."'
  
  Example of failing query items:
  - select *from [datasource].table
  - select column from [datasource].table
  
  Reproducible in Cognos Analytics 11.0.11 against any DB2 version
  in Dynamic Query Mode. Same is working fine in CQM.
  

Local fix

Problem summary

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

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