Mobilink > Syntax error during sync

[former_SQLA_member1694904]

I'm trying to get a very simple Mobilink setup in places. The schema consists of only a single table called tasks. When I run the dbmlsync command on the remote server, I get the following error message. How do I get to the bottom of following error message: Server error: Message: ODBC: [SAP][ODBC Driver][SQL Anywhere]Syntax error near '(end of line)' on line 1 (ODBC State = 42000, Native error code = -131). Table Name: tasks ? Exactly which script has this error? I do not recall tweaking any SQL scripts that are automatically installed by Mobilink, so I am unsure how this error came about.

I. 2020-09-07 06:10:43. SQL Anywhere MobiLink Client Version 17.0.10.6089
I. 2020-09-07 06:10:43. 
I. 2020-09-07 06:10:43. Copyright © 2020 SAP SE or an SAP affiliate company.
I. 2020-09-07 06:10:43. All rights reserved.
I. 2020-09-07 06:10:43. Use of this software is governed by the SAP Software Use Rights Agreement.
I. 2020-09-07 06:10:43. Refer to http://www.sap.com/about/agreements.html.
I. 2020-09-07 06:10:43. 
I. 2020-09-07 06:10:43. Running Windows 2016 Build 17763  on X86_64
I. 2020-09-07 06:10:43. Executable built for X86_64 processor architecture
I. 2020-09-07 06:10:43. 
I. 2020-09-07 06:10:44. Begin synchronizing subscription(s) 'v1_remote'
I. 2020-09-07 06:10:44. Log scan starting at offset 0000701029
I. 2020-09-07 06:10:44. Transaction log "C:/Users/Administrator/Desktop/master.log" starts at offset 0000695801
I. 2020-09-07 06:10:44. Processing transaction logs from directory "C:/Users/Administrator/Desktop/"
I. 2020-09-07 06:10:44. Processing transactions from active transaction log
I. 2020-09-07 06:10:44. Hovering at end of active log
I. 2020-09-07 06:10:44. Log scan ended at offset 0000701332
I. 2020-09-07 06:10:44. Connecting to MobiLink server at 'host=[REDACTED];port=2439' using 'TCPIP'
I. 2020-09-07 06:10:44. Begin upload
I. 2020-09-07 06:10:44. Uploading table operations
I. 2020-09-07 06:10:44. Waiting for MobiLink to apply upload
I. 2020-09-07 06:10:44. The user authentication value is 1000.
I. 2020-09-07 06:10:44. COMMIT
E. 2020-09-07 06:10:44. Error code from MobiLink server: -10002
E. 2020-09-07 06:10:44. Server error: Message: ODBC: [SAP][ODBC Driver][SQL Anywhere]Syntax error near '(end of line)' on line 1  (ODBC State = 42000, Native error code = -131).  Table Name: tasks
E. 2020-09-07 06:10:44. Error code from MobiLink server: -10002
E. 2020-09-07 06:10:44. Server error: Message: ODBC: [SAP][ODBC Driver][SQL Anywhere]Syntax error near '(end of line)' on line 1  (ODBC State = 42000, Native error code = -131).  Table Name: tasks
I. 2020-09-07 06:10:44. End synchronizing subscription(s) 'v1_remote'
I. 2020-09-07 06:10:44. Disconnecting from MobiLink server
I. 2020-09-07 06:10:44. Synchronization completed

PS: This is a follow-up from https://sqlanywhere-forum.sap.com/questions/35929/mobilink-remote-databases-tables-seem-be-in-some-s...

[Vlad]

You can increase the log level (https://help.sap.com/viewer/4949f39728bd400ebee2fb94687cc74f/17.0/en-US/81c80eb86ce21014b785ab28810c... and figure out where the error comes from. You can start with options -c or -t.

[chris_keating]

Minimally, you should run with -vt so that the translated SQL (the SQL that is actually sent to the consolidated is displayed. It appears that you have a syntax error in one of your scripts.