파일업로드시 에러 Fail to save: an error occurs while saving the package : null 도와주시면 감사하겠습니다.

Question

org.apache.poi.openxml4j.exceptions.OpenXML4JRuntimeException: Fail to save: an error occurs while saving the package : null

at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:500)

at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1417)

at org.apache.poi.openxml4j.opc.OPCPackage.save(OPCPackage.java:1404)

at org.apache.poi.openxml4j.opc.ZipPackage.closeImpl(ZipPackage.java:349)

at org.apache.poi.openxml4j.opc.OPCPackage.close(OPCPackage.java:420)

at com.softbowl.poi.SBLoadExcel.read(SBLoadExcel.java:144)

at wms.stdrinfo.excel.SBExcelLoad.cmExcelUpload(SBExcelLoad.java:91)

at wms.stdrinfo.excel.SBExcelLoad.excelUpload(SBExcelLoad.java:37)

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 org.springframework.web.bind.annotation.support.HandlerMethodInvoker.invokeHandlerMethod(HandlerMethodInvoker.java:176)

at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.invokeHandlerMethod(AnnotationMethodHandlerAdapter.java:427)

at org.springframework.web.servlet.mvc.annotation.AnnotationMethodHandlerAdapter.handle(AnnotationMethodHandlerAdapter.java:415)

at org.springframework.web.servlet.DispatcherServlet.doDispatch(DispatcherServlet.java:788)

at org.springframework.web.servlet.DispatcherServlet.doService(DispatcherServlet.java:717)

at org.springframework.web.servlet.FrameworkServlet.processRequest(FrameworkServlet.java:644)

at org.springframework.web.servlet.FrameworkServlet.doPost(FrameworkServlet.java:560)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:643)

at javax.servlet.http.HttpServlet.service(HttpServlet.java:723)

at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)

at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)

at org.springframework.web.filter.CharacterEncodingFilter.doFilterInternal(CharacterEncodingFilter.java:88)

at org.springframework.web.filter.OncePerRequestFilter.doFilter(OncePerRequestFilter.java:76)

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:191)

at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)

at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:103)

at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)

at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:293)

at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)

at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:610)

at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:503)

at java.lang.Thread.run(Thread.java:662)

Caused by: java.lang.NullPointerException

at org.apache.poi.openxml4j.opc.internal.marshallers.ZipPackagePropertiesMarshaller.marshall(ZipPackagePropertiesMarshaller.java:46)

at org.apache.poi.openxml4j.opc.ZipPackage.saveImpl(ZipPackage.java:444)

... 36 more

seungcheol · Accepted Answer

public File multipartToFile(MultipartFile file) throws IOException {

File convFile = new File(file.getOriginalFilename());

convFile.createNewFile();

FileOutputStream fos = new FileOutputStream(convFile);

fos.write(file.getBytes());

fos.close();

return convFile; // 144번째줄

}

일단 답변해주셔서 감사합니다.

알려주신 row로 가보니 파일명을 null로 받아가길래 기존에 있던 파일을 한번 다른 이름으로 저장해서 업로드 해보니 됩니다.

기존에 있던 파일명으로는 왜 안 되었는지 혹시 알 수 있을까요?

기존 파일명은 한글_한글.xlsx 였습니다 여기 파일명에 숫자 1만 더 붙였는데 됩니다.

yeori · Answer

at com.softbowl.poi.SBLoadExcel.read(SBLoadExcel.java:144)

저기라네요...

뭔가가 null인 상태로 넘어갔나봐요

파일업로드시 에러 Fail to save: an error occurs while saving the package : null 도와주시면 감사하겠습니다.

2개의 답변

Q&A 목록