Closed
EWS Integration: SyncState truncated
Hi,
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.
Issues:
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?
thank you
Andrea
Posted: 6 years ago
JPMorgan Chase & Company
JPMorgan Chase & Company
US
Hi,
It seems the error is not related to the sync date truncation, could you please share what is sync date value and log file analysis.
Posted: 6 years ago
Updated: 6 years ago
Updated: 2 Mar 2018 2:59 EST
Accenture SPA
Accenture SPA
IT
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:
Show More
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:
|
Show Less
Posted: 6 years ago
Accenture SPA
Accenture SPA
IT
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.
thanks for the help
Kind Regards
Andrea