Write Exec Task
- Verified User
- Posts: 1
- Joined: Mon Sep 28, 2009 9:52 am
Also, how does the Exel template work?
- Support Specialist
- Posts: 65
- Joined: Thu Mar 05, 2009 3:49 pm
As far as the Excel template goes, you create an Excel file that has the headings and columns the way you want them and then you reference that file in the template field in the Write Excel task.
- Support Specialist
- Posts: 87
- Joined: Thu Mar 05, 2009 3:49 pm
- Location: Ashland, NE USA
-
(Older versions of GoAnywhere Director only support Excel 2003.)
Sr Support Analyst
e. goanywhere.support@helpsystems.com
p. 1.800.949.4696
w. HelpSystems.com
INFO Finished task 'sql 1.0 (Connect to DB)'
4/11/11 11:50:31 AM INFO Executing task 'writeExcel 2.0 (Convert to Excel)'
4/11/11 11:50:31 AM INFO Finished task 'writeExcel 2.0 (Convert to Excel)'
4/11/11 11:50:31 AM ERROR org/apache/poi/util/IOUtils.copy(Ljava/io/InputStream;Ljava/io/OutputStream;)V
4/11/11 11:50:31 AM INFO Finished project 'BJB PARM120'
4/11/11 11:50:31 AM ERROR org/apache/poi/util/IOUtils.copy(Ljava/io/InputStream;Ljava/io/OutputStream;)V
com.linoma.dpa.runtime.JobFailedException: org/apache/poi/util/IOUtils.copy(Ljava/io/InputStream;Ljava/io/OutputStream;)V
at com.linoma.dpa.runtime.Job.run(Unknown Source)
at com.linoma.dpa.runtime.Runtime.executeProject(Unknown Source)
at com.linoma.dpa.j2ee.forms.ProjectListForm.runProject(Unknown Source)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:79)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
at java.lang.reflect.Method.invoke(Method.java:618)
at org.apache.el.parser.AstValue.invoke(AstValue.java:172)
at org.apache.el.MethodExpressionImpl.invoke(MethodExpressionImpl.java:276)
at org.apache.myfaces.el.convert.MethodExpressionToMethodBinding.invoke(MethodExpressionToMethodBinding.java:75)
at org.apache.myfaces.application.ActionListenerImpl.processAction(ActionListenerImpl.java:57)
at javax.faces.component.UICommand.broadcast(UICommand.java:143)
at javax.faces.component.UIData.broadcast(UIData.java:696)
at org.ajax4jsf.component.AjaxViewRoot.processEvents(AjaxViewRoot.java:321)
at org.ajax4jsf.component.AjaxViewRoot.broadcastEvents(AjaxViewRoot.java:296)
at org.ajax4jsf.component.AjaxViewRoot.processPhase(AjaxViewRoot.java:253)
at org.ajax4jsf.component.AjaxViewRoot.processApplication(AjaxViewRoot.java:466)
at org.apache.myfaces.lifecycle.InvokeApplicationExecutor.execute(InvokeApplicationExecutor.java:32)
at org.apache.myfaces.lifecycle.LifecycleImpl.executePhase(LifecycleImpl.java:103)
at org.apache.myfaces.lifecycle.LifecycleImpl.execute(LifecycleImpl.java:76)
at javax.faces.webapp.FacesServlet.service(FacesServlet.java:151)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.myfaces.webapp.filter.ExtensionsFilter.doFilter(ExtensionsFilter.java:147)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:178)
at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:290)
at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:368)
at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:495)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at com.linoma.dpa.security.SecurityFilter.doFilter(Unknown Source)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:845)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:811)
Caused by: com.linoma.dpa.ExecutionException: org/apache/poi/util/IOUtils.copy(Ljava/io/InputStream;Ljava/io/OutputStream;)V
at com.linoma.dpa.ErrorHandler.handleOnError(Unknown Source)
at com.linoma.dpa.Module.execute(Unknown Source)
at com.linoma.dpa.Project.execute(Unknown Source)
at com.linoma.dpa.runtime.Job.executeProject(Unknown Source)
... 45 more
Caused by: java.lang.NoSuchMethodError: org/apache/poi/util/IOUtils.copy(Ljava/io/InputStream;Ljava/io/OutputStream;)V
at org.apache.poi.util.PackageHelper.clone(PackageHelper.java:83)
at org.apache.poi.util.PackageHelper.clone(PackageHelper.java:44)
at org.apache.poi.POIXMLDocument.ensureWriteAccess(POIXMLDocument.java:185)
at org.apache.poi.xssf.usermodel.XSSFWorkbook.<init>(XSSFWorkbook.java:172)
at org.apache.poi.ss.usermodel.WorkbookFactory.create(WorkbookFactory.java:63)
at com.linoma.dpa.tasks.converters.excel.v2.ExcelDataWriter.initializeWorkBook(Unknown Source)
at com.linoma.dpa.tasks.converters.excel.v2.ExcelDataWriter.initialize(Unknown Source)
at com.linoma.dpa.tasks.converters.excel.v2.ExcelDataWriter.execute(Unknown Source)
at com.linoma.dpa.tasks.converters.DataWriterTask.execute(Unknown Source)
... 48 more
4/11/11 11:50:31 AM INFO End Date and Time: 4/11/11 11:50:31 AM