Export SQL to Flat File

Question

Hi all, I am using "Export SQL to Flat File": node completed successfully but it doesn't generate any output document, maybe I'm configuring something wrong. I passed all the required field to "Export SQL to Flat File" as attached. Is there anything I'm missing ?
Thanks for your help!

Durgesh · Answer

Make sure to use actual table name instead CDT name

Richard · Answer

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:

<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