Planning Analytics

 View Only
  • 1.  FLASH: TM1 Server v2 SSL Certificate Expiry on 25 August 2022 (2022.08.17)

    Posted Wed August 17, 2022 02:26 PM
    Hi,

    I got this alert today. Don't recall if there was a reminder/alert raised before today about this. But, I must highlight that one week is very less time to make this in multiple environments we have. Now, we have to de-prioritize everything else and do this first. I wish IBM had alerted much before.

    Thanks!

    -----
    1. IBM Planning Analytics: Flashes

    - TITLE: TM1 Server v2 SSL Certificate Expiry on 25 August 2022
    - URL: https://www.ibm.com/support/pages/node/6613269?myns=swgimgmt&mynp=OCSSD29G&mync=E&cm_sp=swgimgmt-_-OCSSD29G-_-E
    - ABSTRACT: This notice does not apply to Planning Analytics on Cloud.

    This notice applies only to Planning Analytics Local environments configured with use the v2 SSL certificate. By default the v1 SSL certificate is used for encryption in transit for the TM1 Admin Server and TM1 databases.

    The default v2 SSL certificates provided with TM1 Server will expire on 25 August 2022. Planning Analytics environments that have been configured to use the v2 SSL certificates must be switched to the v1 certifi...
    ------

    ------------------------------
    Subhash Kumar
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: FLASH: TM1 Server v2 SSL Certificate Expiry on 25 August 2022 (2022.08.17)

    Posted Thu August 18, 2022 09:33 AM
    Thanks Subhash. This is a very short notice. I have not heard of this from IBM before.

    Thanks,
    Luther.

    ------------------------------
    Luther Rapaka
    ------------------------------



  • 3.  RE: FLASH: TM1 Server v2 SSL Certificate Expiry on 25 August 2022 (2022.08.17)

    Posted Fri August 19, 2022 03:59 AM
    Edited by System Fri January 20, 2023 04:25 PM
    Dear IBM team,  for those ho are still on TM1 10.2.2: where can be this ibmtm1_server certificate be downloaded?

    @STUART KING

    ------------------------------
    Best regards, Alexander Dvoynev

    TM1 and Data Science blog: https://advoynev.wordpress.com/
    First article - Primary sales forecasting using PA, SPSS Modeler and python.
    ------------------------------



  • 4.  RE: FLASH: TM1 Server v2 SSL Certificate Expiry on 25 August 2022 (2022.08.17)

    Posted Fri August 19, 2022 04:48 AM
    And another question: how can we determine which SSL certificate is being used on TM1 10.2.2 and older? There is no ​gsk8capicmd_64.exe here

    ------------------------------
    Best regards, Alexander Dvoynev

    TM1 and Data Science blog: https://advoynev.wordpress.com/
    First article - Primary sales forecasting using PA, SPSS Modeler and python.
    ------------------------------



  • 5.  RE: FLASH: TM1 Server v2 SSL Certificate Expiry on 25 August 2022 (2022.08.17)

    IBM Champion
    Posted Sat August 20, 2022 06:02 AM

    Looking at IBM Cognos Configuration, TM1 Admin Server, there is a setting for TM1 Admin Server Certificate Version.

    This appears to be what the article is referring to and as mentioned, by default Version 1 is used:



    ------------------------------
    George Tonkin
    ------------------------------



  • 6.  RE: FLASH: TM1 Server v2 SSL Certificate Expiry on 25 August 2022 (2022.08.17)

    IBM Champion
    Posted Fri August 26, 2022 09:00 AM
    Hi All,

    The client is Tm1 10.2.2. Tried the below option of changing certification verion 1 in Cognos Configuration and in the TM1s.cfg. But it didn't fix the issue. Do I need to perform any other steps?

    Any help would be much appreciated.

    Regards,
    Sasidaran Rammoorthy

    ------------------------------
    Sasidaran Rammoorthy
    ------------------------------



  • 7.  RE: FLASH: TM1 Server v2 SSL Certificate Expiry on 25 August 2022 (2022.08.17)

    Posted Fri August 26, 2022 10:28 AM
    Edited by System Fri January 20, 2023 04:46 PM
    These are the steps you'll need to perform for the change:

    1- In Cognos Configuration in the TM1 Admin Server section, change Server Certificate Version from 2 to 1
    2- In tm1s.cfg for all instances of TM1, remove the CertificateVersion=2 parameter
    3- Restart Admin Server and all TM1 server instances
    4- In Architect/Perspectives, update Certificate authority to point to the applixca.pem certificate file instead of the tm1ca_v2.pem.

    Shahhere



    ------------------------------
    Shahhere
    ------------------------------



  • 8.  RE: FLASH: TM1 Server v2 SSL Certificate Expiry on 25 August 2022 (2022.08.17)

    Posted Mon August 29, 2022 08:30 AM
    Does anyone has solution on how to revise this in TM1 web?

    ------------------------------
    Jiby Pappachan
    ------------------------------



  • 9.  RE: FLASH: TM1 Server v2 SSL Certificate Expiry on 25 August 2022 (2022.08.17)

    Posted Mon August 29, 2022 12:58 PM
    I wanted to provide confirmation that the steps from Shahhere are correct. I just went through this issue with a client on 10.2.2 and these steps resolved the expired certificate issue.

    1- In Cognos Configuration in the TM1 Admin Server section, change Server Certificate Version from 2 to 1
    2- In tm1s.cfg for all instances of TM1, remove the CertificateVersion=2 parameter
    3- Restart Admin Server and all TM1 server instances
    4- In Architect/Perspectives, update Certificate authority to point to the applixca.pem certificate file instead of the tm1ca_v2.pem.

    ------------------------------
    Rob Baierle
    PMsquare
    ------------------------------