Cognos Analytics

 View Only
  • 1.  Refresh metadata fails

    Posted Mon April 01, 2019 05:53 PM
    A user with the user role Analytics Explorer has created a datamodule with a data server source in CA11.0.13.1

    Now the database model has changed and he wants to refresh the meta data but this proces fails with an error message.

    At this moment only the Cognos Administrator with the user role Analytics Administrator can succesfully load the meta data again.

    I have checked all the rights for the concerning capabilities but I have no clue why this proces fails?????

    ------------------------------
    Bastiaan Krijgsman
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Refresh metadata fails

    Posted Tue April 02, 2019 09:24 AM
    What is the error message?  What error logs were produced?

    This might be too much to diagnose in a forum post, you may be better off opening a support case.

    ------------------------------
    Rob Hatfield
    ------------------------------



  • 3.  RE: Refresh metadata fails

    Posted Fri April 05, 2019 07:30 AM
    Below the error message. The log file only shows the folllowing:

    172.28.91.181:9300 4300 2019-04-05 13:13:29.631 +2 21809 XQE 0 4 Audit.RTUsage.qs.XQE.QueryService Response Queryservice heeft een antwoord geretourneerd voor het verzoek "configure" van rapport "unknown".172.28.91.181:9300 4300 2019-04-05 13:13:29.631 +2 21809 XQE 0 4 Audit.RTUsage.qs.XQE.QueryService Response Queryservice heeft een antwoord geretourneerd voor het verzoek "configure" van rapport "unknown".



    ------------------------------
    Bastiaan Krijgsman
    ------------------------------



  • 4.  RE: Refresh metadata fails

    Posted Fri April 05, 2019 09:03 AM
    The screen shot helps.  There should be a log message with more information in cognosserver.log for the MSR_GEN_0071. There are a few things that have caused this in the past.  This is going to need a deeper investigation, can you please open a support case?  If you already have, please send me a personal message with the case # and I will follow-up with support.


    ------------------------------
    Rob Hatfield
    ------------------------------



  • 5.  RE: Refresh metadata fails

    Posted Fri April 05, 2019 09:47 AM
    I think I have solved this issue.

    It seems like that there is a difference between a data source connection that has been added in Cognos Administration and a data source connection added at Manage->Data server connections

    We have a lot of customers that migrated from Cognos 10 to CA11.0.x Normally they use the existing data source connections and enable the JDBC driver tab to use the new functionality

    If add new data source connection  the new way and give the concerning user group Write rights on this connection than it works:)


    ------------------------------
    Bastiaan Krijgsman
    ------------------------------



  • 6.  RE: Refresh metadata fails

    Posted Fri April 05, 2019 02:09 PM
    Hello Bastiaan, thank you for bringing this issue to our attention.  The error message needs to be more informative.  I've logged an internal defect to address this issue.

    ------------------------------
    ANDREW ALLEN
    ------------------------------