[horde] Integrity constraint violation - ActiveSync

[Helmut Schiefer]

Hello,

and thanks for the fast reply. I cut a message with the error out of  
the log, is it ok to send a 270 line log to the list or should I send  
it to an other place?

Helmut

Quoting Michael J Rubinsky <mrubinsk at horde.org>:

> 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
>
> -- 
> Horde mailing list
> Frequently Asked Questions: http://horde.org/faq/
> To unsubscribe, mail: horde-unsubscribe at lists.horde.org


-- 
Best Regards
Helmut Schiefer