ER template realization problem
Posted in 2010
Topics: High Availability & Replication, Server Administration, Platform-Specific Issues
Hello,
We had to update some tables for an application. So I stopped concerned
replicate sets and delete templates. We updated tables, I recreated templates
and I tried to realize them but it fails. On the failing tables the update
consist to add two date columns
Summary of environment :
OS Name / Release Linux / 2.6.24-26-server
System memory 7995 MB
System free memory 4800 MB
IBM Informix 11.50.FC4
Here is the trace of commands I did :
# cdr define template templateName -C ignore -M masterName -S row -d dbName
table1 table2
Obtaining dictionary for dbName@masterName:'informix'.table1
Obtaining dictionary for dbName@masterName:'informix'.table2
Creating mastered replicate replicateName1 for table 'informix'.table1
Creating mastered replicate replicateName2 for table 'informix'.table2
# cdr realize template templateName dbName@adec
Verification of dbName@masterName:'informix'.table1 started
Verification of dbName@masterName:'informix'.table1 failed
command failed -- table does not exist (29)
But table1 exists and I can perform requests on it with dbaccess.
Does anybody have an idea about how to solve this problem?
Thank you for your help
Is it owned bed by 'informix' on both servers?
Art
Art S. Kagel
Advanced DataTools (www.advancedatatools.com)
IIUG Board of Directors (art@iiug.org)
See you at the 2010 IIUG Informix Conference
April 25-28, 2010
Overland Park (Kansas City), KS
www.iiug.org/conf
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Advanced DataTools, the IIUG, nor any other
organization with which I am associated either explicitly, implicitly, or by
inference. Neither do those opinions reflect those of other individuals
affiliated with any entity with which I am affiliated nor those of the
entities themselves.
On Tue, Feb 16, 2010 at 5:43 AM, JEAN-MICHEL RAMSEYER <
jm.ramseyer@greenivory.com> wrote:
> Hello,
>
> We had to update some tables for an application. So I stopped concerned
> replicate sets and delete templates. We updated tables, I recreated
> templates
> and I tried to realize them but it fails. On the failing tables the update
> consist to add two date columns
>
> Summary of environment :
> OS Name / Release Linux / 2.6.24-26-server
> System memory 7995 MB
> System free memory 4800 MB
> IBM Informix 11.50.FC4
>
> Here is the trace of commands I did :
> # cdr define template templateName -C ignore -M masterName -S row -d dbName
> table1 table2
> Obtaining dictionary for dbName@masterName:'informix'.table1
> Obtaining dictionary for dbName@masterName:'informix'.table2
> Creating mastered replicate replicateName1 for table 'informix'.table1
> Creating mastered replicate replicateName2 for table 'informix'.table2
> # cdr realize template templateName dbName@adec
> Verification of dbName@masterName:'informix'.table1 started
> Verification of dbName@masterName:'informix'.table1 failed
> command failed -- table does not exist (29)
>
> But table1 exists and I can perform requests on it with dbaccess.
> Does anybody have an idea about how to solve this problem?
> Thank you for your help
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--00151747b67e04ddc9047fb5c6d5
Yes on both servers the owner is informix, and user informix has the same privileges too