Planning Analytics

 View Only
Expand all | Collapse all

TM1 WEB login no longer working

  • 1.  TM1 WEB login no longer working

    Posted Wed August 19, 2020 12:53 PM
    Hi there,

    I have configured CAM security and set my authentication mode in Planning Analytics to 5 (CAM Security) which works fine for Cognos Analytics accessing my cubes, and also for all the things I can do in architect, like cube security etc.
    I have an Admin user defined in Analytics and this user is now Admin in my cube.

    Unfortunately, my TM1 web tools are now no longer working.
    When I access my :9510/pmpsvc address, I get a login prompt, and when I enter my Admin user credentials from CAM, it keeps telling me that there are no cubes that can be accessed with these credentials.

    Same happens when I start Performance Manager from the Startmenu and try to connect direct.

    Does anyone have an idea what could be wrong?

    It can't be a solution to reset security back to internal every time I want to so something in the web tools.....


    Thanks a lot & Best Regards
    Stefan

    ------------------------------
    Stefan Held
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: TM1 WEB login no longer working

    Posted Fri August 21, 2020 09:28 AM
    Hi,

    this is really blocking me now... I've reviewed all the steps from this page 
    https://www.ibm.com/support/pages/how-setup-tm1-web-and-tm1-applications-cam-authentication

    but it doesn't help.

    I can connect to my tm1server in architect, I can access it in Framework Manager and I can build reports on it, but I can't get into the TM1 web tools anymore since I've set up CAM security for PA.

    Isn't there anyone with an idea how to solve this? I try to open server:9510/pmpsvc and it prompts me for a login, I use the login user that is set as Admin in my TM1 server and it keeps telling me that no login was possible with the give credentials to any available server.

    Can this be a bug? I'm using 2.0.6 with Analytics 11.1.4, all on one machine.

    Thanks
    Stefan


    ------------------------------
    Stefan Held
    ------------------------------



  • 3.  RE: TM1 WEB login no longer working

    Posted Fri August 21, 2020 09:50 AM
    Hi Stefan,

    What version are you on?  The reason I am asking is I want to know if this is before or after the split out of tm1web to its own installer.  If it is after you have to change the ports so the pmpsvc and Planning Analytics Spreadsheet Service (PASS) are not both using 9510.
    Does the plain tm1web work:   server:9510:/tm1web ?
    Have you checked the pmpscv_config.xml and fpmsvc_config.xml to see if they are setup for cam and are not still set up for a different security mode?
    The files are located at:  
    C:\Program Files\ibm\cognos\tm1_64\webapps\pmpsvc\WEB-INF\configuration

    Let me know what you find out.
    Good luck!

    ------------------------------
    Scott Brown
    ------------------------------



  • 4.  RE: TM1 WEB login no longer working

    Posted Fri August 21, 2020 10:06 AM
    Hi Scott,

    thanks a lot for your reply.
    When I try server:9510:/tm1web I get a login prompt where I can select the server ansd when i choose my server I get:
    "The TM1Web service parameter was not specified or is one of the configured locations"

    The files you mentioned don't seem to have a setting for authentication mode:

    pmpsvc_config.xml:
    <?xml version="1.0" encoding="UTF-8"?>
    <pmpsvc_config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="pmpsvc_config.xsd">
    <fpm_service>
    <config class="com.ibm.cognos.pmpsvc.PMPSVCConfig"/>
    <service name="PMPService">
    <method name="setClients" sessionOptional="true"/>
    </service>
    </fpm_service>
    <service>
    <eventHandler class="com.ibm.ba.pm.service.pmpsvc.notification.app.contributor.event.handler.PMMobileEventHandler"/>
    <!-- Uncomment the line below to change the location of the planning service application files -->
    <!--appdef path="Location of planning service application files" /-->
    <notifications emailProvider=""/>
    <folder name="IBM Cognos TM1 Application - My Applications"/>
    <appdef path=""/>
    </service>
    <clients>
    <client id="thinClient" type="html-new" uri="http://cockpit03:9510/tm1web/Contributor.jsp">
    <name>
    <localeText default="true" locale="de" text="TM1 Application Web"/>
    </name>
    </client>
    <client id="desktopClient" type="cognos-rcp" uri="servlet/CogrcpServlet?applicationId=CognosInsight">
    <name>
    <localeText default="true" locale="de" text="Cognos Insight - Verbunden"/>
    </name>
    </client>
    <client id="distributedClient" type="cognos-rcp" uri="servlet/CogrcpServlet">
    <name>
    <localeText default="true" locale="de" text="Cognos Insight - Verteilt"/>
    </name>
    </client>
    </clients>
    </pmpsvc_config>


    fpmsvc_config.xml:
    fpm_config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="fpmsvc_config.xsd">
    <service forceQualifiedPaths="true">
    <businessViewpoint enabled="false" uri="http://cockpit03:9510/bv"/>
    <scorecarding enabled="true"/>
    <httpHeader name="X-Content-Type-Options" value="nosniff"/>

    <resource path=""/>
    <provisioning allowInstalls="true" allowUpdates="true" uri=""/>
    <users path=""/>
    <external uri="http://cockpit03:9510"/>
    <session timeout="60"/>
    </service>
    <tm1>
    <gateway uri=""/>
    <alternate_gateway_uris>
    <alternate_gateway uri="*"/>
    </alternate_gateway_uris>
    <dispatcher uri=""/>
    <admin_host name="cockpit03.ma.ad.fh-pforzheim.de">
    <servers>
    <server name="CXMD"/>
    <server name="test"/>
    </servers>
    </admin_host>
    </tm1>
    <!--
    The Cognos Insight publish feature enforces a set of minimum system requirements that are required to perform a publish. These are requirements on the system running
    the TM1 Applications service where the new TM1 servers will be created. To change these system requirement settings add the <insight_publish> element.
    maximumCDDDataMB - The maximum amount of TM1 data that can be sent in a publish request
    maximumTM1ServersAllowed - The maximum number of servers that can run on this machine. This is the maximum number of servers that are registered with the tm1Admin service.
    minimumFreeDiskSpaceMbRequired - The amount of disk space that must be available on the drive where the Tm1 data is published.
    minimumFreeDiskSpaceMbRequired - The amount of free memory that must be available on the publish server.
    -->
    <!--
    <insight_publish enabled="true" maximumCDDDataMB="100">
    <system_requirements maximumTM1ServersAllowed="10" minimumFreeDiskSpaceMbRequired="5000" minimumFreeMemoryMbRequired="500"/>
    </insight_publish>
    -->
    <!-- If low on disk space you can set a different drive for the published TM1 server data as an alternative to reducing minimumFreeDiskSpaceMbRequired -->
    <!--
    <insight_publish enabled="true" maximumCDDDataMB="100">
    <tm1Data path="E:\PublishedServers"/>
    <system_requirements maximumTM1ServersAllowed="10" minimumFreeDiskSpaceMbRequired="5000" minimumFreeMemoryMbRequired="500"/>
    </insight_publish>
    -->


    <insight pmpsvcPingTime="30"/>
    <insight_publish enabled="true"/>
    </fpm_config>

    The version of PA that I'm using is 2.0.6
    In which version has the setup changed?


    Thanks & Best Regards
    Stefan


    ------------------------------
    Stefan Held
    ------------------------------



  • 5.  RE: TM1 WEB login no longer working

    Posted Fri August 21, 2020 11:32 AM
    Hi,
    That sounds like the Cognos Analyics side does not have the right setup in the configuration files.  This article is for an older version of TM1, but should still apply.

    https://www.ibm.com/support/pages/unable-log-tm1web-service-parameter-was-not-specified

    ------------------------------
    Scott Brown
    ------------------------------



  • 6.  RE: TM1 WEB login no longer working

    Posted Fri August 21, 2020 11:48 AM
    Hi Scott,

    thanks, I already had that one and all the server names are set up with full qualified domain names.

    I'll try further.......


    Thanks & Best Regards
    Stefan

    ------------------------------
    Stefan Held
    ------------------------------



  • 7.  RE: TM1 WEB login no longer working

    Posted Fri August 21, 2020 11:54 AM
    When you are going to tm1web are you using the FQDN?   Is the FQDN used in the TM1s.cfg for the CAM connections?   If you are still having issues, it is probably time to open a ticket with IBM so they can check the setup over with you.



    ------------------------------
    Scott Brown
    ------------------------------



  • 8.  RE: TM1 WEB login no longer working

    Posted Mon August 24, 2020 07:43 AM
    Hi Scott,
    yes I guess that's what I'll have to do.
    I double-checked with the names in tm1s.cfg, found a typo, corrected it and restarted the server, but the problem remains.
    Trying to connect to pmpsvc still gives no server for these credentials,
    trying to connect to the tm1web address returns "The TM1Web service parameter was not specified or is not one of the configured locations"

    Thanks a lot for your help.

    Best Regards
    Stefan

    ------------------------------
    Stefan Held
    ------------------------------



  • 9.  RE: TM1 WEB login no longer working

    Posted Mon August 24, 2020 12:08 PM
    Edited by System Fri January 20, 2023 04:08 PM
    I ever experienced the same thing, and the last time I experienced it, the issue was the ip address in pmpsvc_config.xml always change to localhost or machine name automatically, instead of IP address that we have set before, and it is solved after we changed all the address in IBM Config to IP address. 


    ------------------------------
    Veronika Gultom
    ------------------------------



  • 10.  RE: TM1 WEB login no longer working

    Posted Tue August 25, 2020 04:28 AM
    Hi Veronika,

    good idea, but the problem remains.
    I'm not working with IP addresses but changed all configs and files to FQDN.
    Also tried a cookieless, fresh, clean browser, still the same error.

    Stefan

    ------------------------------
    Stefan Held
    ------------------------------