Hello everyone,

I am having a synchronisation issue in my MobiLink project.

I updated the database schema in the consolidated database and therefore changed the Synchronization Model too. Now - for test purpose - I tied to sync the UltraLite db with Sybase Central, but that does not work anymore.

In Sybase Central the sync runs forever and is always giving the same message: "Receiving upload acknowledgment"

I changed the loglevel of MobiLink to get as much information as possible, but I see no error. The last two lines I see in the logfile when the sync does not continue are:

I. 2014-07-08 13:53:35. <1> (,SPUSA381030-1-0001) System variable last_table_download value: 1900-01-01 00:00:00.000000
I. 2014-07-08 13:53:35. <1> (,SPUSA381030-1-0001) System variable username value: SPUSA381030-1-0001

Do you have any idea how I can debug this issue further?

Thank you for your help, Alex

asked 08 Jul '14, 10:18

Alexander%20Ilg's gravatar image

Alexander Ilg
13191016
accept rate: 0%

Can you post a bit more of the verbose MobiLink Log before it seems to hang?

(08 Jul '14, 11:20) Reg Domaratzki
Comment Text Removed
1

Is it safe to assume that your symptoms have changed? The log you've attached (I'm replying here to cut down on scrolling) seems to finish, and shows the error :

E. 2014-07-08 13:54:15. <1> (,SPUSA381030-1-0001) [-10410] The client failed to send a complete sequence of commands

(09 Jul '14, 10:42) Reg Domaratzki
Replies hidden

Yes, you are right - but the error message is only coming when I cancel the sync.

After setting the log level to -v+, I get the following entry 100k times in the log:

I. 2014-07-09 10:32:49. <1> Delete row [ZODB_MATERIALS_T]:
I. 2014-07-09 10:32:49. <1>   000000070156207030
I. 2014-07-09 10:32:49. <1>   E
I. 2014-07-09 10:32:49. <1>   U
I. 2014-07-09 10:32:49. <1> Delete row [ZODB_MATERIALS_T]:
I. 2014-07-09 10:32:49. <1>   000000070156155110
I. 2014-07-09 10:32:49. <1>   D
I. 2014-07-09 10:32:49. <1>   U
I. 2014-07-09 10:32:49. <1> Delete row [ZODB_MATERIALS_T]:
I. 2014-07-09 10:32:49. <1>   000000070156155110
I. 2014-07-09 10:32:49. <1>   E
I. 2014-07-09 10:32:49. <1>   U

Does not make sense to me, as I don't understand why I have any deletes at all. The client db is completely empty and there are no entries in the _del tables on client and on the server ...

(15 Jul '14, 10:32) Alexander Ilg

Since you can't post files to the forum, can you please post the -v+ MobiLink log to the following location?

https://mdocs.sap.com:443/mcm/public/v1/open?shr=YqcyKWjXkXn-istH4x2xgxwGr2c8_Hcl0XpkRWS2waA

(15 Jul '14, 11:20) Reg Domaratzki
Replies hidden

It looks like there is a possibly a problem with the specific UltraLite database or the MobiLink protocol - we will likely need to look at further debugging switches.

If it's easily reproducible, it might be easier to provide the UltraLite database directly to us for our further testing. Do you have the UltraLite database available for us to take a look at? Is there any sensitive information contained within it from production or is it still in development and contains test data?

If you already have a support plan with SAP, it would be best to capture this information in an incident opened through the SAP Support Portal.

(15 Jul '14, 21:45) Jeff Albion

Hello Reg,

I uploaded the file. It is 3.2 GB large, zipped "only" 80 MB.

After the issue occurred, I had some successful synchronisations with another synchronization model. As written before, I canceled the sync when it was not successful, as it was running forever.

(16 Jul '14, 03:29) Alexander Ilg

FWIW, in case a question in this forum really requires to take a closer look at 3.2 GB of further information, I would think that is certainly better be handled via TechSupport...

(16 Jul '14, 04:27) Volker Barth

Aside: I deleted your large post with the verbose ML log, as the same information can be found in the file you uploaded to the SAP Mobile Docs website, and I was tired of scrolling...

(16 Jul '14, 09:58) Reg Domaratzki
showing 3 of 8 show all flat view

The download_delete_cursor for the ZODB_MATERIALS_T table executed the following SQL, which returned enough rows to write 3.2 GB of information to the MobiLink Server log, eventually causing you to cancel the synch.

SELECT "DBA"."ZODB_MATERIALS_T_del"."MATNR",
       "DBA"."ZODB_MATERIALS_T_del"."SPRAS",
       "DBA"."ZODB_MATERIALS_T_del"."UPDKZ"
  FROM "DBA"."ZODB_MATERIALS_T_del", 
       ZODB_MATERIALS_T, 
       ZODB_DEVICES, 
       ZODB_SPLUSUSER, 
       ZODB_MATERIALS
 WHERE "DBA"."ZODB_MATERIALS_T_del"."TIMESTAMP" >=  '1900-01-01 00:00:00.000000'
   AND ZODB_DEVICES.MobilinkUser =  'SPUSA381030-1-0001'
   and ZODB_SPLUSUSER.SALESPLUSUSER = ZODB_DEVICES.SalesPlusUser
   and ZODB_SPLUSUSER.VKORG = ZODB_MATERIALS.VKORG
   and ZODB_SPLUSUSER.VTWEG = ZODB_MATERIALS.VTWEG
   and ZODB_MATERIALS.MATNR = ZODB_MATERIALS_T.MATNR

Like Jeff, I'm unhappy that cancelling the synchronization results in the following error :

E. 2014-07-09 10:34:36. <1> [-10410] The client failed to send a complete sequence of commands

I would attack this problem in the following manner :

1) Figure out why 3GB of data is being returned by the SQL I posted and fix that. Are you are missing a join condition between the ZODB_MATERIALS_T and ZODB_MATERIALS_T_del table in your where clause?

2) Try your synch again. If you continue to get -10410 errors, see Jeff Albion's post about how to proceed.

permanent link

answered 16 Jul '14, 09:48

Reg%20Domaratzki's gravatar image

Reg Domaratzki
5.2k33575
accept rate: 41%

edited 16 Jul '14, 09:52

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×290
×101

question asked: 08 Jul '14, 10:18

question was seen: 1,158 times

last updated: 16 Jul '14, 09:58