Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in June and this forum will be retired.

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-sort-of-namespace

asked 07 Sep '20, 02:16

saurabhnanda's gravatar image

saurabhnanda
46121219
accept rate: 0%

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.

(07 Sep '20, 04:51) Vlad

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.

(07 Sep '20, 22:26) Chris Keating
Be the first one to answer this question!
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:

×371

question asked: 07 Sep '20, 02:16

question was seen: 611 times

last updated: 07 Sep '20, 22:26