Endless "Receiving upload acknowledgment" messages

[former_SQLA_member1694889]

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

[regdomaratzki]

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

[regdomaratzki]

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

[former_SQLA_member1694889]

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 ...

[regdomaratzki]

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

[jeff_albion]

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.

[former_SQLA_member1694889]

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.

[VolkerBarth]

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...

[regdomaratzki]

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...

[regdomaratzki]

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.