Differences
This shows you the differences between the selected revisions of the page.
| guide_debugging_scheduler 2018-02-01 | guide_debugging_scheduler 2023-01-20 (current) | ||
| Line 1: | Line 1: | ||
| - | ====== Debugging Transfer Task Running in Windows Scheduler, SSIS or Other Automation Service ====== | + | ====== Debugging transfer task running in Windows Scheduler, SSIS, or another automation service ====== |
| If your transfer automation task running under Windows Scheduler, SSIS or similar service does not work, it may not be immediately obvious what is wrong. Particularly because output of WinSCP process is hidden. | If your transfer automation task running under Windows Scheduler, SSIS or similar service does not work, it may not be immediately obvious what is wrong. Particularly because output of WinSCP process is hidden. | ||
| Line 11: | Line 11: | ||
| </code> | </code> | ||
| - | If the task works correctly from Command prompt, see [[faq_scheduler|My script works fine when executed manually, but fails or hangs when run by Windows Scheduler, SSIS or other automation service. What am I doing wrong?]] | + | Execute the command from an independent working directory (neither WinSCP installation folder ''C:\Program Files (x86)\WinSCP'', &winpath nor script folder, nor transfer source nor destination folder). Common cause of problems is that your command or script rely on a specific working directory, and your scheduled tasks runs from elsewhere. |
| + | |||
| + | If the command works correctly from Command prompt, see [[faq_scheduler|*]] | ||
| If the task fails even when run from Command prompt, inspect a console output of the task for any error. If you see an error, check list of [[messages|common error messages]] or search this website for the error. To check for an error in console output, it is [[troubleshooting#scripting|recommended]] to use ''[[executables|winscp.com]]''. | If the task fails even when run from Command prompt, inspect a console output of the task for any error. If you see an error, check list of [[messages|common error messages]] or search this website for the error. To check for an error in console output, it is [[troubleshooting#scripting|recommended]] to use ''[[executables|winscp.com]]''. | ||
| Line 17: | Line 19: | ||
| If the problem is not obvious from the output, enable logging to a file as described below. | If the problem is not obvious from the output, enable logging to a file as described below. | ||
| - | ===== Inspecting Session Log ===== | + | ===== [[session_log]] Inspecting Session Log ===== |
| Next step is to enable logging to file (you should have logging enabled anyway) and inspect the log. Use ''[[commandline#logging|/log]]'' command-line parameter. | Next step is to enable logging to file (you should have logging enabled anyway) and inspect the log. Use ''[[commandline#logging|/log]]'' command-line parameter. | ||
| Line 32: | Line 34: | ||
| </code> | </code> | ||
| - | If you know that the task failed with [[scripting#result|exit code 1]], see [[faq_exit_code|Why is WinSCP returning non zero exit code?]] to learn what to look for in the log. | + | If you know that the task failed with [[scripting#result|exit code 1]], see [[faq_exit_code|*]] to learn what to look for in the log. |
| ===== [[output]] Inspecting Output Log ===== | ===== [[output]] Inspecting Output Log ===== | ||
| If a session log file is not even created, when executed from Windows Scheduler/%%SSIS%%, although the same WinSCP command and logging is working, when executed manually on command-line, there can be some problem in the Windows Scheduler/%%SSIS%% environment that prevents WinSCP from starting or writing to the log. | If a session log file is not even created, when executed from Windows Scheduler/%%SSIS%%, although the same WinSCP command and logging is working, when executed manually on command-line, there can be some problem in the Windows Scheduler/%%SSIS%% environment that prevents WinSCP from starting or writing to the log. | ||
| - | To debug such problems, wrap WinSCP command to a batch file and redirect WinSCP console output to a file. Make sure you use a console interface tool ''[[executables|winscp.com]]'', instead of ''winscp.exe''. It also useful to log something to the output file before running WinSCP, to verify that output logging is working. | + | To debug such problems, wrap WinSCP command to a batch file and redirect WinSCP console output to a file. Make sure you use a console interface tool ''[[executables|winscp.com]]'', instead of ''winscp.exe''. It is also useful to log something to the output file before running WinSCP, to verify that output logging is working. |
| The batch file can look like: | The batch file can look like: | ||
| Line 43: | Line 45: | ||
| <code batch> | <code batch> | ||
| @echo off | @echo off | ||
| - | echo Starting WinSCP > C:\script\example.out | + | ( |
| - | "C:\Program Files (x86)\WinSCP\WinSCP.com" /script="c:\script\example.txt" /log="c:\script\example.log" >> C:\script\example.out | + | ··echo Starting WinSCP |
| - | echo WinSCP done >> C:\script\example.out | + | · "C:\Program Files (x86)\WinSCP\WinSCP.com" /script="c:\script\example.txt" /log="c:\script\example.log" |
| + | · echo WinSCP done | ||
| + | ) > C:\script\example.out 2>&1 | ||
| </code> | </code> | ||
| Make sure you use a path for the ''example.out'', where Windows Scheduler/%%SSIS%% have a write access to. Check an output logged to ''example.out'' for any problems. If the ''example.out'' is not even created, the problem is not with WinSCP. | Make sure you use a path for the ''example.out'', where Windows Scheduler/%%SSIS%% have a write access to. Check an output logged to ''example.out'' for any problems. If the ''example.out'' is not even created, the problem is not with WinSCP. | ||
| + | |||
| + | ===== [[file_access]] Testing File Access Permissions ===== | ||
| + | If it turns out that WinSCP cannot read or write local files, it is usually because the local account that runs the Windows Scheduler/%%SSIS%% does not have permissions to access those files or their containing folders. Try reading or writing those files in a wrapper batch file (see the previous section), to verify that you get the same problem even without WinSCP. | ||
| + | |||
| + | <code batch> | ||
| + | @echo off | ||
| + | ( | ||
| + | echo Testing reading of a file | ||
| + | copy C:\source\file.txt %TEMP% | ||
| + | |||
| + | echo Testing writing of a file | ||
| + | echo Dummy contents > C:\destination\file.txt | ||
| + | |||
| + | echo Starting WinSCP | ||
| + | "C:\Program Files (x86)\WinSCP\WinSCP.com" /script="c:\script\example.txt" /log="c:\script\example.log" | ||
| + | echo WinSCP done | ||
| + | ) > C:\script\example.out 2>&1 | ||
| + | </code> | ||
| + | |||
| + | ===== [[powershell]] Debugging PowerShell Scripts ===== | ||
| + | While the previously mentioned techniques are mostly focused on WinSCP scripting and batch files, some can be used even when debugging a PowerShell script ([[library_powershell|that uses WinSCP .NET assembly]]). | ||
| + | |||
| + | Particularly, when debugging problems starting the PowerShell script itself, it is useful to wrap the ''powershell.exe''/''pwsh.exe'' command to a batch file. That will allow you to redirect a PowerShell output to a file, the [[#output|same way as shown above for ''winscp.com'']]. | ||
| + | |||
| + | If you know that your PowerShell is starting, but fails somewhere before WinSCP session log ([[library_session#sessionlogpath|''Session.SessionLogPath'']]) is created, and you do not want to create the batch file wrapper, use [[https://learn.microsoft.com/en-us/powershell/module/microsoft.powershell.host/start-transcript|''Start-Transcript'' cmdlet]] in the PowerShell script itself. Using it, you can capture all the PowerShell output that you would otherwise see on the PowerShell console. Put the following line to the beginning of your script (but after the ''param'' statement, if you have one): | ||
| + | |||
| + | <code powershell> | ||
| + | Start-Transcript C:\script\example.transcript | ||
| + | </code> | ||
| ===== Further Reading ===== | ===== Further Reading ===== | ||
| - | * [[faq_environment|Why does WinSCP not work in a new environment (operating system, machine, user account, network), when it works for me in a different environment already?]] | + | * [[faq_environment|*]] |
| - | * [[faq_script_result|How do I know that script completed successfully?]] | + | * [[faq_script_result|*]] |
| - | * [[faq_script_vs_gui|Why I cannot connect/transfer using script, when I can using GUI (or vice versa)?]] | + | * [[faq_script_vs_gui|*]] |
| + | * [[troubleshooting#scripting|Troubleshooting scripting/automation issues]] | ||