SQL Anywhere database replication - problem in sending message. "No log operation at offset"

Author

problem in sending message. "No log operation at offset"

Rohit

2005-12-31, 7:23 am

Dear All,

We have sql 9.0.2.3128 and we are using sql remote for replication. We have
one consolidated db and 20 client db.

at consolidated db, when we run dbremote, it gives the following message and
doesnt send the data to remote branches. receiving from the branches is
fine.

dbremote log file outputs are as follows for sending messages:

I. 12/31 12:40:00. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA
94568, USA
I. 12/31 12:40:00.
I. 12/31 12:40:00. Scanning logs starting at offset 0155021041
I. 12/31 12:40:00. Processing transaction logs from directory
"D:\APPL\OPTICS2006\"
I. 12/31 12:40:00. Processing transactions from active transaction log
E. 12/31 12:40:01. No log operation at offset of 0155021041 in the current
transaction log
E. 12/31 12:40:01. Sending messages failed
I. 12/31 12:40:02. Execution completed

Anybody has any idea about this problem solution.

thanks

regards,
Rohit Kumar
IT Manager
Kefan Optics
Kuwait.

Reg Domaratzki

2006-01-01, 11:23 am

Can you run dbtran on the active transaction log?

When you initialized your consolidated database did you enable checksums
(dbinit -s)? If so, I think you might need a more recent EBF, although I
don't have the exact build number where we fixed a log scanning problem that
dealt with checksums right now.

--
Reg Domaratzki, Sybase iAnywhere Solutions
Certified SQL Anywhere Associate
Please reply only to the newsgroup

ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL and click "GO"

"Rohit" <rohit.kumar@kefan-optics.com> wrote in message
news:43b66006@forums
-2-dub...
> Dear All,
>
> We have sql 9.0.2.3128 and we are using sql remote for replication. We
have
> one consolidated db and 20 client db.
>
> at consolidated db, when we run dbremote, it gives the following message
and
> doesnt send the data to remote branches. receiving from the branches is
> fine.
>
> dbremote log file outputs are as follows for sending messages:
>
> I. 12/31 12:40:00. iAnywhere Solutions, Inc., One Sybase Drive, Dublin, CA
> 94568, USA
> I. 12/31 12:40:00.
> I. 12/31 12:40:00. Scanning logs starting at offset 0155021041
> I. 12/31 12:40:00. Processing transaction logs from directory
> "D:\APPL\OPTICS2006\"
> I. 12/31 12:40:00. Processing transactions from active transaction log
> E. 12/31 12:40:01. No log operation at offset of 0155021041 in the current
> transaction log
> E. 12/31 12:40:01. Sending messages failed
> I. 12/31 12:40:02. Execution completed
>
> Anybody has any idea about this problem solution.
>
> thanks
>
> regards,
> Rohit Kumar
> IT Manager
> Kefan Optics
> Kuwait.
>
>

Sponsored Links