The forum will experience an outage sometime between February 10 at 7:00pm EST and February 12 at 11:59 EST for installation of security updates. The actual time and duration of the outage are unknown but attempts will be made to minimize the downtime. We apologize for any inconvenience.

Hi,

I am following this link to synchronize SQL Anywhere Table with HANA Table on HCP - https://help.hana.ondemand.com/help/frameset.htm?920d7738db534786986d7919170855e3.html

In Step 2, It talks about activating Auditing. I can not see that tab when I go to properties of the DB.

At the last step, when I try to run the Synchronization Profile, I get an error message

java.sql.SQLException: [SAP][ODBC Driver][SQL Anywhere]Feature 'SYNCHRONIZE' not implemented

I created a new SQL Anywhere Database 17 and a table for this activity.

Thanks, Murali

asked 12 Jun '16, 21:28

Murali's gravatar image

Murali
68137
accept rate: 50%

edited 13 Jun '16, 03:42

Volker%20Barth's gravatar image

Volker Barth
29.3k287438645

2

Murali, I modified the tags - "SQL Remote" is a different replication technology only used between SA databases whereas you seem to be using the new v17 SAP HANA Remote Data Sync facility based on MobiLink.

That being said, I can't tell whether that should work with a ARM/Raspberry PI remote, in case that is the same platform as used with your other FAQ.

(13 Jun '16, 02:49) Volker Barth

Step 2 is an error - it is not a feature that synchronization uses. However, the error that you do see is odd. That error suggests that you are connected to an old database without support for that statement but if you are following the instructions, I would not expect the profile to be created on an older database.

  1. Can you post the output from SELECT * FROM SYSHISTORY.
  2. What is the version and build of SA you are testing
  3. What edition are you running? DEVELOPER, EVALUATION (that will be displayed in the engine console message area (and in the -o file if used) and below the message area.
(13 Jun '16, 09:57) Chris Keating

The SYNCHRONIZE command in the database engine is built on top of support for "external stored procedures". If you want to use the built-in SYNCHRONIZE command, you'll need to confirm at http://scn.sap.com/docs/DOC-65219 that the platform where the MobiLink client exists has support in the engine for the "external stored procedures" and "MobiLink client for SQL Anywhere".

If Volker's comment is correct and you are using Raspberry Pi (i.e. Linux ARM), then "MobiLink client for SQL Anywhere" is supported, but "external stored procedure" is not.

You will still be able to use the "MobiLink client for SQL Anywhere" (i.e. dbmlsync) on Raspberry Pi and synchronize data to/from a MobiLink Server, but you won't be able to use the built-in SYNCHRONIZE command in the database engine to initiate the synchronization.

Reg

permanent link

answered 13 Jun '16, 09:39

Reg%20Domaratzki's gravatar image

Reg Domaratzki
4.8k33269
accept rate: 41%

Thanks Volker. I just heard that Remote Data Sync may not be compatible with SQL Anywhere 17. I will try to downgrade to 16 and repeat the same. Thanks

permanent link

answered 13 Jun '16, 03:32

Murali's gravatar image

Murali
68137
accept rate: 50%

Remote Data Sync may not be compatible with SQL Anywhere 17

That would come as a total surprise to me, as it is a v17 feature, see the v17 documentation on "What's New / MobiLink"...

Support for SAP HANA consolidated databases

Previous releases of MobiLink supported SAP HANA consolidated databases. Now, to synchronize SQL Anywhere clients with an SAP HANA consolidated database, use SAP HANA remote data sync. All features except for server-initiated synchronization and the arbiter are supported (the HANA Platform has its own tools for high availability).

(13 Jun '16, 03:57) Volker Barth

Hi, I'm getting the same error message:

java.sql.SQLException: [SAP][ODBC Driver][SQL Anywhere]Feature 'SYNCHRONIZE' not implemented

I've installed sqlanywhere version 16 and 17 both on a Raspberry Pi. For both I created a database and started the two servers. Then I created a table to sync with HANA. HANA is already configured to run with sqlanywhere and syncs with sqlanywhere on a x86_64 machine.

Now the real question: will sqlanywhere for ARM processors never be able to sync with HANA or did I forget something?

Thank you very much for your answers!

permanent link

answered 20 Oct '16, 12:37

EricScheid's gravatar image

EricScheid
11
accept rate: 0%

See Reg's answer above:

You will still be able to use the "MobiLink client for SQL Anywhere" (i.e. dbmlsync) on Raspberry Pi and synchronize data to/from a MobiLink Server, but you won't be able to use the built-in SYNCHRONIZE command in the database engine to initiate the synchronization.

So in my understanding you can sync with HANA with the regular dbmlsync tool.

(21 Oct '16, 02:01) Volker Barth
Your answer
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:

×266
×64
×4
×1

question asked: 12 Jun '16, 21:28

question was seen: 273 times

last updated: 21 Oct '16, 02:03