Hello Everyone,
Export SQL to Excel (part of the Excel Tools Plug-in) is deprecated from 19.2?
currently deployed latest version of excel tools plugin 2.2.5
on the other hand, we are getting below error while using this smart service
Appian Work Item - 7354 - execution00 : UnattendedJavaActivityRequest] ERROR com.appiancorp.process.engine.UnattendedJavaActivityRequest - An error occurred while executing activity: id=89337, classname=com.appiancorp.ps.exceltools.smartservice.export.ExportSqlToExcelv2com.appiancorp.suiteapi.process.exceptions.SmartServiceException: userMsg[error.export.general=The following error was raised by the Export to Excel function: null]
Discussion posts and replies are publicly visible
Is there any alternate solution to replace the "Export CDT to excel" and "Export sql to excel".
this is very urgent,Production has been messed up.
You should use this one as the alternative
Hope that helps and gives you a fast conversion
Thnank you ChristineH but there is constrains on this smart service like we can use only 50 column( appian recomemded) in and in our report columns are more. if you have any other suggesation would be great help.
could you please help me here.
If the data set is timing out, have you tried using this one and breaking it up to put on different sheets?
https://docs.appian.com/suite/help/19.3/Export_Multiple_DSEs_to_Excel.html
Then if the user needs it on one sheet, have a sheet that runs a macro to consolidate. Just a thought...