When running Autopilot as follows…PS1> &$autopilot /M "UPDATE" /I $report1 /O $report2 /L log.txt
…Excel comes up and the report runs normally. However, $report2 doesn't get written, and log.txt says:
Creating the file <$report2> failed with the following message: Exception of HRESULT: 0x800A03EC
Of course I do have write permissions on $report2. Changing the location of $report2 to my home directory (and then copying the result) solves the problem , but I still find this a bit annoying. What is going wrong here? What permissions does one need on a file (or directory) specified by the /O switch?
(Windows Server 2003, Jet Reports 2010)
Date
Votes
4 comments
-
Jet Reports Historic Posts Hi Hans,
Are you trying to run AutoPilot from a bash shell or something? Using your &$autopilot may work because the shell knows how to turn that into "C:\Program Files\JetReports\AutoPilot.exe" but the arguments that get passed into AutoPilot get passed straight in as you typed them. AutoPilot and Excel have no idea where $report1 or $report2 are located; they need actual hard drive or network locations here. The error message you are getting is actually coming out of Excel itself, but it's not really permissions related; it's the file location that it doesn't understand.
Regards,
Hughes -
Jet Reports Historic Posts I use Powershell and should have said so; I assumed that variables would be more readable than their actual values. Anyway, here is what the log file says:
[size=90]2011-09-08 10.37.36 AutoPilot opdrachtregel: /M "Update" /I "J:/Abecon Project (Besloten)/Jet Reports/Autopilot/test/blanco/proeflapje.xlsx" /O "J:/Abecon Project (Besloten)/Jet reports/Autopilot/test/klad/klad.xlsx" /D "J:/Abecon Project (Besloten)/Jet reports/Autopilot/test/log.txt" /L "J:/Abecon Project (Besloten)/Jet reports/Autopilot/test/log.txt" /P "overbodige_optie" "blah" "werkjaar" "2011" "hoe vaak" "wekelijks" "email" "xxx@yyy"
2011-09-08 10.37.46 Aanmaken van bestand 'J:/Abecon Project (Besloten)/Jet reports/Autopilot/test/klad/klad.xlsx' mislukt met volgende boodschap: 'Uitzondering van HRESULT: 0x800A03EC'.[/size]
When I run autopilot with the literal parameters as given above (not variables), I get the exact same result. Googling for "0x800A03EC" gives 40000 hits, all about the same error message - but no-one seems to know the exact meaning of this error code. There is a long list by Microsoft, but it doesn't have it.
I hoped it would be some known problem, but, as I said, I can easily work around it by using my home directory for the output report. -
Jet Reports Historic Posts Okay, good to know. Is J: a mapped network drive? Mapped network drives should be specified with the full unc path (\\server\share\…) since they will net necessarily be mapped if you are running the task logged off. If you are using Windows Vista, Windows 7, or Windows Server 2008, there are some special requirements that you might need to check. Take a look at this KB article on our support site:
http://support.jetreports.com/index.php?_m=knowledgebase&_a=viewarticle&kbarticleid=531
While this article refers to running the task while being logged off the computer, I'm thinking specifically this error may happen if you don't do steps 1 & 2.
Regards,
Hughes -
Jet Reports Historic Posts Mapped network drives should be specified with the full unc path
Bingo again! Using //server/share instead of the drive letter gets rid of the problem. I must say that I find your answer a lot more readable than HRESULT: 0x800A03EC ;)
Thanks!
Hans
Please sign in to leave a comment.