Cognos Analytics

Cognos Analytics

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

 View Only

  • 1.  'XQE-MSR-0023

    Posted Wed May 06, 2020 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 Wed May 06, 2020 10:55 AM
    Is it coming from FM or Data Module?
    If using Data server, check to see if table exists there.

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

    Original Message


  • 3.  RE: 'XQE-MSR-0023

    Posted Thu May 07, 2020 03:03 AM
    It is coming from data module.

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

    Original Message


  • 4.  RE: 'XQE-MSR-0023

    Posted Thu May 07, 2020 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
    ------------------------------

    Original Message


  • 5.  RE: 'XQE-MSR-0023

    Posted Fri May 08, 2020 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
    ------------------------------

    Original Message