we've enable calendar syncronization on Pega (Pega Platform 7.2.2 with SalesAutomation 7.22), exposed property Syncstate (SQL Server 2014 varchar(8000)) but SyncState is truncated, we tried to set varchar(MAX) but when testing database table we have the following error:
Class Data-Admin-Operator-ID is mapped to table PegaDATA.pr_operators in database PegaDATA.
This is an internal class. You may access the class with Obj- activity methods.
Warning: Class Data-Admin-Operator-ID is mapped to table pr_operators which contains both BLOB and CLOB column types. The table should only contain either CLOB or BLOB columns, not both.
can you suggest a way to avoid saving truncated syncstate on DB?
the error that i've posted is not related to SyncState. We're on Sales Automation 7.22 and Activity AppointmentsCalendarSync send a mail when there's an error while synchroning, the mail i received is like this:
for this reason i've tried to increase size for SyncState column on DB, but to increase valure i've to set column ad varchar(MAX), but then, when i save database table rule on pega, the error on my initial request is displayed.