how to end a migration script
A developer noticed a “copy from file” script has been running for days. How do we end that? Is it running in the Phire database? Is there a utility within Phire to end it?
2 Comments »
RSS feed for comments on this post
Leave a Comment
You must be logged in to post a comment.
Admin said,
June 8, 2020 @ 4:04 pm
There isn’t anything in Phire to end the process. Chances are Phire is just waiting for it to finish, or maybe it’s already a dead process and the app server processed timed out waiting for results.
Is this Data Mover or a Data Workbench? If it’s Data Mover, then look for an instance of “psdmtx” running in the app server and kill it. If it’s Data Workbench, then look for an instance of “psae” and kill it.
Admin said,
June 10, 2020 @ 10:46 am
To add some more information to this question, here some more thoughts on how this feature behaves.
When a migration is running on the process scheduler, there is a button to cancel, and it’ll actually try to kill the process on the scheduler. If you don’t see that button it’s likely the process was running interactively which means it would have been in the psappsrv process on the app server, which it can’t kill anyway.
Ideally we would want to understand what happened to the process to get it hung up. Did it run too long and something timed out? Did a script execution or file migration hang up leaving Phire waiting for a response that would never come? Was there a hard error that caused the process to stop in its tracks? Contact Support for more guidance on how to evaluate that if it happens in your environment. We can help figure out the root cause and suggest ways to mitigate.
If the process is definitely not running any longer and the status is still “Processing”, then here is how to reset the status to “Canceled” so that the migration can be attempted again.
UPDATE PS_PHI_CR_MIGR_REQ
SET PHI_MIGR_STATUS = ‘X’
WHERE PHI_DOMAIN_ID = ‘domain‘
AND PHI_CR_NUM = ‘change request number‘
AND PHI_MIGR_SEQ = migration sequence;
Again, contact Phire Support for more personal help if you encounter a situation like this.