Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  'XQE-MSR-0023

    Posted 05/06/20 05:41 AM
    Hi All,
    We have just migrated our cognos to new server and when I am running one report I am getting following error.
    The relation 'VB_DAILY_CALL_CNTR_METRICS' could not be found in the model. Reason: 'XQE-MSR-0023 'VB_DAILY_CALL_CNTR_METRICS' needs to be in the imported schema 'DDSUSER' in the connection 'DDS' in the data source 'DDS'.'
    Can anyone help me in resolving this.


    ------------------------------
    Priyanka Joshi
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: 'XQE-MSR-0023

    Posted 05/06/20 10:55 AM
    Is it coming from FM or Data Module?
    If using Data server, check to see if table exists there.

    ------------------------------
    Buddhi Gupta
    ------------------------------



  • 3.  RE: 'XQE-MSR-0023

    Posted 05/07/20 03:03 AM
    It is coming from data module.

    ------------------------------
    Priyanka Joshi
    ------------------------------



  • 4.  RE: 'XQE-MSR-0023

    Posted 05/07/20 11:51 AM
    You can try
    • Open Data Module spec using ctrl / q (within data module)
    • search for "null" reference and
    • Replace with missing table name.


    ------------------------------
    Buddhi Gupta
    ------------------------------



  • 5.  RE: 'XQE-MSR-0023

    Posted 05/08/20 01:51 AM
    Hi,
    Thanks.Actually error was coming because report was referring to data module which was in my content .Data module is not migrated from old server.Now we migrated data module from old server and error is resolved.

    ------------------------------
    Priyanka Joshi
    ------------------------------