I'm trying to get a very simple Mobilink setup in places. The schema consists of only a single table called 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-sort-of-namespace |
You can increase the log level (https://help.sap.com/viewer/4949f39728bd400ebee2fb94687cc74f/17.0/en-US/81c80eb86ce21014b785ab28810c99a9.html) and figure out where the error comes from. You can start with options -c or -t.
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.