Home > Archive > SQL Anywhere database replication > July 2005 > Remote db will not increment resend count









You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

 

Author Remote db will not increment resend count
mary

2005-07-06, 8:23 pm

Hello all,
I am running ASA7.0.4. with SMTP SQL Remote Messaging.

I have a remote database that has been giving me an error when trying
to apply messages from the consolidated. Specifically the fun message I
receive while it is in the middle of applying messages is:
"SQL statement failed: (-301) Internal database error *** ERROR ***
Assertion failed: 101412 (7.0.2.1402)
Page number on page does not match page requested --
transaction rolled back
E. 06/30 22:02:41. SQL statement failed: (-301) Internal database error
-- transaction rolled back
E. 06/30 22:02:41. Error connecting to database"


What I would like to do, since this remote has a lot of data that I
need to get to the consolidated db, is to put the remote db in a "send
only" mode where it just sends all its updates/changes to the Cons db.
Then with all the data in one place, I could recreate the remote db. I
have changed the remote message configuration parameters to have the -s
parameter.

My problem now is that the consolidated response to all the messages it
receives from this site is "Not applying operations with old resend
count." The messages it is receiving from the site is:
(2-0025234657-0) through (2-0025234657-1000).

>From what I have read, what I believe should happen is the remote

should try to send this again, but the next time with a 3 prefix - such
as:
(3-0025234657-0) through (3-0025234657-1000).

The remote db never increments its resend count though. And the
consolidated continues to report the "Not applying operations with old
resend count."

Is there anyway I can force the remote db to increment this? Is there
another better way I can go about saving the remote data?

Thanks in Advance -
Mary

Sponsored Links





Also available: Server administration forum archive | Web Design forum archive | Software forum archive | Hardware reviews archive | Programming forum archive

Copyright 2008 droptable.com