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
Hi Ramakrishna,
Just have a look here for the new smart services available to achieve the same job https://community.appian.com/b/appmarket/posts/excel-tools , hope it will helps you.
Hi Yash,
Thanks for your response!
I have download latest from this link https://community.appian.com/b/appmarket/posts/excel-tools and getting the same error
Don't you see some smart services listed under the Excel Tools menu entry that's *not* under "Deprecated Services"?
Hi Mike,
Yes I have seen Export SQL to Excel (part of the Excel Tools Plug-in) as deprecated after successful deployment latest plugin (exceltool-2.2.5 jar), earlier I have used 2.0.2 in which the same smart service was not deprecated.
Thanks for confirming. I had checked my 19.2 environment and saw the utilities as not deprecated, but I also noted we have an older version of the plug-in. So I believe the deprecation is related to the version of the plugin rather than 19.2 itself.
com.appiancorp.suiteapi.process.exceptions.SmartServiceException: userMsg[error.export.general=The following error was raised by the Export to Excel function: null]
This exception is not due to latest plugin this is due to OpenJDK front-configurations.
As we all aware that OpenJDK is part of 19.2 installer, we have used the same and encountered with this issue.
Fix is to install fontconfig from VM for Open JDK.
there won't be any issue with Oracle Java
Hi,
'fontconfig' has already been installed in our server and still we are getting the error [The following error was raised by the Export to Excel function: null],
Does anyone have any other suggestion on this.
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.
For us Installing fontconfig resolves the issue, may be for work around you can use oracle Java instead of Open JDK
You should use this one as the alternative
Hope that helps and gives you a fast conversion