We recently upgraded to 17.2 and noticed that the "Export SQL to Excel" Smart Service node is failing. Note, this is working as expected in our 16.3 environments and the implementation is the same.
Error messages:
Appian Alerts- There is a problem with task "Export Sql to Excel" in the process <PROCESS DISPLAY NAME>. The following error was raised by the Export to Excel function: User variable name '' is illegal
System Logs- 15:13:57,310 INFO [stdout] (Appian Work Item - 12473 - ProcessExec00 : UnattendedJavaActivityRequest) 2017-09-11 15:13:57,310 [Appian Work Item - 12473 - ProcessExec00 : UnattendedJavaActivityRequest] ERROR com.appiancorp.util.BundleUtils - Cannot retrieve the value for key "address.processDesigner.displayName" from the bundle. 15:15:06,376 INFO [stdout] (Appian Work Item - 12493 - ProcessExec00 : UnattendedJavaActivityRequest) 2017-09-11 15:15:06,376 [Appian Work Item - 12493 - ProcessExec00 : UnattendedJavaActivityRequest] ERROR com.appiancorp.util.BundleUtils - Cannot retrieve the value for key "address.processDesigner.displayName" from the bundle. 15:17:28,204 INFO [stdout] (Appian Work Item - 12565 - ProcessExec02 : UnattendedJavaActivityRequest) 2017-09-11 15:17:28,203 [Appian Work Item - 12565 - ProcessExec02 : UnattendedJavaActivityRequest] ERROR com.appiancorp.analytics.excel_export.ExportSqlToExcel - com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: User variable name '' is illegal
Discussion posts and replies are publicly visible