on 2023 Jan 10 3:32 AM
Can somebody tell me what can be the problem in a following situation:
we are synchronizing two SQL Anywhere10 Databases using DBMLSYNC & MLSRV17 (of SQL Anywhere17). Both databases are running on the same machine, both SQL Anywhere10 & SQL Anywhere17 are installed.
For one of my tables I need to ignore the deletes from remote:
call ml_add_table_script('default', 'MYTABLE', 'upload_delete', '--{ml_ignore}');
I get the following Error:
E. 2023-01-10 09:24:09. <1> [-10002] Consolidated database server or ODBC error: ODBC: [Microsoft][ODBC Driver Manager] Invalid string or buffer length (ODBC State = HY090, Native error code = 0) E. 2023-01-10 09:24:09. <1> [-10058] Unable to open upload_delete
I tried to delete the script and reoload it, without success!
call ml_add_table_script('default', 'MYTABLE', 'upload_delete', NULL); call ml_add_table_script('default', 'MYTABLE', 'upload_delete', '--{ml_ignore}');
Of course I restartet both databases in between too!
Request clarification before answering.
The problem could only be solved in this way :
call ml_add_table_script('default', 'MYTABLE', 'upload_delete', 'call mydumy(?,?,?)');create procedure mydumy(var1 varchar(4),var2 varchar(4),var3 varchar(4)) begin message ('dummy'); end;
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Prior to v12 of the MobiLink Server, there were no requirements to define the five main synchronization scripts (upload_insert, upload_update, upload_delete, download_cursor, download_delete_cursor).
If the MobiLink Server version is 10, I suspect you can simply delete the event to ignore it, and there should be no need for the no-op stored procedure, which will add a very minimal amount of extra processing to your upload.
call ml_add_table_script('default', 'MYTABLE', 'upload_delete', NULL);
No, this is not enough. If a script for upload_delete is missed, then I get an error.
Server error: Message: There is no upload data script defined for table: MYTABLE. If you want to be able to synchronize anyway, with the risk of potentially losing upload data, use the -fr command line option. Table Name: MYTABLE
At least one of the upload scripts must exist.
User | Count |
---|---|
74 | |
30 | |
9 | |
7 | |
7 | |
6 | |
6 | |
5 | |
5 | |
5 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.