AnsweredAssumed Answered

Issue with applying style to xls file using Dynamic Java Execution Step

Question asked by Yugain on Jul 30, 2018
Latest reply on Jul 31, 2018 by Joel NeSmith

Hi

 

We are using CA Devtest 10.2.1.

 

We have prepared a Jar while which is used for below purpose:

1.Iterate through all the sheets in a workbook and count total no. of pass/fail cases

2.Color the passed cases in green and failed one in red

3.Prepare a execution summary sheet and update it with pass/fail count

4.Apply border to the execution summary sheet.

 

The Jar file is working as expected when running via eclipse but when running using Dynamic Java Execution step its giving below error:

 

============================================================================
| Exception:
============================================================================
| Step:        n/a
----------------------------------------------------------------------------
| Message:     Invocation Exception on Dynamic Call/Ctor void executionSummary( java.lang.String filePath, java.lang.String fileName )
----------------------------------------------------------------------------
| Trapped Exception: org.apache.poi.ss.usermodel.CellStyle.setFillPattern(Lorg/apache/poi/ss/usermodel/FillPatternType;)V
| Trapped Message:   java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.CellStyle.setFillPattern(Lorg/apache/poi/ss/usermodel/FillPatternType;)V
----------------------------------------------------------------------------
STACK TRACE
java.lang.NoSuchMethodError: org.apache.poi.ss.usermodel.CellStyle.setFillPattern(Lorg/apache/poi/ss/usermodel/FillPatternType;)V
 at com.itko.Execution_Summary.Main.executionSummary(Main.java:85)
 at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
 at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
 at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
 at java.lang.reflect.Method.invoke(Method.java:498)
 at com.itko.lisa.dynexec.Call.execute(Call.java:910)
 at com.itko.lisa.dynexec.Call.execute(Call.java:558)
 at com.itko.lisa.dynexec.CallEditor.invokeRaw(CallEditor.java:512)
 at com.itko.lisa.dynexec.CallEditor.invoke(CallEditor.java:371)
 at com.itko.lisa.dynexec.ComplexObjEditor.execute(ComplexObjEditor.java:948)
 at com.itko.lisa.dynexec.ComplexObjEditor.access$1100(ComplexObjEditor.java:48)
 at com.itko.lisa.dynexec.ComplexObjEditor$15.actionPerformed(ComplexObjEditor.java:865)
 at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
 at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
 at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
 at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
 at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
 at java.awt.Component.processMouseEvent(Component.java:6533)
 at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
 at java.awt.Component.processEvent(Component.java:6298)
 at java.awt.Container.processEvent(Container.java:2236)
 at java.awt.Component.dispatchEventImpl(Component.java:4889)
 at java.awt.Container.dispatchEventImpl(Container.java:2294)
 at java.awt.Component.dispatchEvent(Component.java:4711)
 at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
 at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
 at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
 at java.awt.Container.dispatchEventImpl(Container.java:2280)
 at java.awt.Window.dispatchEventImpl(Window.java:2746)
 at java.awt.Component.dispatchEvent(Component.java:4711)
 at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
 at java.awt.EventQueue.access$500(EventQueue.java:97)
 at java.awt.EventQueue$3.run(EventQueue.java:709)
 at java.awt.EventQueue$3.run(EventQueue.java:703)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
 at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
 at java.awt.EventQueue$4.run(EventQueue.java:731)
 at java.awt.EventQueue$4.run(EventQueue.java:729)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
 at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
 at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
 at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
 at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
 at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
 at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
 at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)
============================================================================


 at com.itko.lisa.dynexec.Call.execute(Call.java:945)
 at com.itko.lisa.dynexec.Call.execute(Call.java:558)
 at com.itko.lisa.dynexec.CallEditor.invokeRaw(CallEditor.java:512)
 at com.itko.lisa.dynexec.CallEditor.invoke(CallEditor.java:371)
 at com.itko.lisa.dynexec.ComplexObjEditor.execute(ComplexObjEditor.java:948)
 at com.itko.lisa.dynexec.ComplexObjEditor.access$1100(ComplexObjEditor.java:48)
 at com.itko.lisa.dynexec.ComplexObjEditor$15.actionPerformed(ComplexObjEditor.java:865)
 at javax.swing.AbstractButton.fireActionPerformed(AbstractButton.java:2022)
 at javax.swing.AbstractButton$Handler.actionPerformed(AbstractButton.java:2348)
 at javax.swing.DefaultButtonModel.fireActionPerformed(DefaultButtonModel.java:402)
 at javax.swing.DefaultButtonModel.setPressed(DefaultButtonModel.java:259)
 at javax.swing.plaf.basic.BasicButtonListener.mouseReleased(BasicButtonListener.java:252)
 at java.awt.Component.processMouseEvent(Component.java:6533)
 at javax.swing.JComponent.processMouseEvent(JComponent.java:3324)
 at java.awt.Component.processEvent(Component.java:6298)
 at java.awt.Container.processEvent(Container.java:2236)
 at java.awt.Component.dispatchEventImpl(Component.java:4889)
 at java.awt.Container.dispatchEventImpl(Container.java:2294)
 at java.awt.Component.dispatchEvent(Component.java:4711)
 at java.awt.LightweightDispatcher.retargetMouseEvent(Container.java:4888)
 at java.awt.LightweightDispatcher.processMouseEvent(Container.java:4525)
 at java.awt.LightweightDispatcher.dispatchEvent(Container.java:4466)
 at java.awt.Container.dispatchEventImpl(Container.java:2280)
 at java.awt.Window.dispatchEventImpl(Window.java:2746)
 at java.awt.Component.dispatchEvent(Component.java:4711)
 at java.awt.EventQueue.dispatchEventImpl(EventQueue.java:758)
 at java.awt.EventQueue.access$500(EventQueue.java:97)
 at java.awt.EventQueue$3.run(EventQueue.java:709)
 at java.awt.EventQueue$3.run(EventQueue.java:703)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
 at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:86)
 at java.awt.EventQueue$4.run(EventQueue.java:731)
 at java.awt.EventQueue$4.run(EventQueue.java:729)
 at java.security.AccessController.doPrivileged(Native Method)
 at java.security.ProtectionDomain$JavaSecurityAccessImpl.doIntersectionPrivilege(ProtectionDomain.java:76)
 at java.awt.EventQueue.dispatchEvent(EventQueue.java:728)
 at java.awt.EventDispatchThread.pumpOneEventForFilters(EventDispatchThread.java:201)
 at java.awt.EventDispatchThread.pumpEventsForFilter(EventDispatchThread.java:116)
 at java.awt.EventDispatchThread.pumpEventsForHierarchy(EventDispatchThread.java:105)
 at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:101)
 at java.awt.EventDispatchThread.pumpEvents(EventDispatchThread.java:93)
 at java.awt.EventDispatchThread.run(EventDispatchThread.java:82)

Outcomes