Process states- Error writing mail to the database, that's what am receiving while running this smart service on the process model, not sure what configuration changes are required.Log states- ERROR com.appiancs.msgraphmail.MSGraphDBHandler - Error writing mail to database java.sql.SQLSyntaxErrorException: (conn=642804) Unknown column 'DOC_ID_NO_ATT' in 'field list'Can anyone help us here.we are using MS Graph Mail Poller smart node to get emails from outlook, but getting the above error, we had already go microsoft azure connection setup.
Discussion posts and replies are publicly visible
Did you check that your database table contains the field "DOC_ID_NO_ATT". This is a concrete hint in the error message and I wonder whether you checked that before posting here.
We don't have such field in databse table
got it, there are several fields that were not available in the sample application provided by Appian in the plugin, am trying to run and get the field's name from the log and add them to the table.
and also, when you try to deal with attachments in emails, make sure you execute the below queries, to remove the error : (this will remove the error you receiving while executing the process)ALTER TABLE `APP_MAIL_POLLER` ADD COLUMN BODY_SWAPPED_IMAGES longtext AFTER SYS_DATE;ALTER TABLE `APP_MAIL_POLLER_DOC` ADD COLUMN IS_INLINE TINYINT(1) AFTER SYS_DATE;