Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Not Answered
Replies
6 replies
Subscribers
5 subscribers
Views
1801 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
Create Flat File on 7.11
rishub
over 7 years ago
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
0
Colton Beck
over 7 years ago
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?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub
over 7 years ago
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.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub
over 7 years ago
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
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub
over 7 years ago
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
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
rishub
over 7 years ago
This issue has been fixed. There was another jar file That was needed to be moved from old library to new library.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
Colton Beck
over 7 years ago
Thanks for following up about the solution!
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel