www.teamdev.com
Up to Discussions in JExcel Miscellaneous

This Question is Answered

1 "correct" answer available (4 pts) 1 "helpful" answer available (2 pts)
3 Replies Last post: Aug 11, 2008 8:25 PM by Andrew McGregor  
Click to view Andrew McGregor's profile  
Andrew McGregor
5 posts since
Aug 2, 2008

Aug 5, 2008 8:36 PM

Exception in Application Constructor


I'm using JExcel in a Tomcat-based application and on a couple of our customers' systems (on Win Server 2003, SP1) we get the exception below when we try to use the JExcel API:

Cannot run the Microsoft Excel application.
com.jniwrapper.win32.jexcel.ExcelException: Cannot run the Microsoft Excel application.
at com.jniwrapper.win32.jexcel.Application.<init>(SourceFile:94)
at emerald.dsd.data_source.file.dad.bean_CMG_Plus_2007.process_CMG_Plus_Transactioned(bean_CMG_Plus_2007.java:377)
at emerald.dsd.data_source.file.dad.bean_DAD.process_CMG_Plus_Transactioned(bean_DAD.java:668)
at org.apache.jsp.Data_005fSources_005fFiles_005fCMG_005fPlus_005fUpload_jsp._jspService(Data_005fSources_005fFiles_005fCMG_005fPlus_005fUpload_jsp.java:233)
at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:331)
at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:329)
at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:265)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:269)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:188)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:174)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:117)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:108)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:151)
at org.apache.coyote.http11.Http11AprProcessor.process(Http11AprProcessor.java:834)
at org.apache.coyote.http11.Http11AprProtocol$Http11ConnectionHandler.process(Http11AprProtocol.java:640)
at org.apache.tomcat.util.net.AprEndpoint$Worker.run(AprEndpoint.java:1286)
at java.lang.Thread.run(Unknown Source)
2008_08_05 12:01:03

The Application constructor does not take any parameters, so I'm not sure what could be wrong here. Can you proivde some informaiton on what is happening at line 94?

Click to view Igor Novikov's profile TeamDev Ltd.
Igor Novikov
197 posts since
Apr 24, 2006
1. Aug 6, 2008 8:57 PM in response to: Andrew McGregor
Re: Exception in Application Constructor

Hi Andrew,

This exception means that your application cannot instantiate MS Excel COM object. Such issue can be caused by incorrect MS Excel installation or MS Excel absence on the testing server. Also MS Excel COM object instantiation can be restricted by local security rules. You can try running on such machine JExcel based desktop application checking this issue for example JExcel Demo.

Sincerely,

Igor Novikov

Click to view Andrew McGregor's profile  
Andrew McGregor
5 posts since
Aug 2, 2008
2. Aug 7, 2008 5:24 PM in response to: Igor Novikov
Re: Exception in Application Constructor

Thanks for your answer!

I tried running the JExcel demo on that system and it ran successfully, so I don't think that Excel is missing or incorrectly installed. I suspect that it is due to the security settings for the user id because my desktop and browser run as an Active Directory user, but my Tomcat-based application runs under the "Local System Account" which might have different security settings.

I can work with the customer's IT staff on changing the security settings, but it would be helpful if you could tell me of any COM-related security settings that you are aware of within Windows Server 2003. Can you provide any information on this?

Thanks Again,

Andrew.
Click to view Andrew McGregor's profile  
Andrew McGregor
5 posts since
Aug 2, 2008
3. Aug 11, 2008 8:25 PM in response to: Andrew McGregor
Re: Exception in Application Constructor
I was able to get things working my using the instructions in http://support.microsoft.com/kb/288367/ to run Excel as a specific user through the DCOM interface (not the default "System" user).

Actions

More Like This