I'm getting a strange error that has just started to occur. The only indication is on the client and it just gives me a 'Protocol Error' message. I have looked at the log on the server and there is no indication of an error. The error on the client happens part way through the download stream and from what I can tell at a certain table. I have multiple users synchronizing the sames publication/script with no errors, but the error seems to be propagating to more users. The users have been syncing fine before, so I'm at a loss on what is happening. Neither the client nor server have been upgraded. This is all I get from the client log when the error occurs, nothing from the server. The server reports a successful sync.
|
I can't see anything in the verbose log that helps me sort out what the issue is. My instinct is that the problem is related to the actual data that is being downloaded. For the remotes that are failing, if you add -v+ to the dbmlsync log, are they all failing with a protocol error when downloading the pda_order_notes table? I. 2014-12-12 15:36:20. Downloading into table: pda_orders_notes E. 2014-12-12 15:36:20. Protocol error I. 2014-12-12 15:36:20. Download stream processing failed I. 2014-12-12 15:36:20. ROLLBACK If it's always the same table, I'd consider adding some extra verbosity to the MobiLink Server (-v+) to see the data that is being downloaded to the remotes that are failing, and trying to see if there is a pattern to the specific rows that are being downloaded in this table for remotes that are failing versus remotes that successfully synchronize. |
The "protocol error" message means that one side (in this case dbmlsync) doesn't understand what the other side (the MobiLink server) sent it over the network. Some possible causes:
If different remotes get different data, an experiment would be to change a working remote (or copy of a working one) to get the same data as one of the failing ones, or vice versa. That would test #2. Update: If the problem occurs after a failed download, it could be issue 650719 (the build number below refers to 11.0.1, and is newer than your version): ================(Build #2546 - Engineering Case #650719)================
|
I have everything working now. We use a table to store deletes in and the protocol error was coming from the download delete operation. I found a row that seemed to be the culprit and deleted it. After doing that the remotes synced successfully, so that's my story and I'm sticking to it. I'm used to having good error messages from Mobilink, so this one just threw me for a loop. Another note is that the apparent offending row was not in the table that immediately preceded the error. I started removing tables from the publication and the error would just happen after the next table in line. Thanks for everybody's help! |
Can you please post the full log from client?
What version and build is the MobiLink Server?
11.0.1.2755
If this same remote database synchronizes again, will they get another protocol error over and over again, or is it intermittent?
It is consistent with the remote database. It is affecting 5 remotes out of 40.
I copied over a fresh remote database and still got the error.
Your software is over five years old, and I have a memory of NULL values embedded in long binaries causing issues, but I think that was way back in v8 or v9, and not v1101.
If the problem is reproducible on 5 remotes over and over again, it's possible that running dbmlsyn with the -vx+ switch will show us some more information on exactly what's going on. There will be data in that log, so feel free to contact me by email (firstname.lastname@sap.com) if you don't want to post it to a public forum.
Just wanted to note here that I sent over a zipped log file from the client on Friday.