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
2 replies
Subscribers
5 subscribers
Views
3605 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
Export Sql to Excel
marcoc918
A Score Level 1
over 7 years ago
Hello,
We need to geerate an excel starting from a Table on our DB.
I've downloaded and installed the last version of Excell Tools that includes the Smart Service Export Sql to Excel, but for sure I am doing something wrong because it doesent'work.
This is the error message "There is a problem with task “Export SQL to Excel” in the process “nuovaProvaExcel”. The following error was raised by the Export to Excel function: null
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 "
and this is the configuration of the Smart Service:
JNDI Name: ="java:/jdbc/PirelliOrcaleDS"
Sheet Number: 0
SQL: ="SELECT * FROM V_RM_RO_EUR"
All other field were left blank.
Can anyone suggest a solution?
Thanks
OriginalPostID-230761
Discussion posts and replies are publicly visible
Parents
0
Mike Lonsdale
over 7 years ago
Have you spelt the JNDI name correctly? You can also try looking in the application server log file for further detail
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
Mike Lonsdale
over 7 years ago
Have you spelt the JNDI name correctly? You can also try looking in the application server log file for further detail
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
No Data