Export SQL to excel:

sandeepg138 over 8 years ago

Hello, I am experiencing the below error when using smart service Export SQL to EXCEl:
The following error was raised by the Export to Excel function: D:\\Appian\\_admin\\accdocs1\\12973\\1009999.xlsx (The system cannot find the file specified).

Can you please let us know what could be the issue.

Regards,
Sandeep.

Discussion posts and replies are publicly visible

0 sandeepg138 over 8 years ago

Basically the issue is, first time it is generating document from the base template, but 2nd time the template used is the output of the first time.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 TJ over 8 years ago

@sandeepg138 Can you check if the name of the output variable is same as that of base template?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sandeepg138 over 8 years ago

Yes it is same.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 TJ over 8 years ago

Sandeep can u plz try by keeping different names for output and base template?
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 TJ over 8 years ago

By the above I mean create two variables. I hope this works out.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 Tim
Certified Lead Developer
over 8 years ago

Is this from the Excel Tooks plugin? Are you writing to an empty folder in Appian? I have seen issues in the plugin if the folder you are saving to does not have any other files in it. Try uploading another file to that folder in Appian the restart or retry your failed node.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 sandeepg138 over 8 years ago

Hi Tim,

I tried using two seperate pv, but that also invain.
Yes, it is Excel tools plugin, and the folder to which we are writing is not empty, and have other doucments.
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel
0 kdimitrov over 7 years ago

Hi all,

We're facing the same issue as the above, has anyone found a good way to resolve this?

Thanks,
Krassimir
Cancel
Vote Up 0 Vote Down

Sign in to reply

Verify Answer

Cancel