Mobilink Synchronization Issue

[Former Member]

Hi Experts.

I am trying to synchronize my local database but I keep on getting an error whenever the upload phase is ongoing. I tried to synchronize using a network mobilink server and using my local computer as a personal mobilink server but still get the same results. Below are logs from both the network mobilink synchronization and personal mobilink server synch.

Network Mobilink Server

I. 2018-06-21 18:45:26. Begin synchronizing subscription(s) 'PUB_MOSIS_MASTER'
I. 2018-06-21 18:45:26. Log scan starting at offset 0001672351
I. 2018-06-21 18:45:26. Transaction log "C:/Users/mendojua/Documents/Eclipse Oxygen/SMAv8.0/db/mosis.log" starts at offset 0001667948
I. 2018-06-21 18:45:26. Processing transaction logs from directory "C:/Users/mendojua/Documents/Eclipse Oxygen/SMAv8.0/db/"
I. 2018-06-21 18:45:26. Processing transactions from active transaction log
I. 2018-06-21 18:45:26. Transaction log renamed to: C:\Users\mendojua\Documents\Eclipse Oxygen\SMAv8.0\db\180621AD.LOG
I. 2018-06-21 18:45:26. Transaction log "C:/Users/mendojua/Documents/Eclipse Oxygen/SMAv8.0/db/mosis.log" starts at offset 0001698006
I. 2018-06-21 18:45:26. Processing transaction logs from directory "C:/Users/mendojua/Documents/Eclipse Oxygen/SMAv8.0/db/"
I. 2018-06-21 18:45:26. Transaction log "C:/Users/mendojua/Documents/Eclipse Oxygen/SMAv8.0/db/180621AD.LOG" starts at offset 0001667948
I. 2018-06-21 18:45:26. Current timeline GUID: ee179349-a81c-4fa6-939d-ab8de08dcdd2
I. 2018-06-21 18:45:26. Current timeline UTC creation time: 2018-05-09 09:34:11.737000+00:00
I. 2018-06-21 18:45:26. Current transaction log GUID: 00000000-0000-0000-0000-000000000000
I. 2018-06-21 18:45:26. Processing transactions from transaction log "C:/Users/mendojua/Documents/Eclipse Oxygen/SMAv8.0/db/180621AD.LOG"
I. 2018-06-21 18:45:26. Transaction log ends at offset 0001698006
I. 2018-06-21 18:45:26. Processing transactions from active transaction log
I. 2018-06-21 18:45:26. Hovering at end of active log
I. 2018-06-21 18:45:26. Log scan ended at offset 0001697943
I. 2018-06-21 18:45:26. Cycle of foreign key references found. Cannot guarantee referential integrity during upload.
I. 2018-06-21 18:45:26. Tables involved in cycle:
I. 2018-06-21 18:45:26.     MOSI.R061_LOGICAL_RULE
I. 2018-06-21 18:45:26. Connecting to MobiLink server at 'host=bdc-intra414.na.pg.com;port=2458' using 'TCPIP'
I. 2018-06-21 18:45:27. Begin upload
I. 2018-06-21 18:45:27. Negotiating communication protocol with MobiLink server.
E. 2018-06-21 18:47:28. Unable to read 0 bytes.
E. 2018-06-21 18:47:28. A communication error occurred while sending data to the MobiLink server
E. 2018-06-21 18:47:28. Unspecified communication error
I. 2018-06-21 18:47:28. End synchronizing subscription(s) 'PUB_MOSIS_MASTER'
I. 2018-06-21 18:47:28. Disconnecting from MobiLink server
I. 2018-06-21 18:47:28. Complete log scan required.
I. 2018-06-21 18:47:28. Synchronization completed
I. 2018-06-21 18:47:28. Disconnecting from remote database

Personal Mobilink Server

I. 2018-07-04 18:50:50. Begin synchronizing subscription(s) 'PUB_MOSIS_MASTER'
I. 2018-07-04 18:50:50. Log scan starting at offset 0001708013
I. 2018-07-04 18:50:51. Transaction log "C:/Users/mendojua/Documents/Eclipse Oxygen/SMAv8.0/db/mosis.log" starts at offset 0001698006
I. 2018-07-04 18:50:51. Processing transaction logs from directory "C:/Users/mendojua/Documents/Eclipse Oxygen/SMAv8.0/db/"
I. 2018-07-04 18:50:51. Processing transactions from active transaction log
I. 2018-07-04 18:50:51. Transaction log renamed to: C:\Users\mendojua\Documents\Eclipse Oxygen\SMAv8.0\db\180704AA.LOG
I. 2018-07-04 18:50:51. Transaction log "C:/Users/mendojua/Documents/Eclipse Oxygen/SMAv8.0/db/mosis.log" starts at offset 0001733668
I. 2018-07-04 18:50:51. Processing transaction logs from directory "C:/Users/mendojua/Documents/Eclipse Oxygen/SMAv8.0/db/"
I. 2018-07-04 18:50:51. Transaction log "C:/Users/mendojua/Documents/Eclipse Oxygen/SMAv8.0/db/180704AA.LOG" starts at offset 0001698006
I. 2018-07-04 18:50:51. Current timeline GUID: ee179349-a81c-4fa6-939d-ab8de08dcdd2
I. 2018-07-04 18:50:51. Current timeline UTC creation time: 2018-05-09 09:34:11.737000+00:00
I. 2018-07-04 18:50:51. Current transaction log GUID: 00000000-0000-0000-0000-000000000000
I. 2018-07-04 18:50:51. Processing transactions from transaction log "C:/Users/mendojua/Documents/Eclipse Oxygen/SMAv8.0/db/180704AA.LOG"
I. 2018-07-04 18:50:51. Transaction log ends at offset 0001733668
I. 2018-07-04 18:50:51. Processing transactions from active transaction log
I. 2018-07-04 18:50:51. Hovering at end of active log
I. 2018-07-04 18:50:51. Log scan ended at offset 0001733605
I. 2018-07-04 18:50:51. Cycle of foreign key references found. Cannot guarantee referential integrity during upload.
I. 2018-07-04 18:50:51. Tables involved in cycle:
I. 2018-07-04 18:50:51.     MOSI.R061_LOGICAL_RULE
I. 2018-07-04 18:50:51. Connecting to MobiLink server at 'host=localhost;port=2639' using 'TCPIP'
I. 2018-07-04 18:50:51. Begin upload
I. 2018-07-04 18:50:51. Negotiating communication protocol with MobiLink server.
E. 2018-07-04 18:50:51. Unable to read 0 bytes.
I. 2018-07-04 18:50:51. End synchronizing subscription(s) 'PUB_MOSIS_MASTER'
I. 2018-07-04 18:50:51. Disconnecting from MobiLink server
I. 2018-07-04 18:50:52. Complete log scan required.
I. 2018-07-04 18:50:52. Synchronization completed
I. 2018-07-04 18:50:52. Disconnecting from remote database

Please advise as this has been a big roadblock recently

Thanks,

Pau

[former_member182948]

Could you provide the logs of the mobilink server side?

[Former Member]

Hi Koichi.

Any advise where I can locate these as I pointed it on my local machine and can't find the server logs.

[former_member182948]

If you specified the -o option with the mlsrv17 command, the mobilink server log file in there.
If there is no such option, the mobilink server message is not saved in the file.

For more details,
"MobiLink server logging"
http://dcx.sap.com/index.html#sqla170/en/html/81cd6e506ce21014a965d1b5bd3d637e.html

[Former Member]

I was not able to add that. But on a side note, is this script enough to run a synchronization?

-c "ENG=MosisQA;DBF=db\mosis.db;UID=mosiapps;PWD=womchild02" -v -o db\log\sync_master.log -q -k -e "adr='host=localhost;port=2639';sv=9.0.0" -n PUB_MOSIS_MASTER -x

[former_member182948]

I think that you are mistaking the mobilink client for the mobilink server.
The example you showed looks like a script on the client side.
It can be inferred from the options you have chosen.

Please see the available options.

"mlsrv17 syntax"
http://dcx.sap.com/index.html#sqla170/en/html/81c951cb6ce21014887280d342d9494d.html "

"MobiLink SQL Anywhere client utility (dbmlsync) syntax" http://dcx.sap.com/index.html#sqla170/en/html/81ab9d146ce21014ae3bf49a7a2aa923.html

Publication can be specified on the client side only.

Best regards,

[Former Member]

So does that mean my Mobilink Client cannot serve as the Mobilink server all in one? Just for testing?

[former_member182948]

They are different applications.(Mobilink Server & Mobilink clients)
And Mobilink Synchronization requires both applications.
You need to change the option (-o option) of server side(mlsrv17) for get the server log.

[chris_keating]

No. A client cannot act as a server and a server cannot act as a client.

[Former Member]

Meaning to say we have to secure 2 different licenses of SQL Anywhere? Cuz I only saw the SQL Anywhere 17 client installer but saw no SLQ A17 server edition...

[chris_keating]

For development (including), you can get the developer edition. This gives you access to the use the software with out licensing for development related tasks. When you are ready to deploy, you will need to acquire licensing to meet your deployment needs.

This is my understanding of the licensing requirements for MobiLink (but you should confirm with a sales rep as they are better equiped to answer license questions. Yuou will need a license to run MobiLink server. If you are running SQL Anywhere as a consolidated, an additional license for that may be needed. You will also need 1 sync client license for each remote in the environment. The "SAP SQL Anywhere, Edge Edition, workgroup version (5 named users)" license will allow you to deploy Mobilink server and have up to 5 remote users. If you require additional remotes, you can buy multiple units of that license or buy addition sync clients. Minimally, you will need a 5 user or core license.

[VolkerBarth]

Note, you can certainly have one single machine that acts both as ML server and as ML client, so that requires only one license. Still, ML server and ML client are different applications, but as said, they can run on the same machine:

1. The ML server can connect to a consolidated database which is hosted on the same or a different machine.
2. The ML client will use usually use a local database as its "remote" database.