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 |
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 |
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
That would come as a total surprise to me, as it is a v17 feature, see the v17 documentation on "What's New / MobiLink"...
(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! See Reg's answer above:
So in my understanding you can sync with HANA with the regular dbmlsync tool.
(21 Oct '16, 02:01)
Volker Barth
|
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.
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.