[horde] Integrity constraint violation - ActiveSync

[Michael J Rubinsky]

Quoting Helmut Schiefer <Helmut at 4Schiefer.de>:

> Dear List,
>
> now I disable and enable the Samsung Phone, I also enable Active  
> Sync Debug in the file to get a more detailed information about the  
> error.
>
> The phone starts with a new sync request. I also see a lot of  
> entries which are sent to the phone. After some time the sync stops  
> with the error message:
>
> 2012-01-21T17:17:33+01:00 NOTICE: [SAMSUNG1358533041817568] Error  
> saving state for synckey {4f1ac83e-08ac-494a-9df1-749f0a86010a}3:  
> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate  
> entry '{4f1ac83e-08ac-494a-9df1-749f0a86010a}3' for key 'PRIMARY' -  
> removing previous sync state and trying again.

This happens whenever the server completes it's part of the operation,  
but for some reason the device doesn't accept the data. This could be  
due to a number of reasons, including problems with the data Horde is  
sending (improper encoding, incorrect date format etc...).

The next step would be to find out what messages  
(event/contact/whatever) were being sent to the device immediately  
before this error is received. Provide the detailed log output of  
those messages and we can go from there.


> Before I start the test I did a few task to ensure a current and  
> stable version:
> 1) I dit a pear upgrade-all
> 2) I export the calendar with hore export, after that I delete the calendar.
> 3) I logged out from horde and login again
> 4) I did a fresh import of the ics file to the calendar and I after  
> that I start the sync process
>
> Any Idea what I can do to find the problem?
>
> Helmut
>
>
> Quoting Michael J Rubinsky <mrubinsk at horde.org>:
>
>> Quoting Helmut Schiefer <Helmut at 4Schiefer.de>:
>>
>>> Dear List,
>>>
>>> I'm not sure if I post my message to the right list. If not then  
>>> please give me a hint to right list.
>>>
>>> I activated active sync on my horde portal (highest stable  
>>> release), it worked well for IPAD and IPhone.
>>>
>>> Today I try to connect the smartphone of my wife and active sync  
>>> runs into an error. It was possible to sync all contact data but  
>>> it crashes during calendar synchronization.
>>>
>>> I got the following error:
>>> 2012-01-03T15:08:49+01:00 NOTICE: [SAMSUNG1358533041817568] Error  
>>> saving state for synckey {4f030b32-ce00-4079-b669-09450a86010a}15:  
>>> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate  
>>> entry '{4f030b32-ce00-4079-b669-09450a86010a}15' for key 'PRIMARY'  
>>> - removing previous sync state and trying again.
>>>
>>> I figure out the event in kronolith and I delete them. After that  
>>> I do the next try and I got the following message:
>>> 2012-01-03T15:29:47+01:00 NOTICE: [SAMSUNG1358533041817568] Error  
>>> saving state for synckey {4f030b32-ce00-4079-b669-09450a86010a}15:  
>>> SQLSTATE[23000]: Integrity constraint violation: 1062 Duplicate  
>>> entry '{4f030b32-ce00-4079-b669-09450a86010a}15' for key 'PRIMARY'  
>>> - removing previous sync state and trying again.
>>>
>>> So I think it isn't a problem of the event date.
>>>
>>> I do the initial sync of that the device, nothing there before.
>>> SmartPhone: Samsung Galaxy ACE.
>>>
>>> Any I idea what I can do to find the problem?
>>
>> To start with, make sure you enable the custom synclog on the  
>> ActiveSync admin page. Remove the account from the device and try  
>> again after enabling the device logging. There is most likely an  
>> error with something in some of your events that AS is not handling  
>> correctly. See http://wiki.horde.org/ActiveSync for more  
>> ideas/instructions.
>>
>>
>> -- 
>> mike
>>
>> The Horde Project (www.horde.org)
>> mrubinsk at horde.org
>
>
> -- 
> Best Regards
> Helmut Schiefer
>
>
> -- 
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org


-- 
mike

The Horde Project (www.horde.org)
mrubinsk at horde.org