error while importing test cases from excel - Klaros Test Management - Forum - Klaros Test Management
error while importing test cases from excel
pradeep chauhan, modified 5 Years ago.
error while importing test cases from excel
Youngling Posts: 5 Join Date: 4/7/20 Recent PostsHi ,
running klaros in linux machine
i read the manual and tried importing test cases from excel using
curl -v -T TestCase.xls 'http://seerverIP:18080/klaros-web/seam/resource/rest/import/testcase/xls?config=P00001\&username=admin&password=admin' |
* Trying serverip:18080... | |
* TCP_NODELAY set | |
* Connected to 189.127.90.24 (189.127.90.24) port 18080 (#0) | |
> PUT /klaros-web/seam/resource/rest/import/testcase/xls?config=P00001\&username=admin&password=admin HTTP/1.1 | |
> Host: 165.227.202.231:18080 | |
> User-Agent: curl/7.65.0 | |
> Accept: */* | |
> Content-Length: 7680 | |
> Expect: 100-continue | |
> | |
* Mark bundle as not supporting multiuse | |
< HTTP/1.1 400 | |
< Content-Type: text/html;charset=utf-8 | |
< Content-Language: en | |
< Content-Length: 1943 | |
< Date: Tue, 07 Apr 2020 07:37:32 GMT | |
< Connection: close | |
< | |
<!doctype html><html lang="en"><head><title>HTTP Status 400 – Bad Request</title><style type="text/css">body {font-family:Tahoma,Arial,sans-serif;} h1, h2, h3, b {color:white;background-color:#525D76;} h1 {font-size:22px;} h2 {font-size:16px;} h3 {font-size:14px;} p {font-size:12px;} a {color:black;} .line {height:1px;background-color:#525D76;border:none;}</style></head><body><h1>HTTP Status 400 – Bad Request</h1><hr class="line" /><p><b>Type</b> Exception Report</p><p><b>Message</b> Invalid character found in the request target. The valid characters are defined in RFC 7230 and RFC 3986</p><p><b>Description</b> The server cannot or will not process the request due to something that is perceived to be a client error (e.g., malformed request syntax, invalid request message framing, or deceptive request routing).</p><p><b>Exception</b></p><pre>java.lang.IllegalArgumentException: Invalid character found in the request target. The valid characters are defined in RFC 7230 and RFC 3986 | |
org.apache.coyote.http11.Http11InputBuffer.parseRequestLine(Http11InputBuffer.java:483) | |
org.apache.coyote.http11.Http11Processor.service(Http11Processor.java:502) | |
org.apache.coyote.AbstractProcessorLight.process(AbstractProcessorLight.java:65) | |
org.apache.coyote.AbstractProtocol$ConnectionHandler.process(AbstractProtocol.java:818) | |
org.apache.tomcat.util.net.NioEndpoint$SocketProcessor.doRun(NioEndpoint.java:1623) | |
org.apache.tomcat.util.net.SocketProcessorBase.run(SocketProcessorBase.java:49) | |
java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) | |
java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) | |
org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:61) | |
java.lang.Thread.run(Thread.java:748) | |
* Closing connection 0 | |
</pre><p><b>Note</b> The full stack trace of the root cause is available in the server logs.</p><hr class="line" /><h3>Apache Tomcat/8.5.51</h3></body></html> |
thanks
Pradeep
Fabian Klaffke, modified 5 Years ago.
RE: error while importing test cases from excel
Padawan Posts: 92 Join Date: 8/31/12 Recent Posts
Hi Pradeep,
thanks for sending us the detailed error message, which states that an "Invalid character found in the request target".
Could you send us the Excel file so we can try the import ourselves on one of our linux systems?
Regards,
Fabian
thanks for sending us the detailed error message, which states that an "Invalid character found in the request target".
Could you send us the Excel file so we can try the import ourselves on one of our linux systems?
Regards,
Fabian
pradeep chauhan, modified 5 Years ago.
RE: error while importing test cases from excel
Youngling Posts: 5 Join Date: 4/7/20 Recent Posts
Hi Fabian,
thanks for quick response.
here is the attached file. i got this one from one of the previous thread in this forum
Regards
Pradeep
thanks for quick response.
here is the attached file. i got this one from one of the previous thread in this forum
Regards
Pradeep
Attachments:
Fabian Klaffke, modified 5 Years ago.
RE: error while importing test cases from excel
Padawan Posts: 92 Join Date: 8/31/12 Recent Posts
Hi Pradeep,
there is an extra '\' in your URL (...config=P00001\&username...). Please try the following command:
Regards,
Fabian
there is an extra '\' in your URL (...config=P00001\&username...). Please try the following command:
curl -v -T TestCase.xls 'http://serverIP:18080/klaros-web/seam/resource/rest/import/testcase/xls?config=P00001&username=admin&password=admin' |
Regards,
Fabian
pradeep chauhan, modified 5 Years ago.
RE: error while importing test cases from excel
Youngling Posts: 5 Join Date: 4/7/20 Recent Posts
Hi Fabian,
this time i got this error
this time i got this error
[justify] Trying serverIP:18080... | |
* TCP_NODELAY set | |
* Connected to serverip (serverip) port 18080 (#0) | |
> PUT /klaros-web/seam/resource/rest/import/testcase/xls?config=P00001&username=admin&password=admin HTTP/1.1 | |
> Host: 165.227.202.231:18080 | |
> User-Agent: curl/7.65.0 | |
> Accept: */* | |
> Content-Length: 7680 | |
> Expect: 100-continue | |
> | |
* Mark bundle as not supporting multiuse | |
< HTTP/1.1 100 | |
* We are completely uploaded and fine | |
* Mark bundle as not supporting multiuse | |
< HTTP/1.1 500 | |
< Set-Cookie: JSESSIONID=ABFEB2594CAFD501D31AC4FD4EBC375C; Path=/klaros-web; HttpOnly | |
< vary: accept-encoding | |
< Content-Type: text/html;charset=utf-8 | |
< Content-Language: en | |
< Transfer-Encoding: chunked | |
< Date: Tue, 07 Apr 2020 09:48:42 GMT | |
< Connection: close | |
< | |
<!doctype html><html lang="en"><head><title>HTTP Status 500 – Internal Server Error</title><style type="text/css">body {font-family:Tahoma,Arial,sans-serif;} h1, h2, h3, b {color:white;background-color:#525D76;} h1 {font-size:22px;} h2 {font-size:16px;} h3 {font-size:14px;} p {font-size:12px;} a {color:black;} .line {height:1px;background-color:#525D76;border:none;}</style></head><body><h1>HTTP Status 500 – Internal Server Error</h1><hr class="line" /><p><b>Type</b> Exception Report</p><p><b>Message</b> org.jboss.resteasy.spi.UnhandledException: java.lang.reflect.InvocationTargetException</p><p><b>Description</b> The server encountered an unexpected condition that prevented it from fulfilling the request.</p><p><b>Exception</b></p><pre>javax.servlet.ServletException: org.jboss.resteasy.spi.UnhandledException: java.lang.reflect.InvocationTargetException | |
org.jboss.seam.servlet.ContextualHttpServletRequest.run(ContextualHttpServletRequest.java:96) | |
org.jboss.seam.resteasy.ResteasyResourceAdapter.getResource(ResteasyResourceAdapter.java:120) | |
org.jboss.seam.servlet.SeamResourceServlet.service(SeamResourceServlet.java:80) | |
javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) | |
de.verit.klaros.web.service.authentication.cas.CasSpringConfiguration$DummyFilter.doFilter(CasSpringConfiguration.java:170) | |
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) | |
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) | |
de.verit.klaros.web.filter.UserAgentFilter.doFilter(UserAgentFilter.java:49) | |
net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:211) | |
</pre><p><b>Root Cause</b></p><pre>org.jboss.resteasy.spi.UnhandledException: java.lang.reflect.InvocationTargetException | |
org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:364) | |
org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:232) | |
org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:208) | |
org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:556) | |
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:523) | |
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:125) | |
org.jboss.seam.resteasy.ResteasyResourceAdapter$1.process(ResteasyResourceAdapter.java:145) | |
org.jboss.seam.servlet.ContextualHttpServletRequest.run(ContextualHttpServletRequest.java:65) | |
org.jboss.seam.resteasy.ResteasyResourceAdapter.getResource(ResteasyResourceAdapter.java:120) | |
org.jboss.seam.servlet.SeamResourceServlet.service(SeamResourceServlet.java:80) | |
javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) | |
de.verit.klaros.web.service.authentication.cas.CasSpringConfiguration$DummyFilter.doFilter(CasSpringConfiguration.java:170) | |
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) | |
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) | |
de.verit.klaros.web.filter.UserAgentFilter.doFilter(UserAgentFilter.java:49) | |
net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:211) | |
</pre><p><b>Root Cause</b></p><pre>java.lang.reflect.InvocationTargetException | |
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) | |
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
java.lang.reflect.Method.invoke(Method.java:498) | |
org.jboss.seam.util.Reflections.invoke(Reflections.java:22) | |
org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:32) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56) | |
org.jboss.seam.resteasy.ResteasyContextInjectionInterceptor.aroundInvoke(ResteasyContextInjectionInterceptor.java:59) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) | |
org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) | |
org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:79) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) | |
org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) | |
org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107) | |
org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:196) | |
org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:114) | |
de.verit.klaros.web.servlet.importer.testcase.XLSTestCaseImportServlet_$$_javassist_seam_175.importer(XLSTestCaseImportServlet_$$_javassist_seam_175.java) | |
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) | |
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
java.lang.reflect.Method.invoke(Method.java:498) | |
org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:168) | |
org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269) | |
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227) | |
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216) | |
org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:541) | |
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:523) | |
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:125) | |
org.jboss.seam.resteasy.ResteasyResourceAdapter$1.process(ResteasyResourceAdapter.java:145) | |
org.jboss.seam.servlet.ContextualHttpServletRequest.run(ContextualHttpServletRequest.java:65) | |
org.jboss.seam.resteasy.ResteasyResourceAdapter.getResource(ResteasyResourceAdapter.java:120) | |
org.jboss.seam.servlet.SeamResourceServlet.service(SeamResourceServlet.java:80) | |
javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) | |
de.verit.klaros.web.service.authentication.cas.CasSpringConfiguration$DummyFilter.doFilter(CasSpringConfiguration.java:170) | |
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) | |
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) | |
de.verit.klaros.web.filter.UserAgentFilter.doFilter(UserAgentFilter.java:49) | |
net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:211) | |
</pre><p><b>Root Cause</b></p><pre>java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.Cell.getCellType()I | |
net.sf.jxls.reader.OffsetCellCheckImpl.readStringValue(OffsetCellCheckImpl.java:99) | |
net.sf.jxls.reader.OffsetCellCheckImpl.getCellValue(OffsetCellCheckImpl.java:70) | |
net.sf.jxls.reader.OffsetCellCheckImpl.isCheckSuccessful(OffsetCellCheckImpl.java:47) | |
net.sf.jxls.reader.OffsetCellCheckImpl.isCheckSuccessful(OffsetCellCheckImpl.java:60) | |
net.sf.jxls.reader.OffsetRowCheckImpl.isCheckSuccessful(OffsetRowCheckImpl.java:51) | |
net.sf.jxls.reader.OffsetRowCheckImpl.isCheckSuccessful(OffsetRowCheckImpl.java:66) | |
net.sf.jxls.reader.SimpleSectionCheck.isCheckSuccessful(SimpleSectionCheck.java:23) | |
net.sf.jxls.reader.XLSForEachBlockReaderImpl.read(XLSForEachBlockReaderImpl.java:42) | |
net.sf.jxls.reader.XLSSheetReaderImpl.read(XLSSheetReaderImpl.java:26) | |
net.sf.jxls.reader.XLSReaderImpl.readSheet(XLSReaderImpl.java:59) | |
net.sf.jxls.reader.XLSReaderImpl.readSheet(XLSReaderImpl.java:48) | |
net.sf.jxls.reader.XLSReaderImpl.read(XLSReaderImpl.java:34) | |
de.verit.klaros.web.service.importer.testcase.XLSTestCaseImportService.getXLSReadStatus(XLSTestCaseImportService.java:170) | |
de.verit.klaros.web.service.importer.testcase.XLSTestCaseImportService.importXLSTestCaseWorkbook(XLSTestCaseImportService.java:101) | |
de.verit.klaros.web.servlet.importer.testcase.XLSTestCaseImportServlet.importTestCaseData(XLSTestCaseImportServlet.java:78) | |
de.verit.klaros.web.servlet.importer.testcase.BaseTestCaseImportServlet.importer(BaseTestCaseImportServlet.java:77) | |
de.verit.klaros.web.servlet.importer.testcase.XLSTestCaseImportServlet.importer(XLSTestCaseImportServlet.java:69) | |
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) | |
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
java.lang.reflect.Method.invoke(Method.java:498) | |
org.jboss.seam.util.Reflections.invoke(Reflections.java:22) | |
org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:32) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56) | |
org.jboss.seam.resteasy.ResteasyContextInjectionInterceptor.aroundInvoke(ResteasyContextInjectionInterceptor.java:59) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) | |
org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) | |
org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:79) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) | |
org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) | |
org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107) | |
org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:196) | |
org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:114) | |
de.verit.klaros.web.servlet.importer.testcase.XLSTestCaseImportServlet_$$_javassist_seam_175.importer(XLSTestCaseImportServlet_$$_javassist_seam_175.java) | |
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) | |
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
java.lang.reflect.Method.invoke(Method.java:498) | |
org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:168) | |
org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269) | |
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227) | |
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216) | |
org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:541) | |
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:523) | |
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:125) | |
org.jboss.seam.resteasy.ResteasyResourceAdapter$1.process(ResteasyResourceAdapter.java:145) | |
org.jboss.seam.servlet.ContextualHttpServletRequest.run(ContextualHttpServletRequest.java:65) | |
org.jboss.seam.resteasy.ResteasyResourceAdapter.getResource(ResteasyResourceAdapter.java:120) | |
org.jboss.seam.servlet.SeamResourceServlet.service(SeamResourceServlet.java:80) | |
javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) | |
de.verit.klaros.web.service.authentication.cas.CasSpringConfiguration$DummyFilter.doFilter(CasSpringConfiguration.java:170) | |
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) | |
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) | |
de.verit.klaros.web.filter.UserAgentFilter.doFilter(UserAgentFilter.java:49) | |
net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:211) | |
* Closing connection 0 | |
</pre><p><b>Note</b> The full stack trace of the root cause is available in the server logs.</p><hr class="line" /><h3>Apache Tomcat/8.5.51</h3></body></html> |
Fabian Klaffke, modified 5 Years ago.
RE: error while importing test cases from excel
Padawan Posts: 92 Join Date: 8/31/12 Recent Posts
Hi Pradeep,
the latest version of Klaros-Testmanagement has a specific version of a library included, which prevents the import of your Excel-file. Please follow the steps below to update the library:
Regards,
Fabian
the latest version of Klaros-Testmanagement has a specific version of a library included, which prevents the import of your Excel-file. Please follow the steps below to update the library:
- Shut down Klaros-Testmanagement.
- Copy the file jxls-reader-2.0.6.jar into the folder <install-dir>\webapps\klaros-web\WEB-INF\lib
- Copy the file XLSTestCaseImportService.class into the folder <install-dir>\webapps\klaros-web\WEB-INF\classes\de\verit\klaros\web\service\importer\testcase
- Start Klaros
Regards,
Fabian
pradeep chauhan, modified 5 Years ago.
RE: error while importing test cases from excel
Youngling Posts: 5 Join Date: 4/7/20 Recent Posts
Hi Fabian,
followed the steps you mentioned but no success. got this error
do we have to remove the old jxls jar file present in the lib folder ?
Regards
Pradeep Chauhan
followed the steps you mentioned but no success. got this error
do we have to remove the old jxls jar file present in the lib folder ?
> PUT /klaros-web/seam/resource/rest/import/testcase/xls?config=P00001&username=admin&password=admin HTTP/1.1 | |
> Host: 174.138.44.28:18080 | |
> User-Agent: curl/7.65.0 | |
> Accept: */* | |
> Content-Length: 7680 | |
> Expect: 100-continue | |
> | |
* Mark bundle as not supporting multiuse | |
< HTTP/1.1 100 | |
* We are completely uploaded and fine | |
* Mark bundle as not supporting multiuse | |
< HTTP/1.1 500 | |
< Set-Cookie: JSESSIONID=F136668066548A43EF208C02F68E2D4F; Path=/klaros-web; HttpOnly | |
< vary: accept-encoding | |
< Content-Type: text/html;charset=utf-8 | |
< Content-Language: en | |
< Transfer-Encoding: chunked | |
< Date: Tue, 07 Apr 2020 13:36:02 GMT | |
< Connection: close | |
< | |
<!doctype html><html lang="en"><head><title>HTTP Status 500 – Internal Server Error</title><style type="text/css">body {font-family:Tahoma,Arial,sans-serif;} h1, h2, h3, b {color:white;background-color:#525D76;} h1 {font-size:22px;} h2 {font-size:16px;} h3 {font-size:14px;} p {font-size:12px;} a {color:black;} .line {height:1px;background-color:#525D76;border:none;}</style></head><body><h1>HTTP Status 500 – Internal Server Error</h1><hr class="line" /><p><b>Type</b> Exception Report</p><p><b>Message</b> org.jboss.resteasy.spi.UnhandledException: java.lang.reflect.InvocationTargetException</p><p><b>Description</b> The server encountered an unexpected condition that prevented it from fulfilling the request.</p><p><b>Exception</b></p><pre>javax.servlet.ServletException: org.jboss.resteasy.spi.UnhandledException: java.lang.reflect.InvocationTargetException | |
org.jboss.seam.servlet.ContextualHttpServletRequest.run(ContextualHttpServletRequest.java:96) | |
org.jboss.seam.resteasy.ResteasyResourceAdapter.getResource(ResteasyResourceAdapter.java:120) | |
org.jboss.seam.servlet.SeamResourceServlet.service(SeamResourceServlet.java:80) | |
javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) | |
de.verit.klaros.web.service.authentication.cas.CasSpringConfiguration$DummyFilter.doFilter(CasSpringConfiguration.java:170) | |
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) | |
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) | |
de.verit.klaros.web.filter.UserAgentFilter.doFilter(UserAgentFilter.java:49) | |
net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:211) | |
</pre><p><b>Root Cause</b></p><pre>org.jboss.resteasy.spi.UnhandledException: java.lang.reflect.InvocationTargetException | |
org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:364) | |
org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:232) | |
org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:208) | |
org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:556) | |
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:523) | |
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:125) | |
org.jboss.seam.resteasy.ResteasyResourceAdapter$1.process(ResteasyResourceAdapter.java:145) | |
org.jboss.seam.servlet.ContextualHttpServletRequest.run(ContextualHttpServletRequest.java:65) | |
org.jboss.seam.resteasy.ResteasyResourceAdapter.getResource(ResteasyResourceAdapter.java:120) | |
org.jboss.seam.servlet.SeamResourceServlet.service(SeamResourceServlet.java:80) | |
javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) | |
de.verit.klaros.web.service.authentication.cas.CasSpringConfiguration$DummyFilter.doFilter(CasSpringConfiguration.java:170) | |
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) | |
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) | |
de.verit.klaros.web.filter.UserAgentFilter.doFilter(UserAgentFilter.java:49) | |
net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:211) | |
</pre><p><b>Root Cause</b></p><pre>java.lang.reflect.InvocationTargetException | |
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) | |
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
java.lang.reflect.Method.invoke(Method.java:498) | |
org.jboss.seam.util.Reflections.invoke(Reflections.java:22) | |
org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:32) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56) | |
org.jboss.seam.resteasy.ResteasyContextInjectionInterceptor.aroundInvoke(ResteasyContextInjectionInterceptor.java:59) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) | |
org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) | |
org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:79) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) | |
org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) | |
org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107) | |
org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:196) | |
org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:114) | |
de.verit.klaros.web.servlet.importer.testcase.XLSTestCaseImportServlet_$$_javassist_seam_143.importer(XLSTestCaseImportServlet_$$_javassist_seam_143.java) | |
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) | |
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
java.lang.reflect.Method.invoke(Method.java:498) | |
org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:168) | |
org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269) | |
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227) | |
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216) | |
org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:541) | |
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:523) | |
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:125) | |
org.jboss.seam.resteasy.ResteasyResourceAdapter$1.process(ResteasyResourceAdapter.java:145) | |
org.jboss.seam.servlet.ContextualHttpServletRequest.run(ContextualHttpServletRequest.java:65) | |
org.jboss.seam.resteasy.ResteasyResourceAdapter.getResource(ResteasyResourceAdapter.java:120) | |
org.jboss.seam.servlet.SeamResourceServlet.service(SeamResourceServlet.java:80) | |
javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) | |
de.verit.klaros.web.service.authentication.cas.CasSpringConfiguration$DummyFilter.doFilter(CasSpringConfiguration.java:170) | |
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) | |
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) | |
de.verit.klaros.web.filter.UserAgentFilter.doFilter(UserAgentFilter.java:49) | |
net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:211) | |
</pre><p><b>Root Cause</b></p><pre>java.lang.NoClassDefFoundError: org/apache/commons/digester3/Digester | |
org.jxls.reader.ReaderBuilder.buildFromXML(ReaderBuilder.java:28) | |
de.verit.klaros.web.service.importer.testcase.XLSTestCaseImportService.getSheetReader(XLSTestCaseImportService.java:257) | |
de.verit.klaros.web.service.importer.testcase.XLSTestCaseImportService.getXLSReadStatus(XLSTestCaseImportService.java:170) | |
de.verit.klaros.web.service.importer.testcase.XLSTestCaseImportService.importXLSTestCaseWorkbook(XLSTestCaseImportService.java:101) | |
de.verit.klaros.web.servlet.importer.testcase.XLSTestCaseImportServlet.importTestCaseData(XLSTestCaseImportServlet.java:78) | |
de.verit.klaros.web.servlet.importer.testcase.BaseTestCaseImportServlet.importer(BaseTestCaseImportServlet.java:77) | |
de.verit.klaros.web.servlet.importer.testcase.XLSTestCaseImportServlet.importer(XLSTestCaseImportServlet.java:69) | |
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) | |
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
java.lang.reflect.Method.invoke(Method.java:498) | |
org.jboss.seam.util.Reflections.invoke(Reflections.java:22) | |
org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:32) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56) | |
org.jboss.seam.resteasy.ResteasyContextInjectionInterceptor.aroundInvoke(ResteasyContextInjectionInterceptor.java:59) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) | |
org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) | |
org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:79) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) | |
org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) | |
org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107) | |
org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:196) | |
org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:114) | |
de.verit.klaros.web.servlet.importer.testcase.XLSTestCaseImportServlet_$$_javassist_seam_143.importer(XLSTestCaseImportServlet_$$_javassist_seam_143.java) | |
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) | |
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
java.lang.reflect.Method.invoke(Method.java:498) | |
org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:168) | |
org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269) | |
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227) | |
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216) | |
org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:541) | |
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:523) | |
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:125) | |
org.jboss.seam.resteasy.ResteasyResourceAdapter$1.process(ResteasyResourceAdapter.java:145) | |
org.jboss.seam.servlet.ContextualHttpServletRequest.run(ContextualHttpServletRequest.java:65) | |
org.jboss.seam.resteasy.ResteasyResourceAdapter.getResource(ResteasyResourceAdapter.java:120) | |
org.jboss.seam.servlet.SeamResourceServlet.service(SeamResourceServlet.java:80) | |
javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) | |
de.verit.klaros.web.service.authentication.cas.CasSpringConfiguration$DummyFilter.doFilter(CasSpringConfiguration.java:170) | |
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) | |
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) | |
de.verit.klaros.web.filter.UserAgentFilter.doFilter(UserAgentFilter.java:49) | |
net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:211) | |
</pre><p><b>Root Cause</b></p><pre>java.lang.ClassNotFoundException: org.apache.commons.digester3.Digester | |
org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1358) | |
org.apache.catalina.loader.WebappClassLoaderBase.loadClass(WebappClassLoaderBase.java:1180) | |
org.jxls.reader.ReaderBuilder.buildFromXML(ReaderBuilder.java:28) | |
de.verit.klaros.web.service.importer.testcase.XLSTestCaseImportService.getSheetReader(XLSTestCaseImportService.java:257) | |
de.verit.klaros.web.service.importer.testcase.XLSTestCaseImportService.getXLSReadStatus(XLSTestCaseImportService.java:170) | |
de.verit.klaros.web.service.importer.testcase.XLSTestCaseImportService.importXLSTestCaseWorkbook(XLSTestCaseImportService.java:101) | |
de.verit.klaros.web.servlet.importer.testcase.XLSTestCaseImportServlet.importTestCaseData(XLSTestCaseImportServlet.java:78) | |
de.verit.klaros.web.servlet.importer.testcase.BaseTestCaseImportServlet.importer(BaseTestCaseImportServlet.java:77) | |
de.verit.klaros.web.servlet.importer.testcase.XLSTestCaseImportServlet.importer(XLSTestCaseImportServlet.java:69) | |
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) | |
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
java.lang.reflect.Method.invoke(Method.java:498) | |
org.jboss.seam.util.Reflections.invoke(Reflections.java:22) | |
org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:32) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56) | |
org.jboss.seam.resteasy.ResteasyContextInjectionInterceptor.aroundInvoke(ResteasyContextInjectionInterceptor.java:59) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) | |
org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:28) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) | |
org.jboss.seam.core.BijectionInterceptor.aroundInvoke(BijectionInterceptor.java:79) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) | |
org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:44) | |
org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68) | |
org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107) | |
org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:196) | |
org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:114) | |
de.verit.klaros.web.servlet.importer.testcase.XLSTestCaseImportServlet_$$_javassist_seam_143.importer(XLSTestCaseImportServlet_$$_javassist_seam_143.java) | |
sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) | |
sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) | |
sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) | |
java.lang.reflect.Method.invoke(Method.java:498) | |
org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:168) | |
org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:269) | |
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:227) | |
org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:216) | |
org.jboss.resteasy.core.SynchronousDispatcher.getResponse(SynchronousDispatcher.java:541) | |
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:523) | |
org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:125) | |
org.jboss.seam.resteasy.ResteasyResourceAdapter$1.process(ResteasyResourceAdapter.java:145) | |
org.jboss.seam.servlet.ContextualHttpServletRequest.run(ContextualHttpServletRequest.java:65) | |
org.jboss.seam.resteasy.ResteasyResourceAdapter.getResource(ResteasyResourceAdapter.java:120) | |
org.jboss.seam.servlet.SeamResourceServlet.service(SeamResourceServlet.java:80) | |
javax.servlet.http.HttpServlet.service(HttpServlet.java:741) | |
org.apache.tomcat.websocket.server.WsFilter.doFilter(WsFilter.java:52) | |
de.verit.klaros.web.service.authentication.cas.CasSpringConfiguration$DummyFilter.doFilter(CasSpringConfiguration.java:170) | |
org.springframework.web.filter.DelegatingFilterProxy.invokeDelegate(DelegatingFilterProxy.java:347) | |
org.springframework.web.filter.DelegatingFilterProxy.doFilter(DelegatingFilterProxy.java:263) | |
de.verit.klaros.web.filter.UserAgentFilter.doFilter(UserAgentFilter.java:49) | |
net.bull.javamelody.MonitoringFilter.doFilter(MonitoringFilter.java:211) | |
* Closing connection 0 | |
</pre><p><b>Note</b> The full stack trace of the root cause is available in the server logs.</p><hr class="line" /><h3>Apache Tomcat/8.5.51</h3></body></html> |
Pradeep Chauhan
Fabian Klaffke, modified 5 Years ago.
RE: error while importing test cases from excel (Answer)
Padawan Posts: 92 Join Date: 8/31/12 Recent Posts
HI Pradeep,
sorry, I missed one step in my previous post. There is another library that you need to put into the /lib-folder, which is attached to this post.
The existing libraries do not need to be deleted, just be sure to stop Klaros before copying the file and to restart it afterwards.
Regards,
Fabian
sorry, I missed one step in my previous post. There is another library that you need to put into the /lib-folder, which is attached to this post.
The existing libraries do not need to be deleted, just be sure to stop Klaros before copying the file and to restart it afterwards.
Regards,
Fabian
Attachments:
pradeep chauhan, modified 5 Years ago.
RE: error while importing test cases from excel
Youngling Posts: 5 Join Date: 4/7/20 Recent Posts
Hi Fabian,
thanks for the quick reponse and solution to my problem.
regards
Pradeep
thanks for the quick reponse and solution to my problem.
regards
Pradeep