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.  Unable to connect to PA Data Source

    Posted 02/24/21 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 02/24/21 10:43 PM

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



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



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

    Posted 02/25/21 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 02/26/21 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
    ------------------------------



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

    Posted 03/01/21 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
    ------------------------------



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

    Posted 05/19/21 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
    ------------------------------