SQL Anywhere database replication - Problem with dbremote in Windows.

Author

Problem with dbremote in Windows.

Christian

2005-04-09, 8:24 pm

Hi

I`m trying to replicate between ASE in Solaris(consolidated
)
and ASA in WIndows(remote database)
when I execute
dbremote -c " eng=field;dbn=field;
uid=DBA;pwd=SQL"
and erase the message and doesn`t apply the message
this is the result:

I. 04/08 11:47:45. iAnywhere Solutions, Inc., One Sybase
Drive, Dublin, CA 94568, USA
I. 04/08 11:47:45.
I. 04/08 11:47:45. Received message from "hq_user"
(0-0000000000-0000000808-0)
I. 04/08 11:47:45. Received message from "hq_user"
(0-0000000808-0000000808-0)
I. 04/08 11:47:45. Scanning logs starting at offset
0000396708
I. 04/08 11:47:45. Processing transaction logs from
directory "C:\"
I. 04/08 11:47:45. Processing transactions from active
transaction log
I. 04/08 11:47:45. Sending message to "field_user"
(0-0000396708-0000396708-0)
I. 04/08 11:47:46. Execution completed

THANKS FOR YOUR HELP

Reg Domaratzki \(iAnywhere Solutions\)

2005-04-11, 9:23 am

Please always post the version and build number of ASA you are using.

This output is a little confusing. If this is the remote database, I would
have expected that it was receiving messages from "hq_user" and also sending
messages to "hq_user". Can you run dbunload -n on the remote database and
post the generated reload.sql to the forum?

--
Reg Domaratzki, Sybase iAnywhere Solutions
Sybase Certified Professional - Sybase ASA Developer Version 8
Please reply only to the newsgroup

iAnywhere Developer Community : http://www.ianywhere.com/developer
iAnywhere Documentation : http://www.ianywhere.com/developer/product_manuals
ASA Patches and EBFs : http://downloads.sybase.com/swx/sdmain.stm
-> Choose SQL Anywhere Studio
-> Set "Platform Preview" and "Time Frame" to ALL

<Christian> wrote in message news:4256be6d.78d5.1681692777@sybase.com...
> Hi
>
> I`m trying to replicate between ASE in Solaris(consolidated
)
> and ASA in WIndows(remote database)
> when I execute
> dbremote -c " eng=field;dbn=field;
uid=DBA;pwd=SQL"
> and erase the message and doesn`t apply the message
> this is the result:
>
>
> I. 04/08 11:47:45. iAnywhere Solutions, Inc., One Sybase
> Drive, Dublin, CA 94568, USA
> I. 04/08 11:47:45.
> I. 04/08 11:47:45. Received message from "hq_user"
> (0-0000000000-0000000808-0)
> I. 04/08 11:47:45. Received message from "hq_user"
> (0-0000000808-0000000808-0)
> I. 04/08 11:47:45. Scanning logs starting at offset
> 0000396708
> I. 04/08 11:47:45. Processing transaction logs from
> directory "C:\"
> I. 04/08 11:47:45. Processing transactions from active
> transaction log
> I. 04/08 11:47:45. Sending message to "field_user"
> (0-0000396708-0000396708-0)
> I. 04/08 11:47:46. Execution completed
>
>
> THANKS FOR YOUR HELP

Nick Elson

2005-04-21, 8:23 pm

This seems to be a lost posting.

If no one has responded yet (or if you no longer
care about the answer, then for the other readers
of this posting), this indicates you are just seeing

- the startup 'zero' message being applied
> I. 04/08 11:47:45. Received message from "hq_user"
> (0-0000000000-0000000808-0)
as seen by the '0-0000000000-<n1>-0' pattern

- followed by a 'handshake'/'status update' message
> I. 04/08 11:47:45. Received message from "hq_user"
> (0-0000000808-0000000808-0)
as seen by the '0-<n1>-<n2>-0' pattern **with <n1>=<n2>**

This much is a perfectly normal result. In fact you should
have also seen the same pattern (with a different, probably
higher, value for <n1> ) in the ssremote output as well. In
fact you see a 'handshake'/'status update' message being
sent in this section

> I. 04/08 11:47:45. Sending message to "field_user"
> (0-0000396708-0000396708-0)

where <n1> = 0000396708 = <n2>, so the second message
may just be this one.

So from that, it would appear that the only things missing
are actual transactions to be replicate; which would need
to match the following requirements:

- some DML operations have been executed **AND
committed**

- those operations affect tables that are identified as
being part of a publication [see articles]

- those match any 'where-clause' criteria in the article

- they have a remote/consolidated user subscribing to the
publication [namely 'hq_user']

- each DML operations generates 'subscribe-by' expressions
[due to the article] that matches the remote's/consolidated's
user ' subscription-value' in the start 'subscription' statement
[for 'hq_user']

and

- those operations are not hidden inside of triggers (unless also
using the -t switch), they have been issued after the articles have
been added and the subscriptions to those are started, and the
messages generated are able to be picked up from the correct
directory by the ssremote process

HTH

<Christian> wrote in message news:4256be6d.78d5.1681692777@sybase.com...
> Hi
>
> I`m trying to replicate between ASE in Solaris(consolidated
)
> and ASA in WIndows(remote database)
> when I execute
> dbremote -c " eng=field;dbn=field;
uid=DBA;pwd=SQL"
> and erase the message and doesn`t apply the message
> this is the result:
>
>
> I. 04/08 11:47:45. iAnywhere Solutions, Inc., One Sybase
> Drive, Dublin, CA 94568, USA
> I. 04/08 11:47:45.
> I. 04/08 11:47:45. Received message from "hq_user"
> (0-0000000000-0000000808-0)
> I. 04/08 11:47:45. Received message from "hq_user"
> (0-0000000808-0000000808-0)
> I. 04/08 11:47:45. Scanning logs starting at offset
> 0000396708
> I. 04/08 11:47:45. Processing transaction logs from
> directory "C:\"
> I. 04/08 11:47:45. Processing transactions from active
> transaction log
> I. 04/08 11:47:45. Sending message to "field_user"
> (0-0000396708-0000396708-0)
> I. 04/08 11:47:46. Execution completed
>
>
> THANKS FOR YOUR HELP

Sponsored Links