SQL Anywhere Mobile - -828 error

Author

-828 error

Donna Osburn

2005-08-23, 8:25 pm

when i put the following command in that hook (along with
existing code
update hhcategorycd set flkeep = 0
it barfs on an ASA -828 error which is.
A conflict with the DBMLSync download phase was detected

My issue is this - have two publications. I need to do
first pub, then modify/delete some data, then do second pub.
The data being modified/deleted will be synced in second
pub. Because of a sequencing issue, i cannot make the
changes before the first pub. However, this -828 error is
throwing me for a loop.
Any ideas?

i think the conflict is that the HHCategoryCD table is in
the next publication to be synced. Is there any way around
this?

> Donna Osburn wrote in
> news:430b447f.1018.1681692777@sybase.com:
>
> consolidated stored procedure.
>
>
> You are looking for Synchronization hooks which are
> executed on the remote database.
> sp_hook_dbmlsync_upl
oad_end is called at the end of the
> upload phase.
>
> Shuchit

Greg Fenton

2005-08-24, 3:24 am

Donna Osburn wrote:
> when i put the following command in that hook (along with
> existing code
> update hhcategorycd set flkeep = 0
> it barfs on an ASA -828 error which is.
> A conflict with the DBMLSync download phase was detected
>

This indicates that you are modifying a row in the remote database that
is also being downloaded in the download stream. If this error wasn't
thrown, then the download stream would clobber the change you have made
to this row (note: the problem is that you have modified a row *in
between* the time that the upload phase was built and the download phase
was received...and that row is about to be clobbered in the download
stream. It is a good thing you caught this prior to going into
production!!)

Which sp_hook_dbmlsync stored proc did you choose to write your code in?
If you did in in the _upload_end one, then this error is quite likely.
You probably want to put your code into sp_hook_dbmlsync_end
or
possibly _download_end.

Hope this helps,
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