You are viewing a plain text version of this content. The canonical link for it is here.
Posted to dev@poi.apache.org by murthy2k3 <sm...@express-scripts.com> on 2011/01/18 17:07:48 UTC
Re: InvalidOperationException - POI cannot read temp file
Hi,
I am using the POI 3.6 in UNIX system. While running manually there is no
exceptions. But we have created one batch. It will run the loading of Excel
Spread sheet every mid night. While running with batch we are facing the
below exception. Please let me know how to resolve this.
Loading Data to Workbook...Process Started: Mon Jan 17 20:00:36 CST 2011
IOException in IRFtpUtil: /tmp/poifiles/poi-ooxml-1796018298.tmp (Permission
denied)
java.io.FileNotFoundException: /tmp/poifiles/poi-ooxml-1796018298.tmp
(Permission denied)
at java.io.FileOutputStream.open(Native Method)
at java.io.FileOutputStream.<init>(FileOutputStream.java:205)
at java.io.FileOutputStream.<init>(FileOutputStream.java:157)
at org.apache.poi.util.PackageHelper.open(PackageHelper.java:49)
at
org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:176)
at
com.express_scripts.affinium.mpd.TransitionPMVariablesLoad.ReadSheet(TransitionPMVariablesLoad.java:147)
at
com.express_scripts.affinium.mpd.TransitionPMVariablesLoad.main(TransitionPMVariablesLoad.java:334)
java.lang.Exception: /tmp/poifiles/poi-ooxml-1796018298.tmp (Permission
denied)
at
com.express_scripts.affinium.mpd.TransitionPMVariablesLoad.ReadSheet(TransitionPMVariablesLoad.java:156)
at
com.express_scripts.affinium.mpd.TransitionPMVariablesLoad.main(TransitionPMVariablesLoad.java:334)
Thanks
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/InvalidOperationException-POI-cannot-read-temp-file-tp3321489p3346392.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: InvalidOperationException - POI cannot read temp file
Posted by murthy2k3 <sm...@express-scripts.com>.
The same issue is happening again and again. Actually it is one of the
scheduler job, running on UNIX. The POI reads the Spread sheet and load some
records into tables every day. If I replace the Spread Sheet then it is
working fine. This Spread sheet will be copied to this location by BA's
every day.
--
View this message in context: http://apache-poi.1045710.n5.nabble.com/InvalidOperationException-POI-cannot-read-temp-file-tp3321489p4535535.html
Sent from the POI - Dev mailing list archive at Nabble.com.
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org
Re: InvalidOperationException - POI cannot read temp file
Posted by Nick Burch <ni...@alfresco.com>.
On Tue, 18 Jan 2011, murthy2k3 wrote:
> I am using the POI 3.6 in UNIX system. While running manually there is no
> exceptions. But we have created one batch. It will run the loading of Excel
> Spread sheet every mid night. While running with batch we are facing the
> below exception.
Can you try checking to see if anything holding the files open, and also
verify the permissions on the file? I don't think it's poi, but if you can
reproduce the problem fairly easily then you should be able to check
Nick
---------------------------------------------------------------------
To unsubscribe, e-mail: dev-unsubscribe@poi.apache.org
For additional commands, e-mail: dev-help@poi.apache.org