PM73749: DYNAMIC QUERY MODE UNABLE TO FIND TABLE WHEN PUBLISHING A PACKAG E CONTAINING TWO SCHEMAS ON A MICROSOFT SQL SERVER DATABASE.

APAR status

• Closed as program error.

Error description

• Dynamic Query Mode is not able to find a table when publishing a
  package that contains two schemas on a Microsoft SQL Server
  database. Get Error message:??BMT-MD-5002 The object 'DIM_TIME'
  of type 'table or view' does not exist in the data source. Call
  stack:?BmtActionsHelper.cpp(500): BmtEngine: CCL_RETHROW:
  BmtActionsHelper::DoAction BmtMDQueryItemSynchronizer.cpp(858):
  BmtEngine: CCL_THROW:
  BmtMDQueryItemSynchronizer::buildExternalQItems??
  

Local fix

Problem summary

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

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 FRAMEWRK MG

• Fixed component ID

  5724W12FM

Applicable component levels

• RA11 PSN

     UP