Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only
Back to discussions
Expand all | Collapse all

PAX Unable to load TM1 Databases

  • 1.  PAX Unable to load TM1 Databases

    Posted Wed May 15, 2019 05:07 AM
    Hi All,

    I have IBM PAL 2.0.6, PAW 2.0.41 and PAX 2.0.39 installed in our test server
    I am able to access PAW however unable to connect to PAX from local machine or any server box
    Please find the error attached and guide me.
    I have .Net Framework 4.7.03 on server and also local machine/other server
    We have disabled Firewall & Antivirus from our test server.
    We are unable to see the TM1 applications/databases. 

    Initial Test Connection succeeds however when I re-open the connection and test it then it Fails with error attached

    Please guide me on this issue

    Thanks
    Ajay

    ------------------------------
    Ajay Yendluru
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: PAX Unable to load TM1 Databases

    Posted Wed May 15, 2019 06:03 AM
    Can you check your security settings in Internet Explorer and ensure SSL and TSL options are enabled?



    ------------------------------
    Amin MOhammed
    ------------------------------

    Original Message


  • 3.  RE: PAX Unable to load TM1 Databases

    Posted Wed May 15, 2019 06:18 AM
      |   view attached
    Hi Amin,
    Thanks for the suggestion
    We have those enabled already in IE please refer to screenshot
    Thanks
    Ajay

    ------------------------------
    Ajay Yendluru
    ------------------------------

    Original Message


  • 4.  RE: PAX Unable to load TM1 Databases

    Posted Wed May 15, 2019 06:52 AM
    Here is a document on trouble shooting both PA for Excel and PAW
    IBM How to Troubleshoot Planning Analytics for Excel or Planning Analytics Workspace (PAW) Performance
    Ibm remove preview
    IBM How to Troubleshoot Planning Analytics for Excel or Planning Analytics Workspace (PAW) Performance
    You are encountering performance concerns with Planning Analytics for Excel or Planning Analytics Workspace, however do not know where to start.  The objective of this document is to help you better understand the components involved with Planning Analytics for Excel / Workspace and the areas of the product that require focus.
    View this on Ibm >


    ------------------------------
    paul YOUNG
    ------------------------------

    Original Message


  • 5.  RE: PAX Unable to load TM1 Databases

    Posted Wed May 15, 2019 07:14 AM
    Thanks Paul for the link !
    My Issue is not related to performance as of now, I have all components required up & running except PAX ... We are unable to establish stable connection  and PAX is unable to load tm1 databases currently.. we cant make PAX to work in our landscape and .Net Framework error and connection failed error is what we get everytime.

    We are able to access PAW from browser successfully

    ------------------------------
    Ajay Yendluru
    ------------------------------

    Original Message


  • 6.  RE: PAX Unable to load TM1 Databases

    Posted Wed May 15, 2019 07:26 AM
    PA for Excel
    • Are PA for Excel log files providing any errors?
    • Are you able to get a network trace? Fiddler - Free Web Debugging Proxy - Telerik
      Telerik.com remove preview
      Fiddler - Free Web Debugging Proxy - Telerik
      Fiddler is a free web debugging tool which logs all HTTP(S) traffic between your computer and the Internet. Inspect traffic, set breakpoints, and fiddle with incoming or outgoing data.
      View this on Telerik.com >
    • Are you using 365? Have you changed the setting to compatibility mode
    • There has been changes to PA for Excel over the past few releases. Are you on the latest version?


    If you continue to have issues with PA for Excel then I would suggest logging a ticket with IBM support.

    ------------------------------
    paul YOUNG
    ------------------------------

    Original Message


  • 7.  RE: PAX Unable to load TM1 Databases

    Posted Thu May 16, 2019 07:09 AM
    Hi Paul, we have checked all of these options with IBM and they confirmed everything is looking correct
    We still cant make PAX to work.
    Since PAX and PAW uses docker pa-gateway to connect and display/pull TM1 databases, would there be any http port conflict between these two? When I do netstat -a in TM1 app server , the ipaddress:5898  is in TIME_WAIT status..
    when I log into Architect, Perspectives, Performance Modeler I can see their individual ports ex: 15003, 17001, 18001 etc., with established status and listening. 
    We have BI Gateway server CAM Auth 5 in place and I have provided both server IP address and Docker Virtual pa-gateway address in all three files PMHUB,Planning & TM1Web but no luck

    Coming to IE, I have enabled Scripting as well 

    My hunch is this issue needs tweaking with networking or IE settings as we are able to establish connection but unable to load anything at all

    ------------------------------
    Ajay Yendluru
    ------------------------------

    Original Message


  • 8.  RE: PAX Unable to load TM1 Databases

    Posted Fri May 17, 2019 12:27 AM
    Issue is now resolved, turns out the CommManagerSettings.xml connection type TM1OData is not working for us. When we changed to TM1Rest and make the line look like below(strings in bold) it worked like a charm however this is only a work around(Temporary solution)


    ================================================================================
    <Server gateway="http://serverhostnmae/" friendlyname="Test" dataSource="TM1Rest" lastUsed="636936486384195601" wasInactive="0" state="{ &quot;DefaultProvider&quot; : &quot;rest&quot;, &quot;DefaultProxy&quot; : &quot;pmhub&quot;}" Dll="Framework.Provider.TM1Rest.dll" />
    ================================================================================

    ------------------------------
    Ajay Yendluru
    ------------------------------

    Original Message


  • 9.  RE: PAX Unable to load TM1 Databases

    Posted Wed June 05, 2019 06:11 PM
    Ajay, this was fixed for me by changing the dataSource entry from "TM1OData" to "TM1Rest". Thank you very much!

    ------------------------------
    Michael Titera
    ------------------------------

    Original Message


  • 10.  RE: PAX Unable to load TM1 Databases

    Posted Thu June 06, 2019 02:14 AM
    Glad it worked ! You're welcome Michael

    ------------------------------
    Ajay Yendluru
    ------------------------------

    Original Message


  • 11.  RE: PAX Unable to load TM1 Databases

    Posted Mon May 20, 2019 12:54 PM
    Edited by System Admin Fri January 20, 2023 04:51 PM
    I have a very similar problem and have a case open as well.  Can't get PAX 41 to see any databases in our PROD environment.  Fiddler shows a 401 unauthorized, however I can reach PAW, TM1Web, etc. no problem.  Im going to try your xml settings change and see if this helps.

    Where is that xml file located?  Nevermind, found it in AppData/Local/Cognos

    ------------------------------
    Robby Meyers
    ------------------------------

    Original Message


  • 12.  RE: PAX Unable to load TM1 Databases

    Posted Mon May 20, 2019 01:20 PM
    FYI, I can confirm that changing the CommManagerSettings.xml to mirror the older RestAPI line works for me.  Something must be off with the TM1Odata connection type.

    ------------------------------
    Robby Meyers
    ------------------------------

    Original Message


  • 13.  RE: PAX Unable to load TM1 Databases

    Posted Mon May 20, 2019 01:33 PM
    Glad it was helpful to you Robby ! IBM said they will come back with a permanent fix
    Thing is TM1OData type is not compatible with 2.0.5 or higher as they went hubless(PMHUB) from this version hence the anomaly ... however IBM stated that switch between TM1OData to PMHUB should be seamless ... Once I get that setting/configuration step from them I will keep you posted mate

    Thanks

    ------------------------------
    Ajay Yendluru
    ------------------------------

    Original Message


  • 14.  RE: PAX Unable to load TM1 Databases

    Posted Fri June 07, 2019 06:53 PM
    FYI, it turns out our issue was that the version of PAW we were on was older and did not have the endpoint to check the server version so it defaulted to TM1Odata.  Not sure if they are looking to change the default if the endpoint isn't found in PAW or not though.  Since upgrading PAW to the latest release we don't see this issue anymore.

    ------------------------------
    Robby Meyers
    ------------------------------

    Original Message


  • 15.  RE: PAX Unable to load TM1 Databases

    Posted Fri June 07, 2019 07:06 PM
    Hello Robby,
    thanks for the update!
    We installed PAX 2.0.41 and PAW 2.0.41 and we bumped into this behavior.

    IBM provided basically a way to switch the connection from TM1OData to PMHUB through PAX Link such as http://hostname/?pmhub&rest
    No need to change anything from commmanagersettings.xml

    May I know which latest version of PAW are you referring to and your tool versions please?

    Thanks
    Ajay

    ------------------------------
    Ajay Yendluru
    ------------------------------

    Original Message


  • 16.  RE: PAX Unable to load TM1 Databases

    Posted Fri June 07, 2019 07:16 PM
    Edited by System Admin Fri January 20, 2023 04:49 PM
    Edited,
     Sort of a weird experience.  It does appear to be working although at first attempt to login it uses TM1Odata but tells me it has optimized the connection type and to log in again.  Then when I look the connection is set to Planning Analytics type and it works.

    PAW version 41, PAX version 41 and PA 2.0.5 FP4


    Can you clarify on the link setting you have?
    To use the old connector would it be
    https://hostname/?rest

    ?

    ------------------------------
    Robby Meyers
    ------------------------------

    Original Message


  • 17.  RE: PAX Unable to load TM1 Databases

    Posted Fri June 07, 2019 07:30 PM
    Hey, It appears to be working now I just tested
    I have deleted the connection from Options in PAX
    Renamed Office Connection to Office Connection_Old in the path C:\Users\username\AppData\Local\Cognos\
    Launched Excel and established connection with just http://hostname/
    At this point, I can see TM1Odata being the datasource type and commmanagersettings.xml reflects TM1OData related parameter values

    As soon as I click connect, login to TM1 Database, PAX is automatically switching it to TM1Rest which is datasource IBM Planning Analytics

    Well it's all Good now then

    ------------------------------
    Ajay Yendluru
    ------------------------------

    Original Message


  • 18.  RE: PAX Unable to load TM1 Databases

    Posted Wed June 12, 2019 08:35 AM
    Hello all, 

    Moving forward, PMHubless will be the default and only connection available. 

    You can review the rules of engagement with regards to PMHubless https://www-01.ibm.com/support/docview.wss?uid=ibm10883120 

    Kind Regards,

    ------------------------------
    Robert VAUTOUR
    ------------------------------

    Original Message


Related Content