SQL Anywhere Mobile - ASA 9.01.1841

Author

ASA 9.01.1841

Kevin Dunn

2005-04-19, 8:24 pm

We have a situation where some inserts are not making it to the consolidate database. What could cause some inserts to work and others to not?

Upload_Cursor

SELECT entity_id, nerc_id, parent_id, md_description, status, mod_user, mod_datetime, type_flag, nerc_description, loaded_date, source_site_id, data_source, add_user, add_datetime
FROM entity WHERE entity_id = ?

Thanks,
--
Kevin

Greg Fenton

2005-04-19, 8:24 pm

Kevin Dunn wrote:
> We have a situation where some inserts are not making it to the
> consolidate database. What could cause some inserts to work and others
> to not?
>

Try running both dbmlsync and dbmlsrv9 with "-vr" or "-v+" and output to
a log file (-o filename.out). Then search the log files to see if the
INSERT values are being uploaded at all.

Feel free to post the log files if you aren't sure about what's in
there. We'd also need to know what data was inserted that you are
hoping to see.

A couple of things that could stop the INSERTs from making it up (as
INSERTs):

- INSERT into a transaction that doesn't get COMMIT'ed
- INSERT followed by a DELETE between synchronizations (that is: SYNCH,
INSERT, DELETE, SYNCH - this would result in no row uploaded)
- DELETE followed by an INSERT between synchs (that is: SYNCH, DELETE,
INSERT, SYNCH - this would result in an UPDATE being uploaded).

>
> Upload_Cursor
>

Hmmm....upload_cursor scripts have been deprecated since 9.0.0. You
really should consider upgrading your synchronization scripts to the
script-based uploads (upload_insert, upload_update, upload_delete, etc...)

greg.fenton
--
Greg Fenton
Consultant, Solution Services, iAnywhere Solutions
--------
Visit the iAnywhere Solutions Developer Community
Whitepapers, TechDocs, Downloads
http://www.ianywhere.com/developer/

Sponsored Links