Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


nerdvana
2020-11-11T13:02:09Z
I have multiple tasks that use Excel within PowerShell scripts that are run on Visual Cron. I have noticed since the 9.4.0 upgrade, all of these task hang because the Excel process is not ending when Visual Cron runs these jobs. To be clear, when I manually run these tasks in Powershell, they complete without fail and close the Execel process. The issue only resides when Visual Cron runs the same PowerShell scripts. Any idea as to why this is happening?
Sponsor
Forum information
Support
2020-11-11T15:54:14Z
Originally Posted by: nerdvana 

I have multiple tasks that use Excel within PowerShell scripts that are run on Visual Cron. I have noticed since the 9.4.0 upgrade, all of these task hang because the Excel process is not ending when Visual Cron runs these jobs. To be clear, when I manually run these tasks in Powershell, they complete without fail and close the Execel process. The issue only resides when Visual Cron runs the same PowerShell scripts. Any idea as to why this is happening?



It's possible you're not using Local login + load profile on the credential you use? If you are, please send screenshots of all task settings and full information to support@visualcron.com
Michael
Support
http://www.visualcron.com 

Please like  VisualCron on facebook!
Gary_W
2020-11-11T16:14:00Z
Please post updates to this issue here as this will affect us too. Thank you.
Support
2020-11-11T16:38:52Z
Originally Posted by: Gary_W 

Please post updates to this issue here as this will affect us too. Thank you.



We are releasing a new version tomorrow that reverts the SQL changes so you shouldnt need to use local login + load profile again
Michael
Support
http://www.visualcron.com 

Please like  VisualCron on facebook!
nerdvana
2020-12-08T04:58:22Z
I reinstalled visual cron and reloaded the jobs. Everything seemed to work well for the last month and then it reverted right back to the same thing as my original post. I am truly lost as to what direction I need to go.

I can attest that when I run the same powershell scripts on that machine without VC, the scripts run without fail and the way they need to run. As soon as I try it with Visual Cron, the process fails as a whole.
Support
2020-12-10T16:31:08Z
Originally Posted by: nerdvana 

I reinstalled visual cron and reloaded the jobs. Everything seemed to work well for the last month and then it reverted right back to the same thing as my original post. I am truly lost as to what direction I need to go.

I can attest that when I run the same powershell scripts on that machine without VC, the scripts run without fail and the way they need to run. As soon as I try it with Visual Cron, the process fails as a whole.



Please send us an email to support@visualcron.com and include the following:

Screenshots of your connection settings (all tabs)
Screenshots of your task settings
Screenshot of error output/message
Enable extended task debug logging on the task

Michael
Support
http://www.visualcron.com 

Please like  VisualCron on facebook!
Scroll to Top