Planning Analytics

Planning Analytics

Get AI-infused integrated business planning

 View Only
Expand all | Collapse all

Automated Restart of Cloud PA Server Instance

  • 1.  Automated Restart of Cloud PA Server Instance

    Posted Wed August 28, 2019 10:02 AM

    Has anyone figured out how to do a (nightly) automated restart of a Cloud PA Server Instance?  

    According to the documentation, you can't use DownTime (as Cloud PA is run as a Windows Service).

    You also cannot use Cognos Command Center (from a on-premises server) "Because the agent is not a Windows Administrator, you cannot use a Cognos Command Center task to start, stop, or restart the TM1 Server, which runs as a Windows service."

    There doesn't seem to be any provision in Cloud PAA to set up an automatic restart.  

    Any ideas are welcome!

    Thanks,

    Chris 



    ------------------------------
    Chris Wolfe
    ------------------------------

    #PlanningAnalyticswithWatson


  • 2.  RE: Automated Restart of Cloud PA Server Instance

    Posted Thu August 29, 2019 04:42 AM
    Hi Chris,

    As long as it is windows services, it can be restart/stop/start by a script that run in windows command prompt. You can use bat file, power shell script and use dot net function to stop/start service. After that register it as windows scheduler to run by schedule. It is correct you have to use windows user ID with admin privilege to do it. But it will run by schedule and the user don’t it to login again and again.

    Regards,
    Veronika

    Sent from my iPhone




  • 3.  RE: Automated Restart of Cloud PA Server Instance

    Posted Mon January 11, 2021 02:52 AM
    Edited by System Admin Fri January 20, 2023 04:10 PM
    Hi ​Veronika Gultom,

    I am looking bat file script, could you share the script if you implemented already. Thank you !
    Best Regards,
    Vijay.

    ------------------------------
    Vijay Kumar B
    ------------------------------



  • 4.  RE: Automated Restart of Cloud PA Server Instance

    Posted Thu August 29, 2019 07:49 AM
    Hi Chris,

    I can confirm it's not possible to schedule a restart of the TM1 database on Planning Analytics on IBM Cloud.  At this point in time it must be done manually.  Scheduled restarts is on the roadmap for Planning Analytics Administration but won't happen in 2019.

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



  • 5.  RE: Automated Restart of Cloud PA Server Instance

    Posted Wed July 29, 2020 10:20 AM
    Hi Stuart,

    Thank you again for your reply.  The same Cloud customer has asked again about this and, since it is now 2020, I thought I'd ask again!

    Is there any timeline for scheduling automated restarts for Cloud PA servers?

    Thanks!
    Chris

    Hi Stuart,

    Thank you again for your reply. The same Cloud customer has asked again about this and, since it is now 2020, I thought I'd ask again!

    Is there any timeline for scheduling automated restarts for Cloud PA servers?

    Thanks!
    Chris



    ------------------------------
    Christopher Wolfe
    ------------------------------



  • 6.  RE: Automated Restart of Cloud PA Server Instance

    Posted Thu July 30, 2020 08:03 AM
    Hi Chris,

    I can confirm this is still on the Planning Analytics roadmap.  I do not have an ETA to share.

    I seem to recall that our cloud ops team can add a Windows scheduled task to restart the service for your TM1 database.  Try opening a support ticket to request this.

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



  • 7.  RE: Automated Restart of Cloud PA Server Instance

    Posted Thu July 30, 2020 09:46 AM

    Hi Stuart,

     

    Thank you.  I'll pass along the suggestion to the customer.

     

    Thanks again,
    Chris  

     

     






  • 8.  RE: Automated Restart of Cloud PA Server Instance

    Posted Thu October 01, 2020 09:49 AM
    Hi,
    I would like to add my vote for this important issue. due to some resource issue, we need to restart the PA service on daily basis. we are in 2020....

    ------------------------------
    Oren Blum
    ------------------------------



  • 9.  RE: Automated Restart of Cloud PA Server Instance

    Posted Thu October 01, 2020 09:58 AM
    Hi,

    I think you can create a task using Cognos Command Center to restart the TM1 application. Are you using Cognos Command Center?

    Regards,

    Viviane Dorsa
    Solution Architect

    Logo
    T:  +55 11 3578-0800
    M: +55 11 97266-0300
    viviane.dorsa@netpartners.com.br 
    Rua Alexandre Dumas, 1711 – Birmann 11 - 6º andar
    CEP: 04717-004
    netpartners.com.br
    Facebook icon  LinkedIn icon  Youtube icon  

     
    image.png

    "Este e-mail é direcionado/intencionado somente para os endereçados e pode conter informação privilegiada e confidencial. Não deve ser espalhada, distribuída e copiada. Se você recebeu este e-mail/mensagem por engano, por favor informe ao remetente e delete do seu sistema."

     "This e-mail is intended only for the addressee(s) and may contain privileged and confidential information. It should not be disseminated, distributed, or copied. If you have received this e-mail message by mistake, please inform the sender, and delete it from your system."






  • 10.  RE: Automated Restart of Cloud PA Server Instance

    Posted Thu October 01, 2020 10:11 AM

    Hi Viviane, 

    Unfortunately, IBM Cognos Command Center cannot do this for Cloud:

    Because the agent is not a Windows Administrator, you cannot use a Cognos Command Center task to start, stop, or restart the TM1 Server, which runs as a Windows service.

    https://www.ibm.com/support/knowledgecenter/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_cloud_mg.2.0.0.doc/c_tm1_cloud_cognos_command_center_agents.html

    Kind regards,



    ------------------------------
    JILL MACLAURIN
    ------------------------------



  • 11.  RE: Automated Restart of Cloud PA Server Instance

    Posted Fri October 02, 2020 02:08 AM
    Hello, 

    The account used to run TM1 Service is probably authorized to start/stop itself.

    Build a batch file  with a NET or SC command to start / stop the service then run it via an ExecuteCommand. Then trigger it every night via a chore.
    Remember to do a SaveDataAll in a separate process in the chore to dump memory to disk prior to stopping the service, so you don't have to put a large wait time just in case the SaveData takes one hour...

    Cheers, 
    Laurent 



    ------------------------------
    Laurent Henssien
    ------------------------------