Issues

error while importing test cases from excel

Toggle

Hi ,


running klaros in linux machine

i read the manual and tried importing test cases from excel using 
1
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 
12345678910111213141516171819202122232425262728293031
*   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
0 (0 Votes)

RE: error while importing test cases from excel
Answer
4/7/20 10:12 AM as a reply to pradeep chauhan.
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
0 (0 Votes)

RE: error while importing test cases from excel
Answer
4/7/20 11:17 AM as a reply to Fabian Klaffke.
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

Attachments:

0 (0 Votes)

RE: error while importing test cases from excel
Answer
4/7/20 11:43 AM as a reply to pradeep chauhan.
Hi Pradeep,

there is an extra '\' in your URL (...config=P00001\&username...). Please try the following command:
1
curl -v -T TestCase.xls 'http://serverIP:18080/klaros-web/seam/resource/rest/import/testcase/xls?config=P00001&username=admin&password=admin'

Regards,
Fabian
0 (0 Votes)

RE: error while importing test cases from excel
Answer
4/7/20 11:54 AM as a reply to Fabian Klaffke.
Hi Fabian, 

this time i got this error 
123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156
[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>
0 (0 Votes)

RE: error while importing test cases from excel
Answer
4/7/20 12:19 PM as a reply to pradeep chauhan.
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:

  1. Shut down Klaros-Testmanagement.
  2. Copy the file jxls-reader-2.0.6.jar into the folder <install-dir>\webapps\klaros-web\WEB-INF\lib
  3. Copy the file XLSTestCaseImportService.class into the folder <install-dir>\webapps\klaros-web\WEB-INF\classes\de\verit\klaros\web\service\importer\testcase
  4. Start Klaros

Regards,
Fabian
0 (0 Votes)

RE: error while importing test cases from excel
Answer
4/7/20 3:43 PM as a reply to Fabian Klaffke.
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 ?

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193
> 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
0 (0 Votes)

RE: error while importing test cases from excel
Answer
4/7/20 4:04 PM as a reply to pradeep chauhan.
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
+1 (1 Vote)

RE: error while importing test cases from excel
Answer
4/7/20 7:00 PM as a reply to Fabian Klaffke.
Hi Fabian, 

thanks for the quick reponse and solution to my problem. 

regards
Pradeep 
0 (0 Votes)