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
3 replies
Subscribers
5 subscribers
Views
1571 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
can someone help me with some details explanation for using the export cdt to ex
georgec890
over 8 years ago
can someone help me with some details explanation for using the export cdt to excel task?(Export SQL and Report Data to EXCEL - V2/ com.appiancorp.analytics.excel_exportv2-3.1.jar). It doesn't work and I think I;m not filling correctly the fields. Also is possible to be a problem because I use DB2 and the plugin was tested only on oracle and MySQL.
Thanks in advance,
George
OriginalPostID-166795
OriginalPostID-166795
Discussion posts and replies are publicly visible
0
abhi.jana
Appian Employee
over 8 years ago
What errors do you see in the UI and in the application server log? If you're pulling data from DB2 to a CDT array, you may need to check that the CDT array is being populated correctly prior to the export.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
georgec890
over 8 years ago
In the UI doen't give me any error, if I look at the alerts the message is:
Problem: An error occurred in executing an Activity Class.
Recommended Action: Examine the activity class to correct the error and then resume.
Priority of this problem: High Priority
I found in the log's something like this: [9/14/15 9:09:02:655 GMT+02:00] 000002d4 SystemOut O 2015-09-14 09:09:02,655 [WebContainer : 7] ERROR com.appiancorp.analytics.excel_export.ExportCdtToExcel - The input fields does not match the fields in the CDT
Probably you are right.
What I do in my process:
1. I habe a script task that get's the cdt data in a process variable.
2. I configure export and ad as a cdt the process variable.
For what I saw in the process variable the array is ok.
Can you explain to me, what I should do?
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
0
georgec890
over 8 years ago
I found the error. It was seeing my array of fields that I wanted to extract as a text. I putted a wrong comma.
Thanks a lot for the help.
The plugin works great also for DB2.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel