Enterprise Replication General Error

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Richard M. - 02 Oct 2008 15:48 GMT

Hi folks,

Is it possible to replicate from one instance to another on the same
physical machine?

I created one replication server OK but I'm getting "command failed
-- General Error (-1) (-1)" when running cdr define server on the
second replication server.

Cheers

R

Reply to this Message

Keith Simmons - 02 Oct 2008 17:04 GMT

2008/10/2 Richard M. <richard@richardmoon.com>:

> Hi folks,
>
[quoted text clipped - 12 lines]
> Informix-list@iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list

Richard

I know there is a restriction on running HDR between instances on the
same machine (or at least used to be), but I do not believe there is
(or ever has been) a restriction on running ER between two co-hosted
instances. Are your services/SQL hosts files set up correctly and are
you trying to connect between the servers using TCP rather than SHM?

Keith

Reply to this Message

TBP - 02 Oct 2008 17:25 GMT

> 2008/10/2 Richard M. <richard@richardmoon.com>:
>> Hi folks,
[quoted text clipped - 23 lines]
>
> Keith

Tee hee ....

HDR can be on the same machine, just use relative as opposed to absolute paths, and start in the relevant directory which contains
the root path

However, for the above issue :

1. Version of IDS??
2. Platform (although irrelevant here really).
3. Provide your sqlhosts and also the cdr command (and also DBSERVERNAME / DBSERVERALIAS entries)

Hmmm haaa, where is my potato!

Reply to this Message

Richard M. - 02 Oct 2008 18:00 GMT

Thanks for the info guys - well here's the details

> HDR can be on the same machine, just use relative as opposed to absolute paths, and start in the relevant directory which contains
> the root path
>
> However, for the above issue :
>
> 1. Version of IDS??

10.0

> 2. Platform (although irrelevant here really).

hp-ux 11i

> 3. Provide your sqlhosts and also the cdr command (and also DBSERVERNAME / DBSERVERALIAS entries)

sqlhosts

g_rep1 group - - i=101
rep1 onsoctcp paragon3 infxrep1 g=g_rep1
g_rep2 group - - i=102
rep2 onsoctcp paragon3 infxrep2 g=g_rep2

cdr command
cdr define server -c g_rep2 -I -S g_rep1 g_rep2

cdr list server
SERVER ID STATE STATUS QUEUE CONNECTION
CHANGED
-----------------------------------------------------------------------
g_rep1 101 Active Local 0

my config file (onconfig.rep2)
DBSERVERNAME rep2 # Name of default database server
DBSERVERALIASES # List of alternate dbservernames

> Hmmm haaa, where is my potato!- Hide quoted text -

It's behind you !

Thanks

R

Reply to this Message

TBP - 02 Oct 2008 19:35 GMT

> Thanks for the info guys - well here's the details
>
[quoted text clipped - 36 lines]
>
> R

Try setting the env to g_rep2 and doing :

cdr define server -I -S g_rep1 g_rep2

Reply to this Message

Clive Eisen - 02 Oct 2008 17:35 GMT

> Hi folks,
>
> Is it possible to replicate from one instance to another on the same
> physical machine?

Yep - done it on my laptop

No doubt you friendly local ER guru will be along shortly..

--
Cilve

Reply to this Message

Madison Pruet - 02 Oct 2008 19:34 GMT

> Hi folks,
>
> Is it possible to replicate from one instance to another on the same
> physical machine?

Yes

> I created one replication server OK but I'm getting "command failed
> -- General Error (-1) (-1)" when running cdr define server on the
[quoted text clipped - 3 lines]
>
> R

I'm guessing that you aren't using 10xC9 as we recently spent a lot of
effort to eliminate -1 and 100 errors. Check the online message log.
I'd also check to ensure that the sqlhost file is correct.

Reply to this Message