Cognos Analytics

 View Only

  • 1.  Framework Manager Model error when testing the datasource object

    Posted Tue March 09, 2021 11:58 AM
    Hi Friends,

    I would appreciate it if you could help me with this issue.

    The FM models I am working on are all sourced from the same datasource connection.  Surprisingly, some models are working and other s are not in the sense that when I test the datasource connection object in the model (or any of the query subjects in the model) for some of the models, I am getting the below error. Why is this happening when the datasource connection is the same for all models and the datasource connection also tests successfully in administration portal of cognos analytics.

    ERROR MESSAGE
    QE-DEF-0285 The logon failed.
    QE-DEF-0323 The DSN(ODBC)/ServiceName is invalid. Either the DSN is missing or the host is inaccessible.
    RQP-DEF-0068 Unable to connect to at least one database during a multi-database attach to 1 database(s) in:
    Netezza

    UDA-SQL-0031 Unable to access the "Netezza" database. Check that the connection parameters to the database are configured correctly. For example, ensure that the data source connection contains the signon information, such as a password, to connect to the database.
    UDA-SQL-0532 Data Source is not accessible: "NZSQL".
    [Microsoft][ODBC Driver Manager] Data source name not found and no default driver specified
    [Microsoft][ODBC Driver Manager] Invalid connection string attribute



    Regards

    ------------------------------
    Kiran Kumar
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Framework Manager Model error when testing the datasource object

    Posted Wed March 10, 2021 01:38 AM

    Hello Kiran,

    this error can occur if the connection, here the ODBC/DSN is not available or defined on the machine where Framework Manager is installed.
    Another situation is that the ODBC/DSN is defined on 64-bit ODBC Data Source Administrator on Windows.

    ODBC connections must be set up with ODBC Data Source Administrator (32-bit)!
    Also avoid a naming conflict when you've setup 32- and 64-bit ODBC connections.

    When testing the data source in Cognos Administration the connection string and ODBC/DSN of the server environment is used.

    I recommend you review the ODBC/DSN definition on Framework Manager machine.

    Hope this helps



    #CognosAnalyticswithWatson


  • 3.  RE: Framework Manager Model error when testing the datasource object

    Posted Wed March 10, 2021 03:11 AM
    Hi Gertrud,

    Thank you. I found another thing, the models are working only in DQM mode. When I changed the query mode of the model to DQM from CQM, I am able to test the query subjects in the model. Also found that the existing models that were working were also set to DQM. Since these are relational models, they should work on CQM.

    Please suggest as I am not able to understand why this is happening. 




    ------------------------------
    Kiran Kumar
    ------------------------------

    Original Message


  • 4.  RE: Framework Manager Model error when testing the datasource object

    Posted Sat March 20, 2021 02:16 PM
    Hi Gertrud,

    Thank you very much!. Your suggestion was just what was needed.
    I was able to fix the issue by having a 32-bit ODBC connection set up on the server on which Framework manager had been installed.

    ------------------------------
    Kiran Kumar
    ------------------------------

    Original Message