Hi sanikat,

I faced similar issue, in my case the column BODY_SWAPPED_IMAGES was missing in the table APP_MAIL_POLLER. You probably should check in your table. I also had problem with the column IS_INLINE missing in the table APP_MAIL_POLLER_DOC.

After run the alters on these tables it works. Perhaps they will fix this problem in a future update of the plugin.

Regards,

Acacio B. 

Acacio Barrado, thank you for your response, appreciate your help here . Yes, the DLL that came along with plugin , does not have the column "BODY_SWAPPED_IMAGES" , but do you know the datatype of BODY_SWAPPED_IMAGES columns that I need to add to APP_MAIL_POLLER.

Also, could you please share the data type of  IS_INLINE  for APP_MAIL_POLLER_DOC that made the plugin work for you?

Hi sanikat,

Below you can find the alters that we use:

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;

As for the datatypes, you can check the screenshot:

Regards,

Acacio B

Hi Acacio,

Thanks for your reply above. It works fine.

Basically, we have 4 new fields need to be added 

APP_MAIL_POLLER ( 3 fields   [DOC_ID_NO_ATT], [BODY_SWAPPED_IMAGES], [MESSAGE_GRAPH_ID]....all varchar is fine)

APP_MAIL_POLLER_DOC (IS_INLINE, datatype  tinyint(1))

Regards

Saket Kumar

Hi Acacio,

Thanks for your reply above. It works fine.

Basically, we have 4 new fields need to be added 

APP_MAIL_POLLER ( 3 fields   [DOC_ID_NO_ATT], [BODY_SWAPPED_IMAGES], [MESSAGE_GRAPH_ID]....all varchar is fine)

APP_MAIL_POLLER_DOC (IS_INLINE, datatype  tinyint(1))

Regards

Saket Kumar