Cognos Analytics

 View Only

  • 1.  Unable to connect to PA Data Source

    Posted Wed February 24, 2021 02:39 PM
    Hi,

    In Cognos Data Source Wizard, I've specified Host and Port, "Use SSL" is not checked, when I test the connection, I'd get 2 errors:
    IBM Planning Analytics / Compatible Failed QFS-ERR-0138 The data source 'TMR' is not supported by any provider.
    IBM Planning Analytics / Dynamic Failed XTR-ERR-0005 A request to TM1 resulted in error: "[400] java.net.SocketException: Connection reset".

    Any thoughts?

    TIA!

    ------------------------------
    Joey Eisma
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Unable to connect to PA Data Source

    Posted Wed February 24, 2021 10:43 PM

    Did you import the ibmtm1.arm into Cognos Analytics?
    https://www-01.ibm.com/support/docview.wss?uid=swg22000885



    ------------------------------
    STEFAN VERMEULEN
    ------------------------------

    Original Message


  • 3.  RE: Unable to connect to PA Data Source

    Posted Thu February 25, 2021 02:48 AM

    Hi Joey,

    ensure that the UseSSL parameter in your tm1s.cfg is also set to false: UseSSL=F

    Default setting for UseSSL is true.
    Regards



    #CognosAnalyticswithWatson


  • 4.  RE: Unable to connect to PA Data Source

    Posted Fri February 26, 2021 12:17 PM
    Thank you Gertrud,

    I still get the failed status:

    IBM Planning Analytics / Compatible Failed QFS-ERR-0138 The data source 'TMR' is not supported by any provider.

    The second line has now "Succeeded" status.

    What could still be missing?


    Thanks a lot.

    ------------------------------
    Joey Eisma
    ------------------------------

    Original Message


  • 5.  RE: Unable to connect to PA Data Source

    Posted Mon March 01, 2021 06:19 PM
    Hi Joe,

    As of we heard , In planning Analytics latest version Compatible mode for Datasource is not supported.

    Thanks,
    Vinoth Kumar

    ------------------------------
    Vinoth Kumar Gunasekaran
    ------------------------------

    Original Message


  • 6.  RE: Unable to connect to PA Data Source

    Posted Wed May 19, 2021 10:38 AM
    Connection reset simply means that a TCP RST was received. This happens when your peer receives data that it can't process, and there can be various reasons for that. The simplest is when you close the socket, and then write more data on the output stream. By closing the socket, you told your peer that you are done talking, and it can forget about your connection. When you send more data on that stream anyway, the peer rejects it with an RST to let you know it isn't listening.


    ------------------------------
    line hammer
    ------------------------------

    Original Message