Clarity PPM

Expand all | Collapse all

Processes stopped working after database refresh

  • 1.  Processes stopped working after database refresh

    Posted 09-19-2017 12:03 PM

    We moved the ca ppm database from prod to staging. Some processes on staging stopped working. What could've caused this? The whole database was moved not just the data. 



  • 2.  Re: Processes stopped working after database refresh

    Posted 09-19-2017 03:07 PM

    What do you mean by, "stopped working"? Do new instances of processes not progress? Or are old instances - started before the backup was taken - still processing?

     

    Also, how was the DB backup taken? Was the backup taken while CA PPM Services were running?



  • 3.  Re: Processes stopped working after database refresh

    Posted 09-19-2017 04:59 PM

    Hi Jeevan,

    Some steps are not being executed as they should be. A calculated field from the object won’t get updated by the subobject.

    The services should be down while the backup was taken. I can’t confirm 100%



  • 4.  Re: Processes stopped working after database refresh

    Posted 09-20-2017 12:42 AM

    Have you tried restarting the bg, or the entire instance itself?

     

    NJ



  • 5.  Re: Processes stopped working after database refresh

    Posted 09-20-2017 12:48 AM

    Also, check these:

     

    Clarity process start with delay of more than a min 

    https://communities.ca.com/message/241710380 

     

    Processes Not Starting 

    https://communities.ca.com/message/241805631 

     

     

    CA Clarity Tuesday Tip - How to query DB for process and steps 

    https://communities.ca.com/message/106031546 

     

     

     

    NJ