天翎MyApps技术社区 - 低代码平台 | 流程管理系统 | BPM软件

 找回密码
 注册成为天翎用户
查看: 640|回复: 3

[已解决] 导入报错

[复制链接]
晨帛信息 发表于 2013-8-12 13:54:49 | 显示全部楼层 |阅读模式
本帖最后由 sophie 于 2013-8-12 14:55 编辑

13:52:55,972  INFO MssqlDocStaticTblDAO:100 - MS SQL Server: SELECT TOP 2147483647 * FROM (SELECT TOP 10 * FROM (SELECT ROW_NUMBER() OVER (ORDER BY DOMAINID) AS ROWNUMBER, TABNIC.* FROM (SELECT TOP 2147483647 * FROM (SELECT TOP 100 PERCENT * FROM TLK_资源标引 T   WHERE DOMAINID ='11E2-AD6B-DFD0E074-AC1D-D340F16396A5' AND 1=1 ) ORDTB ORDER BY ORDTB.ID) TABNIC) TableNickname WHERE ROWNUMBER>0) TABNIC  ORDER BY ID
13:52:55,972  INFO AbstractDocStaticTblDAO:1151 - MS SQL Server: SELECT COUNT(*)  FROM (SELECT TOP 2147483647 * FROM (SELECT TOP 100 PERCENT * FROM TLK_资源标引 T   WHERE DOMAINID ='11E2-AD6B-DFD0E074-AC1D-D340F16396A5' AND 1=1 ) ORDTB ORDER BY ORDTB.ID) doc WHERE doc.DOMAINID ='11e2-ad6b-dfd0e074-ac1d-d340f16396a5'
13:53:14,287  INFO AbstractUploadDAO:279 - MS SQL Server: SELECT COUNT(*)  FROM DBO.T_UPLOAD WHERE ID = ?
13:53:18,865 ERROR OBPMFilterDispatcher:48 - URL: /obpm/portal/share/dynaform/dts/excelimport/ImprotExcel.action
javax.servlet.ServletException: Could not execute action
        at com.opensymphony.webwork.dispatcher.DispatcherUtils.serviceAction(DispatcherUtils.java:246)
        at com.opensymphony.webwork.dispatcher.FilterDispatcher.doFilter(FilterDispatcher.java:198)
        at cn.myapps.base.web.filter.OBPMFilterDispatcher.doFilter(OBPMFilterDispatcher.java:43)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at com.opensymphony.webwork.dispatcher.ActionContextCleanUp.doFilter(ActionContextCleanUp.java:78)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at cn.myapps.base.web.filter.AjaxMultiLanguageFilter.doFilter(AjaxMultiLanguageFilter.java:42)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at cn.myapps.base.web.filter.PersistenceFilter.doFilter(PersistenceFilter.java:30)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at cn.myapps.base.web.filter.SecurityFilter.doFilter(SecurityFilter.java:115)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.jasig.cas.client.util.AssertionThreadLocalFilter.doFilter(AssertionThreadLocalFilter.java:54)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.jasig.cas.client.util.HttpServletRequestWrapperFilter.doFilter(HttpServletRequestWrapperFilter.java:75)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.jasig.cas.client.validation.AbstractTicketValidationFilter.doFilter(AbstractTicketValidationFilter.java:197)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at cn.myapps.core.sso.cas.filter.OBPMAuthenticationFilter.doFilter(OBPMAuthenticationFilter.java:84)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.jasig.cas.client.session.SingleSignOutFilter.doFilter(SingleSignOutFilter.java:76)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at cn.myapps.base.web.filter.EncodingFilter.doFilter(EncodingFilter.java:27)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:263)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
        at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:584)
        at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
        at java.lang.Thread.run(Thread.java:619)
Caused by: org.apache.poi.poifs.filesystem.OfficeXmlFileException: The supplied data appears to be in the Office 2007+ XML. You are calling the part of POI that deals with OLE2 Office Documents. You need to call a different part of POI to process this data (eg XSSF instead of HSSF)
        at org.apache.poi.poifs.storage.HeaderBlockReader.<init>(HeaderBlockReader.java:116)
        at org.apache.poi.poifs.filesystem.POIFSFileSystem.<init>(POIFSFileSystem.java:153)
        at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:305)
        at org.apache.poi.hssf.usermodel.HSSFWorkbook.<init>(HSSFWorkbook.java:286)
        at cn.myapps.core.dynaform.dts.excelimport.config.ImpExcelToDoc.<init>(ImpExcelToDoc.java:27)
        at cn.myapps.core.dynaform.dts.excelimport.config.action.ImportExcelAction.improtExcelToDocument(ImportExcelAction.java:154)
        at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
        at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
        at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        at java.lang.reflect.Method.invoke(Method.java:597)
        at com.opensymphony.xwork.DefaultActionInvocation.invokeAction(DefaultActionInvocation.java:365)
        at com.opensymphony.xwork.DefaultActionInvocation.invokeActionOnly(DefaultActionInvocation.java:217)
        at com.opensymphony.webwork.interceptor.BackgroundProcess$1.run(BackgroundProcess.java:28)
        ... 1 more
请问这个是什么原因
sophie 发表于 2013-8-12 14:08:55 | 显示全部楼层
您好,麻烦检查一下Excel导入配置是否正确,或是直接Q我,Q号1797595452
 楼主| 晨帛信息 发表于 2013-8-12 14:53:05 | 显示全部楼层
该帖的问题已经解决,问题是导入的文件被系统破坏了。谢谢
sophie 发表于 2013-8-12 14:55:13 | 显示全部楼层
好的,谢谢反馈。该问题远程帮客户重新建一个电子表可以了,可能是原先那个电子表格损坏了,目前已经解决其问题了,可以关闭该帖子了。

本版积分规则

QQ|手机版|天翎MyApps技术社区 ( 粤ICP备11093750号 )

GMT+8, 2026-8-13 02:19

Powered by Discuz! X3.4

Copyright © 2001-2020, Tencent Cloud.

快速回复 返回顶部 返回列表