[SAP][ODBC Driver][SQL Anywhere]Feature 'SYNCHRONIZE' not implemented

[Former Member]

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

[VolkerBarth]

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.

[chris_keating]

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.

[regdomaratzki]

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

[Former Member]

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!

[VolkerBarth]

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.

[Former Member]

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

[VolkerBarth]

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).