View Issue Details

IDProjectCategoryView StatusLast Update
0004641SOGoBackend Calendarpublic2019-02-19 18:22 Assigned To 
PriorityhighSeveritymajorReproducibilityunable to reproduce
Status newResolutionopen 
Platform[Server] LinuxOSRHEL/CentOSOS Version7
Product Version4.0.5 
Summary0004641: Error during sync between Outlook 2016/CalDavSynchronizer 3.40 and SOGo 4.05

Hello there,

as said above, we have a CentOS7 Server, SOGo 4.05 with MySQL 5.7.24 Backend
and Outlook2016/CalDavSynchronizer 3.40 as client. Suddendly there are
synchronisation errors with the error message in SOGo log:

"ERROR(-[GCSFolder writeContent:fromComponent:container:toName:baseVersion:])
Data too long for column 'c_uid'"

and the appointments don't get synchronized from Outlook 2016 to SOGo.
This happened suddenly without changing anything within the configuration
or adding/removing appointments in Outlook or SOGo Webclient.

Is there anything I could do, to get more information what triggers this
error or rather get rid of this error and get OL/SOGo get synchronized again?
At the moment I have no idea, what happened or what to change to get a functional
synchrnoization again. So any help is very appreciated.

Many Thanks!

Steps To Reproduce

Sorry I can't reproduce this with another account and at the moment there's only one account which has this problem, but get this error solved would be very nice.

TagsNo tags attached.


2019-01-15 09:51

reporter   ~0013259

I found a solution for the problem, but I don't know if there are
any side effects that cause other errors. The solution I found is:

The "c_uid" column in the table " sogoroberstu00201dc1fda_quick"
was of the type varchar(255) and the generated uid from Outlook
had more than 255 characters namely 541. So I changed the type
from varchar(255) to varchar(1000) and now Outlook/CalDavSynchronizer
and SOGo are synchronized without errors again.

The one question left is: Does changing the type of the column from
varchar(255) to varchar(1000) has any known side effects? Or is it
secure the change it, because I can't change the way Outlook creates
the uids, right?

Any further information is appreciated.
Many thanks.



2019-02-19 18:22

administrator   ~0013389

There shouldn't be any side effects. You should also change the c_uid one too.

Issue History

Date Modified Username Field Change
2019-01-14 16:08 New Issue
2019-01-15 09:51 Note Added: 0013259
2019-02-19 18:22 ludovic Note Added: 0013389