cancel
Showing results for 
Search instead for 
Did you mean: 

Mobilink 17 cant resolve --{ml_ignore}

Baron
Participant
0 Kudos
830

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!

Accepted Solutions (1)

Accepted Solutions (1)

Baron
Participant
0 Kudos

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;

regdomaratzki
Product and Topic Expert
Product and Topic Expert
0 Kudos

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);
Baron
Participant
0 Kudos

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.

Answers (0)