Error in Export to Excel smart service - No such file or directory

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
  • 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.
Reply
  • 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.
Children