cancel
Showing results for 
Search instead for 
Did you mean: 
cancel
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Your Friends List is a way to easily have access to the community members that you interact with the most! X

Translate the entire conversation x

Exception thrown exporting to XLSX from Windchill table

avillanueva
23-Emerald I

Exception thrown exporting to XLSX from Windchill table

Walking into a new year and a strange error message without any system changes (that I know of). When exporting a table of data to Excel (Export to XLSX), I get this error message:

avillanueva_0-1767702090490.png

All other export methods appear to complete fine just this one so I've dropped its severity down. This is with WC 13.0.2.4. 

Method Server logs show the following:

Caused by: java.lang.reflect.InvocationTargetException
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:569)
	at com.ptc.core.components.forms.FormDispatcher.callWizardCommand(FormDispatcher.java:112)
	at com.ptc.core.components.forms.FormDispatcher.execute(FormDispatcher.java:98)
	... 64 more
Caused by: java.lang.IllegalStateException: java.nio.file.NoSuchFileException: /tmp/poifiles/poi-sxssf-sheet5099617869605881006.xml
	at org.apache.poi.xssf.streaming.SXSSFWorkbook.createAndRegisterSXSSFSheet(SXSSFWorkbook.java:696)
	at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(SXSSFWorkbook.java:712)
	at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheet(SXSSFWorkbook.java:104)
	at com.ptc.core.components.export.table.AbstractExportToXLS.initialize(AbstractExportToXLS.java:109)
	at com.ptc.core.components.export.table.AbstractExportToXLS.<init>(AbstractExportToXLS.java:63)
	at com.ptc.core.components.export.table.ExportToXLSX.<init>(ExportToXLSX.java:24)
	at com.ptc.core.components.export.table.ExportFileType.getExportListWriter(ExportFileType.java:227)
	at com.ptc.core.components.export.table.ExportListWriterFactory.getExportWriter(ExportListWriterFactory.java:32)
	at com.ptc.core.components.export.table.ExportListCommands.getExportListWriter(ExportListCommands.java:155)
	at com.ptc.core.components.export.table.ExportListCommands.doExport(ExportListCommands.java:97)
	at com.ptc.core.components.export.table.ExportListCommands.export(ExportListCommands.java:88)
	... 70 more
Caused by: java.nio.file.NoSuchFileException: /tmp/poifiles/poi-sxssf-sheet5099617869605881006.xml
	at java.base/sun.nio.fs.UnixException.translateToIOException(UnixException.java:92)
	at java.base/sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:106)
	at java.base/sun.nio.fs.UnixException.rethrowAsIOException(UnixException.java:111)
	at java.base/sun.nio.fs.UnixFileSystemProvider.newByteChannel(UnixFileSystemProvider.java:218)
	at java.base/java.nio.file.Files.newByteChannel(Files.java:380)
	at java.base/java.nio.file.Files.createFile(Files.java:658)
	at java.base/java.nio.file.TempFileHelper.create(TempFileHelper.java:136)
	at java.base/java.nio.file.TempFileHelper.createTempFile(TempFileHelper.java:159)
	at java.base/java.nio.file.Files.createTempFile(Files.java:878)
	at org.apache.poi.util.DefaultTempFileCreationStrategy.createTempFile(DefaultTempFileCreationStrategy.java:102)
	at org.apache.poi.util.TempFile.createTempFile(TempFile.java:67)
	at org.apache.poi.xssf.streaming.SheetDataWriter.createTempFile(SheetDataWriter.java:100)
	at org.apache.poi.xssf.streaming.SheetDataWriter.<init>(SheetDataWriter.java:74)
	at org.apache.poi.xssf.streaming.SheetDataWriter.<init>(SheetDataWriter.java:84)
	at org.apache.poi.xssf.streaming.SXSSFWorkbook.createSheetDataWriter(SXSSFWorkbook.java:387)
	at org.apache.poi.xssf.streaming.SXSSFSheet.<init>(SXSSFSheet.java:103)
	at org.apache.poi.xssf.streaming.SXSSFWorkbook.createAndRegisterSXSSFSheet(SXSSFWorkbook.java:694)
	... 80 more

I can confirm that its not a space issue nor is the user running Windchill unable to read/write to /tmp folder. 

ACCEPTED SOLUTION

Accepted Solutions
avillanueva
23-Emerald I
(To:jbailey)

Not sure of cause but files did not exist. I restarted Windchill and its working now. Very odd but no longer an issue.

View solution in original post

6 REPLIES 6

All XLS table exports?

avillanueva
23-Emerald I
(To:jbailey)

Only XLSX and all tables.  I think it uses the same code. XLS and CSV and others still function. 

What's error line above this?

Caused by: java.lang.reflect.InvocationTargetException

 

avillanueva
23-Emerald I
(To:jbailey)

Nothing interesting:

2026-01-08 09:02:41,716 ERROR [ajp-nio-127.0.0.1-8010-exec-101] com.ptc.jca.mvc.controllers.ActionController <USERNAME>- java.lang.reflect.InvocationTargetException java.lang.reflect.InvocationTargetException
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
	at java.base/jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:77)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:569)
	at com.ptc.netmarkets.util.beans.NmCommandBean.execute(NmCommandBean.java:2246)
	at com.ptc.jca.mvc.controllers.ActionController.executeWizardAction(ActionController.java:222)
	at com.ptc.jca.mvc.controllers.ActionController.processRequest(ActionController.java:125)
	at jdk.internal.reflect.GeneratedMethodAccessor1872.invoke(Unknown Source)
	at java.base/jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
	at java.base/java.lang.reflect.Method.invoke(Method.java:569)
	at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:255)
	at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:188)
	at org.springframework.web.servlet.mvc.method.annotation.ServletInvocableHandlerMethod.invokeAndHandle(ServletInvocableHandlerMethod.java:118)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.invokeHandlerMethod(RequestMappingHandlerAdapter.java:926)
	at org.springframework.web.servlet.mvc.method.annotation.RequestMappingHandlerAdapter.handleInternal(RequestMappingHandlerAdapter.java:831)
	at org.springframework.web.servlet.mvc.method.AbstractHandlerMethodAdapter.handle(AbstractHandlerMethodAdapter.java:87)
	at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:1089)
	at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:979)
	at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:1014)
	at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:914)
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:590)
	at org.springframework.web.servlet.FrameworkServlet.service(FrameworkServlet.java:885)
	at jakarta.servlet.http.HttpServlet.service(HttpServlet.java:658)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:195)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
	at com.ptc.windchill.upgrade.ui.UpgradeMaintenanceFilter.doFilter(UpgradeMaintenanceFilter.java:31)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
	at com.ptc.core.ui.validation.URLValidationFilter.doFilter(URLValidationFilter.java:86)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
	at wt.httpgw.filter.WTContextBeanFilter.doWithWtContextBeanHandler(WTContextBeanFilter.java:148)
	at wt.httpgw.filter.WTContextBeanFilter.doFilter(WTContextBeanFilter.java:88)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
	at wt.licenseusage.licensing.LicenseFilter.doFilter(LicenseFilter.java:47)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
	at wt.servlet.CompressionFilter.doFilter(CompressionFilter.java:300)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
	at wt.servlet.RequestInterrupter.doFilter(RequestInterrupter.java:335)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
	at wt.servlet.ServletRequestMonitor.doFilter(ServletRequestMonitor.java:1675)
	at wt.servlet.ServletRequestMonitorFilter.doFilter(ServletRequestMonitorFilter.java:57)
	at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:164)
	at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:140)
	at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:167)
	at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:90)
	at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:483)
	at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:115)
	at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:93)
	at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:74)
	at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:344)
	at org.apache.coyote.ajp.AjpProcessor.service(AjpProcessor.java:431)
	at org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:63)
	at org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:905)
	at org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1751)
	at org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:52)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1190)
	at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659)
	at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63)
	at java.base/java.lang.Thread.run(Thread.java:840)

Interesting. The only article I saw said that "poifiles" was missing. Can you confirm it exists under /tmp/ ? Maybe it's a cache issue? Antivirus?

avillanueva
23-Emerald I
(To:jbailey)

Not sure of cause but files did not exist. I restarted Windchill and its working now. Very odd but no longer an issue.

Announcements
Top Tags