Create Flat File on 7.11

Hi All,

We just moved from 7.5 to 7.11. We are using "Create Flat File" node in some places, It was deprecated in 7.5 & we were not able to open it but the node was working. Now in 7.11, the same node is failing giving error "An error occurred in executing an Activity Class". I jsut did not want to touch the existing working parts so can anyone guide how can I fix the issue?

Thanks
Rishu

OriginalPostID-234833

  Discussion posts and replies are publicly visible

  • Could you update your process to use the OOTB Text Doc From Template smart service or the Export SQL to Flat File smart service contained in the Excel Tools plugin?
  • Hey Coltonb, Thanks for update. We don't want to change the existing processes as we may have to update a lot of process models in that case. I was wondering if can fix the issue in this node only.
  • I looked into Logs & I am getting the following error:
    2016-09-14 21:00:51,559 [default-threads - 7] ERROR com.appiancorp.ra.workpoller.WorkItemListener - The following exception occurred while attempting to complete work item [(WorkId: 299, WorkType: {Process Id:536871455,Point Id:536874220} Activity Metadata:{Id:536874220,ACPs:{ActivityClassParameter[name=Document_Name,it=3,v=Taxlot Query 16003 -9/14/2016 5:00 PM EDT],ActivityClassParameter[name=Document_Description,it=3,v=],ActivityClassParameter[name=Target_Folder,it=12,v=31414],ActivityClassParameter[name=Delimiter,it=3,v=,],ActivityClassParameter[name=Include_Headers,it=26,v=0],ActivityClassParameter[name=col1,it=103,v={Property Num,5539}],ActivityClassParameter[name=col2,it=103,v={Taxlot Record,00000009798}],ActivityClassParameter[name=col3,it=103,v={CUSIP,345370860}],ActivityClassParameter[name=col4,it=103,v={Asset Short Name,FORD MTR CO DEL}],ActivityClassParameter[name=col5,it=103,v={Shares Par Value,1167.000}],ActivityClassParameter[name=col6,it=103,v={Tax Cost,$28,911.56}],ActivityClassParameter[name=col7,it=103,v={Acq Date,1/1/1992}],ActivityClassParameter[name=col8,it=103,v={Current Price,$25.00}],ActivityClassParameter[name=col9,it=103,v={Bartholomew Cook (InKind) (InKind) Shares,1167}],ActivityClassParameter[name=col10,it=103,v={Tax Cost,$28,911.56}],ActivityClassParameter[name=col11,it=103,v={ , }],ActivityClassParameter[name=col12,it=103,v={ , }],ActivityClassParameter[name=col13,it=103,v={ , }],ActivityClassParameter[name=col14,it=103,v={ , }],ActivityClassParameter[name=col15,it=103,v={ , }],ActivityClassParameter[name=col16,it=103,v={ , }],ActivityClassParameter[name=col17,it=103,v={ , }],ActivityClassParameter[name=col18,it=103,v={ , }],ActivityClassParameter[name=col19,it=103,v={ , }],ActivityClassParameter[name=col20,it=103,v={ , }],ActivityClassParameter[name=col21,it=103,v={ , }],ActivityClassParameter[name=col22,it=103,v={ , }],ActivityClassParameter[name=col23,it=103,v={ , }],ActivityClassParameter[name=col24,it=103,v={ , }],ActivityClassParameter[name=col25,it=103,v={ , }],ActivityClassParameter[name=col26,it=103,v={ , }],ActivityClassParameter[name=col27,it=103,v={ , }],ActivityClassParameter[name=col28,it=103,v={ , }]},ARVs:{ActivityReturnVariable[name=New_Flat_File,it=13,v=<null>]}}, Response: null, ServerName: ProcessExec02)] - Exception:
    javax.resource.spi.work.WorkCompletedException: java.lang.RuntimeException: java.lang.NoClassDefFoundError: com/csvreader/CsvWriter
              at org.jboss.jca.core.workmanager.WorkWrapper.run(WorkWrapper.java:224)
              at org.jboss.threads.SimpleDirectExecutor.execute(SimpleDirectExecutor.java:33)
              at org.jboss.threads.QueueExecutor.runTask(QueueExecutor.java:808)
              at org.jboss.threads.QueueExecutor.access$100(QueueExecutor.java:45)
              at org.jboss.threads.QueueExecutor$Worker.run(QueueExecutor.java:849)
              at java.lang.Thread.run(Thread.java:745)
              at org.jboss.threads.JBossThread.run(JBossThread.java:122)
    Caused by: javax.ejb.EJBException: java.lang.RuntimeException: java.lang.NoClassDefFoundError: com/csvreader/CsvWriter
              at org.jboss.as.ejb3.tx.BMTInterceptor.handleException(BMTInterceptor.java:87)
              at org.jboss.as.ejb3.tx.EjbBMTInterceptor.checkStatelessDone(EjbBMTInterceptor.java:92)
              at org.jboss.as.ejb3.tx.EjbBMTInterceptor.handleInvocation(EjbBMTInterceptor.java:107)
              at org.jboss.as.ejb3.tx.BMTInterceptor.processInvocation(BMTInterceptor.java:60)
              at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
              at org.jboss.invocation.InitialInterceptor.processInvocation(InitialInterceptor.java:21)
              at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
              at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
              at org.jboss.as.ee.component.interceptors.ComponentDispatcherInterceptor.processInvocation(ComponentDispatcherInterceptor.java:53)
              at org.jboss.invocation.InterceptorContext.proceed(InterceptorContext.java:288)
              at org.jboss.as.ejb
  •           at org.jboss.invocation.ChainedInterceptor.processInvocation(ChainedInterceptor.java:61)
              at org.jboss.as.ee.component.ProxyInvocationHandler.invoke(ProxyInvocationHandler.java:73)
              at com.appiancorp.ra.workpoller.UnattendedRequestListener$$$view2.onMessage(Unknown Source)
              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 org.jboss.as.ejb3.inflow.MessageEndpointInvocationHandler.doInvoke(MessageEndpointInvocationHandler.java:140)
              at org.jboss.as.ejb3.inflow.AbstractInvocationHandler.invoke(AbstractInvocationHandler.java:73)
              at com.sun.proxy.$Proxy513.onMessage(Unknown Source)
              at com.appiancorp.ra.workpoller.WorkItem.run(WorkItem.java:54)
              at org.jboss.jca.core.workmanager.WorkWrapper.run(WorkWrapper.java:218)
              ... 6 more
    Caused by: java.lang.RuntimeException: java.lang.NoClassDefFoundError: com/csvreader/CsvWriter
              ... 50 more
    Caused by: java.lang.NoClassDefFoundError: com/csvreader/CsvWriter
  • This issue has been fixed. There was another jar file That was needed to be moved from old library to new library.