PowerShell Task Lockup - VisualCron - Forum

Community forum

MRomer
2017-09-06T15:00:39Z
Have there been any reports of seemingly-random lockups of PowerShell tasks? We have several VisualCron installations that run a job with a PowerShell task. On a couple of these, we've had instances where the PowerShell task hangs indefinitely, and we've only cleared it by restarting the VisualCron service. Once the service is restarted, the job functions normally for hours or days before it hangs again. All the installations are 8.2.7.
SnapDiligence
2017-09-06T20:03:56Z
Originally Posted by: MRomer 

Have there been any reports of seemingly-random lockups of PowerShell tasks? We have several VisualCron installations that run a job with a PowerShell task. On a couple of these, we've had instances where the PowerShell task hangs indefinitely, and we've only cleared it by restarting the VisualCron service. Once the service is restarted, the job functions normally for hours or days before it hangs again. All the installations are 8.2.7.



I just started to have the same issue as of today, version 8.2.8.

Edit:
Work around provided by MRomer did fix the issue. Just stopping and restarting the server was not enough, a full restart of the service in the windows "services" application was required.
Support
2017-09-07T20:08:43Z
We wonder if it depends what the Task do? What if you just create a PowerShell script that outputs the current user? Is that working?

[System.Security.Principal.WindowsIdentity]::GetCurrent().Name
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
SnapDiligence
2017-09-08T13:30:25Z
Originally Posted by: Support 

We wonder if it depends what the Task do? What if you just create a PowerShell script that outputs the current user? Is that working?

[System.Security.Principal.WindowsIdentity]::GetCurrent().Name



In our case, it was all of our PowerShell tasks: calculating a Unix timestamp, modifying and updating jobs on the server through the API, generating directories, etc. It happens intermittently, and I cannot replicate. I haven't had it happen again in 2 days.
Support
2017-09-12T15:06:58Z
If it happens again then please create a small script that just outputs to host like:

write-output "hello world"


It would be interesting if that works.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
MRomer
2017-09-21T03:18:13Z
Originally Posted by: Support 

We wonder if it depends what the Task do? What if you just create a PowerShell script that outputs the current user? Is that working?

[System.Security.Principal.WindowsIdentity]::GetCurrent().Name



In my case the scripts that lock up all are interacting with a SQL Express database via SQLOLEDB. But it doesn't happen all the time, and it doesn't happen at all on my test equipment. All the affected installations are remote satellite offices. We haven't found a pattern to it, either. The jobs running the scripts run frequently (every 2 or 3 minutes). They may be fine for hours and then they lock up.
Support
2017-09-21T07:49:01Z
Originally Posted by: MRomer 

Originally Posted by: Support 

We wonder if it depends what the Task do? What if you just create a PowerShell script that outputs the current user? Is that working?

[System.Security.Principal.WindowsIdentity]::GetCurrent().Name



In my case the scripts that lock up all are interacting with a SQL Express database via SQLOLEDB. But it doesn't happen all the time, and it doesn't happen at all on my test equipment. All the affected installations are remote satellite offices. We haven't found a pattern to it, either. The jobs running the scripts run frequently (every 2 or 3 minutes). They may be fine for hours and then they lock up.



But during a "lockup" - can you run another script like the one above?
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
MRomer
2017-09-25T17:56:22Z
Originally Posted by: Support 

Originally Posted by: MRomer 

Originally Posted by: Support 

We wonder if it depends what the Task do? What if you just create a PowerShell script that outputs the current user? Is that working?

[System.Security.Principal.WindowsIdentity]::GetCurrent().Name



In my case the scripts that lock up all are interacting with a SQL Express database via SQLOLEDB. But it doesn't happen all the time, and it doesn't happen at all on my test equipment. All the affected installations are remote satellite offices. We haven't found a pattern to it, either. The jobs running the scripts run frequently (every 2 or 3 minutes). They may be fine for hours and then they lock up.



But during a "lockup" - can you run another script like the one above?



Other jobs with scripts continued to run without error during times that one script gets locked up.

We've worked around it for now by specifying flow entries for the PowerShell tasks and for the jobs running them. The job gets ended if the script runs for more than a minute. That seems to be working--the complaints have gone away.
Support
2017-09-26T08:04:52Z
Thanks, it is hard to say what level the lockups are in but it is good that we isolated it to your specific scripts. Maybe they can be analyzed by running part of script to see which exact call causes the problem.
Henrik
Support
http://www.visualcron.com 
Please like  VisualCron on facebook!
Scroll to Top