error while importing test cases from excel

pradeep chauhan, modified 4 Years ago.

error while importing test cases from excel

Youngling Posts: 5 Join Date: 4/7/20 Recent Posts

Hi ,


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'
getting this error 
*   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>  
please help 

thanks 
Pradeep
thumbnail
Fabian Klaffke, modified 4 Years ago.

RE: error while importing test cases from excel

Padawan Posts: 92 Join Date: 9/1/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
pradeep chauhan, modified 4 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
thumbnail
Fabian Klaffke, modified 4 Years ago.

RE: error while importing test cases from excel

Padawan Posts: 92 Join Date: 9/1/12 Recent Posts
Hi Pradeep,

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 4 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 
[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>
thumbnail
Fabian Klaffke, modified 4 Years ago.

RE: error while importing test cases from excel

Padawan Posts: 92 Join Date: 9/1/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:

  • 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 4 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 ?

> 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&#47;apache&#47;commons&#47;digester3&#47;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>
Regards
Pradeep Chauhan
thumbnail
Fabian Klaffke, modified 4 Years ago.

RE: error while importing test cases from excel (Answer)

Padawan Posts: 92 Join Date: 9/1/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
pradeep chauhan, modified 4 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