Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only

  • 1.  PAW - Unable to fetch data for content tree

    Posted Tue July 21, 2020 04:43 AM
    Hi Folks
    I'm running PAW 2.0.52 on Linux and I cannot browse the content of any of my TM1 Servers.
    I keep getting the well-documented : Unable to fetch data for content tree ( Server 500 error ).
    I get this both on my sample TM1 server (8014) and my dev server (8959).
    I've followed the following links...
    https://www.ibm.com/support/pages/unable-fetch-data-content-tree
    (both servers use the same user/password credentials, both using IntegratedSecurityMode=1)

    https://www.youtube.com/watch?v=7dWvcv6ErEg
    (added incoming firewall rule to allow relevant port numbers) (also switching firewall off completely)

    https://www.tm1forum.com/viewtopic.php?t=12994
    (both servers have HTTPPortNumber defined)

    Any ideas on how to troubleshoot this ?.
    Kind Regards
    Nick

    ------------------------------
    Nick Waters
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: PAW - Unable to fetch data for content tree

    Posted Wed July 22, 2020 04:54 AM
    Ni Nick,

    Are all the services up and correctly running in PAW? Did you use the Administration tool to configure PAW? Which distro of Linux is?

    Thanks and kindest regards,
    Angelo



    ------------------------------
    Angelo B.
    ------------------------------

    Original Message


  • 3.  RE: PAW - Unable to fetch data for content tree

    Posted Wed July 22, 2020 05:02 AM
    Hi Angelo
    Running Centos 7, PAW services all running and can access PAW fine just not seeing the TM1 server content.
    Nick

    ------------------------------
    Nick Waters
    ------------------------------

    Original Message


  • 4.  RE: PAW - Unable to fetch data for content tree

    Posted Wed July 22, 2020 05:07 AM
    Hi Nick,

    Are PAW and TM1 running with the same user? It sounds like there is a permission issue.

    Thanks and KR,
    Angelo

    ------------------------------
    Angelo B.
    ------------------------------

    Original Message


  • 5.  RE: PAW - Unable to fetch data for content tree

    Posted Wed July 22, 2020 11:25 AM
    Hi Nick,

    This might be worth looking into in case there's a firewall in the middle. It's static so requires tm1 database restart.
    https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_ipaddressv4_tm1cfg.html

    ------------------------------
    Tom Kim
    ------------------------------

    Original Message


  • 6.  RE: PAW - Unable to fetch data for content tree

    Posted Wed July 22, 2020 04:41 PM
    Edited by System Admin Fri January 20, 2023 04:42 PM
    Hi Nick,

    What is the rest of the error message?  Is it something like org.apache.http.conn.ConnectTimeoutException:Connect to some_ip:8014?  If so, is that the ip you expect it to be listening on?  Depending on where tm1 server is installed and the priority of the network interfaces, tm1 may be listening on a docker assigned ip or some other unexpected ip.  Tom's response above would address if this is the issue.

    ------------------------------
    Tim Fischer
    ------------------------------

    Original Message


  • 7.  RE: PAW - Unable to fetch data for content tree

    Posted Thu July 23, 2020 07:59 AM
    Hi Nick,

    In that past I've needed to set the IPAddressV4 and IPVersion parameters in my tm1s.cfg files in order to browse content of the TM1 databases in Workspace.   Please see: https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_inst.2.0.0.doc/c_ipaddressv4_tm1cfg.html

    Can you explain where your TM1 Server is in relation to Workspace?  Is it on the same Linux system?  Different Linux system?  A Windows system?  Same domain?

    In regards to how to troubleshoot this issue...you could try the Linux curl command to access your TM1 database via the REST API.  This URL does not require authentication: https://tm1server.domain.com:8014/api/v1/$metadata  (replace tm1server.domain.com with the FQDN and/or IP of the system running TM1).

    ------------------------------
    Stuart King
    IBM Planning Analytics Offering Manager
    ------------------------------

    Original Message


Related Content