Appian Community
Site
Search
Sign In/Register
Site
Search
User
DISCUSS
LEARN
SUCCESS
SUPPORT
Documentation
AppMarket
More
Cancel
I'm looking for ...
State
Suggested Answer
Replies
13 replies
Answers
1 answer
Subscribers
7 subscribers
Views
12412 views
Users
0 members are here
Share
More
Cancel
Related Discussions
Home
»
Discussions
»
Plug-Ins
Error in Export to Excel smart service - No such file or directory
Jaggu
over 7 years ago
Hi,
I am using Export SQL to Excel node and I am getting below error in one of the environment
'There is a problem with task “Export SQL to Excel” in the process “APP_Scheduled Extract”. The following error was raised by the Export to Excel function: java.io.IOException: No such file or directory'.
The same model is working fine in environment 1 and not working in environment 2. Both environments are on premise and both have same version of plugin.
Could you please let me know what is causing the issue here.
OriginalPostID-258562
Discussion posts and replies are publicly visible
Parents
0
subramanian Valliappan
Certified Lead Developer
over 7 years ago
We have run the smart service in the context of the designer (The user who started the process is system admin as well)
The folder provided in the "Document_save_directory" is hard coded to a folder in the environment.
Document_to_overwrite and excel_base_template are left blank as they are not required.
The same process gets executed successfully in a different environment, only in prod env we are facing this issue.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Reply
0
subramanian Valliappan
Certified Lead Developer
over 7 years ago
We have run the smart service in the context of the designer (The user who started the process is system admin as well)
The folder provided in the "Document_save_directory" is hard coded to a folder in the environment.
Document_to_overwrite and excel_base_template are left blank as they are not required.
The same process gets executed successfully in a different environment, only in prod env we are facing this issue.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel
Children
0
chandu
A Score Level 2
over 6 years ago
in reply to
subramanian Valliappan
Hi, Can you try to edit the instance and remap the folder " "Document_save_directory". save the instance and try to execute once again. It is suggested to use a constant instead of hard coding.
Cancel
Vote Up
0
Vote Down
Sign in to reply
Verify Answer
Cancel