Sync failed due to unexpected behavior on the client side

[jeb54321 11]

I won't claim I did an exhaustive seach, but I did read a lot of notes that turned up when I searched for the above error message.

 

The one thing I noticed was that everyone that got the error seemed to have a different root cause and solution, and mine didn't seem to be consistent with any of them.

 

So perhaps someone could tell me what this means.  I'm running 4.4.2.4912 (156554) on 32-bit Windows XP.

 

I think this might be the relevant line, but I haven't a clue how it could have gotten in to this state, nor how to fix it:

08:58:28 [6360] 0% Synchronizing 1 note08:58:28 [6360] 0% Updating local note "UCD.pdf"...table expunged_items has 4 columns but 3 values were supplied

I don't share notes with anyone.  I used Evernote from another computer I have, and found the note that included the PDF attachment and deleted it.  I looked for it on the machine that is failing, but it doesn't exist there.

 

I believe I was using Evernote to make the PDF available on several machines.  I have a feeling I created it on another machine, but on this one it fails. 

 

The machine it works on (64-bit Windows 7) is version 5.1.2.2387.

 

Any suggestions appreciated.

08:58:27 [6360] 0% Connecting to www.evernote.com08:58:27 [6360] 0% * loaded updateCount: 360508:58:27 [6360] 0% Synchronizing ads08:58:27 [6360] 0% Reporting 20 ads, language: "en"08:58:27 [6360] 0% * clientProperty: [client]=[EvernoteWindows]08:58:27 [6360] 0% * ad id=774, impression time=0 count=008:58:27 [6360] 0% * ad id=577, impression time=0 count=008:58:27 [6360] 0% * ad id=578, impression time=0 count=008:58:27 [6360] 0% * ad id=749, impression time=0 count=008:58:27 [6360] 0% * ad id=634, impression time=0 count=008:58:27 [6360] 0% * ad id=735, impression time=0 count=008:58:27 [6360] 0% * ad id=782, impression time=0 count=008:58:27 [6360] 0% * ad id=576, impression time=0 count=008:58:27 [6360] 0% * ad id=752, impression time=0 count=008:58:27 [6360] 0% * ad id=756, impression time=120 count=108:58:27 [6360] 0% * ad id=758, impression time=0 count=008:58:27 [6360] 0% * ad id=687, impression time=120 count=108:58:27 [6360] 0% * ad id=628, impression time=0 count=008:58:27 [6360] 0% * ad id=754, impression time=0 count=008:58:27 [6360] 0% * ad id=720, impression time=0 count=008:58:27 [6360] 0% * ad id=751, impression time=0 count=008:58:27 [6360] 0% * ad id=777, impression time=0 count=008:58:27 [6360] 0% * ad id=759, impression time=0 count=008:58:27 [6360] 0% * ad id=738, impression time=120 count=108:58:27 [6360] 0% * ad id=703, impression time=0 count=008:58:28 [6360] 0% Retrieving 15 ads08:58:28 [6360] 0% * ad id=803 size=(125x125) advertiserName="Evernote Market" imageUrl="https://www.evernote.com/prom/img/803" image/png 12.8KB destinationUrl="https://www.evernote.com/prom/click?i=803&u=9880383&a=evernote%20windows&v=156554" displaySeconds=120 score=99.704096 openInTrunk=008:58:28 [6360] 7% * ad id=815 size=(125x125) advertiserName="Evernote Market" imageUrl="https://www.evernote.com/prom/img/815" image/png 12.5KB destinationUrl="https://www.evernote.com/prom/click?i=815&u=9880383&a=evernote%20windows&v=156554" displaySeconds=120 score=93.791768 openInTrunk=008:58:28 [6360] 13% * ad id=810 size=(125x125) advertiserName="Evernote Market" imageUrl="https://www.evernote.com/prom/img/810" image/png 12.5KB destinationUrl="https://www.evernote.com/prom/click?i=810&u=9880383&a=evernote%20windows&v=156554" displaySeconds=120 score=84.455593 openInTrunk=008:58:28 [6360] 20% * ad id=811 size=(125x125) advertiserName="Evernote Market" imageUrl="https://www.evernote.com/prom/img/811" image/png 12.1KB destinationUrl="https://www.evernote.com/prom/click?i=811&u=9880383&a=evernote%20windows&v=156554" displaySeconds=120 score=79.801350 openInTrunk=008:58:28 [6360] 27% * ad id=807 size=(125x125) advertiserName="Evernote Market" imageUrl="https://www.evernote.com/prom/img/807" image/png 17.5KB destinationUrl="https://www.evernote.com/prom/click?i=807&u=9880383&a=evernote%20windows&v=156554" displaySeconds=120 score=74.440671 openInTrunk=008:58:28 [6360] 33% * ad id=806 size=(125x125) advertiserName="Evernote Market" imageUrl="https://www.evernote.com/prom/img/806" image/png 14.2KB destinationUrl="https://www.evernote.com/prom/click?i=806&u=9880383&a=evernote%20windows&v=156554" displaySeconds=120 score=70.429549 openInTrunk=008:58:28 [6360] 40% * ad id=812 size=(125x125) advertiserName="Evernote Market" imageUrl="https://www.evernote.com/prom/img/812" image/png 13.3KB destinationUrl="https://www.evernote.com/prom/click?i=812&u=9880383&a=evernote%20windows&v=156554" displaySeconds=120 score=62.978410 openInTrunk=008:58:28 [6360] 47% * ad id=813 size=(125x125) advertiserName="Evernote Market" imageUrl="https://www.evernote.com/prom/img/813" image/png 12.3KB destinationUrl="https://www.evernote.com/prom/click?i=813&u=9880383&a=evernote%20windows&v=156554" displaySeconds=120 score=50.999783 openInTrunk=008:58:28 [6360] 53% * ad id=809 size=(125x125) advertiserName="Evernote Market" imageUrl="https://www.evernote.com/prom/img/809" image/png 15.4KB destinationUrl="https://www.evernote.com/prom/click?i=809&u=9880383&a=evernote%20windows&v=156554" displaySeconds=120 score=44.107918 openInTrunk=008:58:28 [6360] 60% * ad id=634 size=(125x125) advertiserName="Evernote" imageUrl="https://www.evernote.com/prom/img/634" image/jpeg 17.1KB destinationUrl="https://www.evernote.com/prom/click?i=634&u=9880383&a=evernote%20windows&v=156554" displaySeconds=120 score=43.023348 openInTrunk=008:58:28 [6360] 67% * ad id=808 size=(125x125) advertiserName="Evernote Market" imageUrl="https://www.evernote.com/prom/img/808" image/png 16.7KB destinationUrl="https://www.evernote.com/prom/click?i=808&u=9880383&a=evernote%20windows&v=156554" displaySeconds=120 score=42.021588 openInTrunk=008:58:28 [6360] 73% * ad id=720 size=(125x125) advertiserName="EvernoteBusiness" imageUrl="https://www.evernote.com/prom/img/720" image/jpeg 10.3KB destinationUrl="https://www.evernote.com/prom/click?i=720&u=9880383&a=evernote%20windows&v=156554" displaySeconds=120 score=39.754394 openInTrunk=008:58:28 [6360] 80% * ad id=814 size=(125x125) advertiserName="Evernote Market" imageUrl="https://www.evernote.com/prom/img/814" image/png 11.8KB destinationUrl="https://www.evernote.com/prom/click?i=814&u=9880383&a=evernote%20windows&v=156554" displaySeconds=120 score=14.348020 openInTrunk=008:58:28 [6360] 87% * ad id=805 size=(125x125) advertiserName="Evernote Market" imageUrl="https://www.evernote.com/prom/img/805" image/png 12.6KB destinationUrl="https://www.evernote.com/prom/click?i=805&u=9880383&a=evernote%20windows&v=156554" displaySeconds=120 score=10.881187 openInTrunk=008:58:28 [6360] 93% * ad id=804 size=(125x125) advertiserName="Evernote Market" imageUrl="https://www.evernote.com/prom/img/804" image/png 13.3KB destinationUrl="https://www.evernote.com/prom/click?i=804&u=9880383&a=evernote%20windows&v=156554" displaySeconds=120 score=6.836917 openInTrunk=008:58:28 [6360] Commit failed: code=00000102, ITEM_NOT_FOUND, error: "Database exception: CantGetStatement "INSERT INTO expunged_items SELECT guid, type, ? FROM items WHERE uid = ? AND guid NOT NULL AND type IN (1,2,4,5,6)", error: table expunged_items has 4 columns but 3 values were supplied"08:58:28 [6360] 100% Can't commit transaction, error: ITEM_NOT_FOUND (Database exception: CantGetStatement "INSERT INTO expunged_items SELECT guid, type, ? FROM items WHERE uid = ? AND guid NOT NULL AND type IN (1,2,4,5,6)", error: table expunged_items has 4 columns but 3 values were supplied)08:58:28 [6360] 0% * loaded 1 sync chunks, updateCount=360708:58:28 [6360] 0% Client updateCount=3605, server updateCount=360708:58:28 [6360] 0% Retrieving list of changes from the server08:58:28 [6360] 0% * saved 1 sync chunks, updateCount=360708:58:28 [6360] 0% Synchronizing 1 note08:58:28 [6360] 0% Updating local note "UCD.pdf"08:58:28 [6360] 0% * guid={0CBA3A6E-3011-46A1-ACE0-87DB593FC0CF}08:58:28 [6360] 0% * Retrieving note content, length=30308:58:28 [6360] 0% * guid={0cba3a6e-3011-46a1-ace0-87db593fc0cf}08:58:28 [6360] 0% * Creating local resource "557a9358104ab16412d5aef62feaf7ed"08:58:28 [6360] 0% * rsrc={3786A6A1-E581-47AA-9124-DA571BFBA44E}, note={0cba3a6e-3011-46a1-ace0-87db593fc0cf}08:58:28 [6360] 0% * Retrieving resource data, size=4490808:58:28 [6360] 0% * rsrc={3786a6a1-e581-47aa-9124-da571bfba44e}, note={0cba3a6e-3011-46a1-ace0-87db593fc0cf}08:58:29 [6360] Commit failed: code=00000102, ATTR_NOT_FOUND, error: "Database exception: CantGetStatement "INSERT INTO expunged_items SELECT guid, type, ? FROM items WHERE uid = ? AND guid NOT NULL AND type IN (1,2,4,5,6)", error: table expunged_items has 4 columns but 3 values were supplied"08:58:29 [6360] 100% SyncException: Error: Can't commit transaction, error: ATTR_NOT_FOUND (Database exception: CantGetStatement "INSERT INTO expunged_items SELECT guid, type, ? FROM items WHERE uid = ? AND guid NOT NULL AND type IN (1,2,4,5,6)", error: table expunged_items has 4 columns but 3 values were supplied)08:58:29 [6360] 100% Session terminated abnormally, elapsed time: 1s08:58:29 [6360] 100% * sent: 1.1KB, received: 252KB08:58:29 [6360] 100% * 2s (100%) spent in EDAM RPC

[jefito 5,598]

You should definitely open a support request for this; see the link in my signature. They'll want to have a copy of the log info that you posted here.

[jeb54321 11]

Thanks!  Ticket #373520 submitted.

[notyetagm 5]

This error is driving me nuts!

 

It only happens for me under Windows 8.1. At work I have Windows 7 SP 1 and Sync works fine.

[Gaburk 0]

I come across the same problem. I think I deleted the note that is the culprit (also from trash) wich means I can now not "unshare" it. I probabely "shared" it when I tried to send it by mail. But my account at work (groupwise) does not work with EN.  I have reinstalled, rebootet etc.

Nothing helps. I can sync from the Iphone to online but not from my Desktop (Windows) to any of my devices - however changes I made on the Iphone have been synced to the desktop. I worked for ours yesterday on my desktop to reorganize all my notes..... Have 450 notes and 25 Notebooks now.

What can I do?????

[aceyin 0]

i got the same error, any progress made on this problem ??

[Gaburk 0]

To: Aceyin

Not yet! I am in contact with the support team. They are really trying to help - but so far nothing has worked.

[Eamon 0]

I'm also getting this error; on my W7 machine running version 5.2.1.3108. The W8.1 laptop (Surface Pro) also running latest version but syncs fine. The Android app on my Moto X also works fine, though it probably functions as a web client and does not really sync anyway. Frustrating.

 

I do notice that the sync failure is an inability to upload from the W7 program; notes added directly via the web client, or clipped from a browser add-on are downloaded to the W7 application during a "failed" sync.

 

 

Update: Able to isolate my problem by exporting notebooks and then deleting notebooks from app. Did not seem to matter if trash emptied or not (W7 app trash "notebook" did not sync up to servers, but this did not get flagged as an error).

 

Problem file seem to be from a website clipped via chrome or IE some time ago. The files had previously synced and were in my default folder. I recently created a new filder using the W7 app and moved the files there. That's when the problem started I guess. The locally moved versions must have become corrupted and would not sync. The previously synced versions remained in my default notebook. I trashed the files in the local notebook. Using the web client, I moved the files from the default notebook to the newly created notebook and they synced without a problem.

 

Can send a sample problem file needed. If this file is put in any non-trash notebook, then I get the sync error. Otherwise I don't.

[RayP 0]

I am having the same problem. It started (I think) with version 5.2.1.3108. 

 

Sync works if notes are entered on my mobiles devices, but not if they are entered on my desktop. Kind of frustrating because I have received limited support from Evernote - I have an open ticket #424676. Hard to believe there are so few people experiencing this.

[borientalis 3]

I recently experienced this problem as well.

 

Looking in the Activity Log (Help -> Activity Log) I found the following fragment:

 

20:27:18 [4960] 0% Updating server items

20:27:18 [4960] 0% Creating server note "Sightseeing with Free Shuttle Bus...", resource count: 2

20:27:29 [4960] 0% EDAMUserException: errorCode=DATA_REQUIRED parameter="Data.body"

20:27:29 [4960] 0% Session terminated abnormally, elapsed time: 18s

20:27:29 [4960] 0% * sent: 1.1KB, received: 141B

20:27:29 [5908] Client synchronization finished, status: failed

20:27:29 [5908] * error: Sync failed due to unexpected behavior at client side

20:27:29 [5908] * elapsed time: 18s

 

It seemed like the sync was choking on this particular note, so I exported it out as an ENEX file, then deleted it.

The sync worked fine after that.

I then imported the note back and the sync continued to be fine...

 

I suspect that the note in question was corrupted in some way (possibly embedded control characters of some sort???). Exporting to ENEX (XML) and re-importing it seemed to have fixed it.

 

Hope this helps.

[Dianne_A 1]

I did something that triggered this same error message this afternoon and came here looking for ideas.

 

Looking in the Activity Log, I found references to two notes which seemed to be causing a problem - have no idea why, as those notes were saved about 10 days ago - on the same day, coincidentally. But, I haven't had any error messages until this afternoon. Thought maybe it might be that I made several changes to a note on my iPhone, then went to the desktop to see if it had synced properly because I wanted to add more info to it on a "real keyboard". That one seemed to sync over just fine. 

 

anyway, I exported the two notes that were mentioned in the Activity Log - exported them to the desktop as ENEX files, deleted them from Evernote. Closed & reopened Evernote.

Sync worked just fine.

Imported each note back and synced after each import. Sync worked fine.

 

Don't know what was causing the problem. But, the export/import trick worked this time. 

Thanks for posting it.

[Kyle_Coder 0]

Exporting the problem notes, deleting those offending notes, syncing, importing, and resyncing worked perfectly! 

 

Thanks for the solution!

 

Kyle

[dlu 628]

FYI, "Sync failed due to unexpected behavior on the client side" is a very generic error message, so it is very likely you are running into a different problem than what someone else may post in this thread. I strongly suggest you file a ticket with Customer Support and they can get the specifics of your situation and help you out

[KPax777 0]

 

I recently experienced this problem as well.

 

Looking in the Activity Log (Help -> Activity Log) I found the following fragment:

 

 

20:27:18 [4960] 0% Creating server note "Sightseeing with Free Shuttle Bus...", resource count: 2

 

It seemed like the sync was choking on this particular note, so I exported it out as an ENEX file, then deleted it.

The sync worked fine after that.

I then imported the note back and the sync continued to be fine...

 

I suspect that the note in question was corrupted in some way (possibly embedded control characters of some sort???). Exporting to ENEX (XML) and re-importing it seemed to have fixed it.

 

Hope this helps.

 

 

Thanks so much borentalis this worked a treat! +100 Internets for you!

[fredhammersmith 58]

Same kind of problem here. I submitted a ticket, but support is closed until tomorrow, and it would be very useful for me to resolve issues today.

Here is what I got in my Activity log:

 

15:27:21 [6300] 3% EDAMUserException: errorCode=LIMIT_REACHED parameter="Notebook"
15:27:21 [4752] Client synchronization finished, status: failed
15:27:21 [4752] * error: Sync failed due to unexpected behavior at client side

 

 

A bit prior to the sync problems, I did some streamlining of my notebooks because I was getting to the limit pf synchonized notebooks (which is 250 I think). After merging multiple notebooks and deleting the emptied ones, I started getting this error message.

This is on my desktop Windows 7 station. My iPhone app and my laptop Windows 8 app are working fine.

[dremag 0]

 

I recently experienced this problem as well.

 

Looking in the Activity Log (Help -> Activity Log) I found the following fragment:

 

20:27:18 [4960] 0% Updating server items

20:27:18 [4960] 0% Creating server note "Sightseeing with Free Shuttle Bus...", resource count: 2

20:27:29 [4960] 0% EDAMUserException: errorCode=DATA_REQUIRED parameter="Data.body"

20:27:29 [4960] 0% Session terminated abnormally, elapsed time: 18s

20:27:29 [4960] 0% * sent: 1.1KB, received: 141B

20:27:29 [5908] Client synchronization finished, status: failed

20:27:29 [5908] * error: Sync failed due to unexpected behavior at client side

20:27:29 [5908] * elapsed time: 18s

 

It seemed like the sync was choking on this particular note, so I exported it out as an ENEX file, then deleted it.

The sync worked fine after that.

I then imported the note back and the sync continued to be fine...

 

I suspect that the note in question was corrupted in some way (possibly embedded control characters of some sort???). Exporting to ENEX (XML) and re-importing it seemed to have fixed it.

 

Hope this helps.

 

This worked for me. Thank you. I looked in activity log and saw that it was choking on one of my notes. I moved it to Trash and then deleted it. Now I'm good.

[Emerson Gonçalves 0]

Solved this problem by uninstalling evernote using the advanced option of Revo Uninstaller. Then installed again and synchronization started functioning normally.