I am creating a Batch Schedule template, but can't get it to run. The Table (does it need to be a report instead?) is supposed to be split out by Location Code to go to each email address-for testing, I am using my own address. It doesn't finish, and the error log mentions a file that "does not exist".
The error log is posted below.
2012-06-13 10.20.17 Running batch command: "C:\Program Files (x86)\JetReports\AutoPilot.exe" /m -2146826265 /i "S:\Finance\Jet Reports Data\CNC Distribution Report Jet.xlsx" /o "S:\Finance\Jet Reports Data\Output\S00009X (06.13.2012) - CNC Distribution Report Jet.xlsx" /l "S:\Finance\Jet Reports Data\Output\debug.txt" /e "Email_List" /u "Email_Subject" /b "Email_Body" /p "Location_Code" "S00009X"
2012-06-13 10.20.17 AutoPilot command line: /M "-2146826265" /I "S:\Finance\Jet Reports Data\CNC Distribution Report Jet.xlsx" /O "S:\Finance\Jet Reports Data\Output\S00009X (06.13.2012) - CNC Distribution Report Jet.xlsx" /L "S:\Finance\Jet Reports Data\Output\debug.txt" /E "Email_List" /B "Email_Body" /U "Email_Subject" /P "Location_Code" "S00009X"
2012-06-13 10.20.23 An unexpected exception has occurred while running the file 'S:\Finance\Jet Reports Data\CNC Distribution Report Jet.xlsx' with the following message: 'File "S:\Finance\Jet Reports Data\Output\S00009X (06.13.2012) - CNC Distribution Report Jet.xlsx" does not exist'
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hughes,
That sounds logical. I will test the Scheduler, but here's how I found the UNC path spelling:
I am using Windows 7 sp1.
Navigate to a file in the location for which you need the UNC path.
Open a new email or Word document.
Right-click a file and drag it to the newly opened email or document.
Release the mouse button and select "Create Hyperlink here"
You should now see a text string in the UNC format, like this:
\\sbs01\data\Finance\Jet Reports Data\Posted Invoices for Pensio Jet.xlsx
Now I finished testing the Batch Scheduler. It took patience for the first one, but the second one went much faster!
Thanks Hughes! -
Jet Reports Historic Posts Hi,
S: is probably a mapped network drive. You need to specify the full unc path to the files (\\server\share\…). Mapped network drives get mapped when you log in interactively to Windows. When the scheduled task runs, it is not logging in interactively to Windows, so those drives will not be mapped. Does this help?
Regards,
Hughes
Please sign in to leave a comment.