Export SQL to Flat File

I'm having the same problem. Initially the problem was with the naming convention for the JDBC connection.

Ultimately I'm still having the issue, however it's only with the new Document folder that I've created for the application that needs this. If I test with an older folder this works. Will check log files and post more.

As a result of further testing, this is the issue that I've received:

<Jan 9, 2019 7:04:18,062 PM GMT> <Notice> <Stdout> <BEA-000000> <2019-01-09 19:04:18,061 [Appian Work Item - 7699 - ProcessExec02 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.exceltools.smartservice.export.ExportSqlToFlatFile - java.nio.file.NoSuchFileException: /appian/_admin/accdocs3/11776/10002708.csv
java.lang.Exception: java.nio.file.NoSuchFileException: /appian/_admin/accdocs3/11776/10002708.csv

I'm not sure if this is an issue with our development server, however I was able to work around the problem by using a "Create Text Doc from Template" node to create a file and then use the resulting file in the "document to overwrite" parameter of the Export SQL smart service.

Having some issues with extensions, but this seems to work

I'm having the same problem. Initially the problem was with the naming convention for the JDBC connection.

Ultimately I'm still having the issue, however it's only with the new Document folder that I've created for the application that needs this. If I test with an older folder this works. Will check log files and post more.

As a result of further testing, this is the issue that I've received:

<Jan 9, 2019 7:04:18,062 PM GMT> <Notice> <Stdout> <BEA-000000> <2019-01-09 19:04:18,061 [Appian Work Item - 7699 - ProcessExec02 : UnattendedJavaActivityRequest] ERROR com.appiancorp.ps.exceltools.smartservice.export.ExportSqlToFlatFile - java.nio.file.NoSuchFileException: /appian/_admin/accdocs3/11776/10002708.csv
java.lang.Exception: java.nio.file.NoSuchFileException: /appian/_admin/accdocs3/11776/10002708.csv

I'm not sure if this is an issue with our development server, however I was able to work around the problem by using a "Create Text Doc from Template" node to create a file and then use the resulting file in the "document to overwrite" parameter of the Export SQL smart service.

Having some issues with extensions, but this seems to work