Skip to main content
lokeshk0623
May 11, 2023
Question

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.

  • May 11, 2023
  • 4 replies
  • 5 views
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.

4 replies

stefanhelzle0001
May 11, 2023

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.

lokeshk0623
May 11, 2023

We don't have such field in databse table

lokeshk0623
May 11, 2023

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.