Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Column Info Not Found Error

6 posts in Replication Agent Last posting was on 2003-09-17 20:11:52.0Z
Shriek Posted on 2003-09-15 19:22:07.0Z
Sender: 21df.3f660ffe.1804289383@sybase.com
From: Shriek
Newsgroups: sybase.public.rep-agent
Subject: Column Info Not Found Error
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f66115f.21f5.846930886@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 15 Sep 2003 12:22:07 -0700
X-Trace: forums-1-dub 1063653727 10.22.241.41 (15 Sep 2003 12:22:07 -0700)
X-Original-Trace: 15 Sep 2003 12:22:07 -0700, 10.22.241.41
Lines: 31
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:622
Article PK: 862276

Hello All,

I am a newbie to replication. I have setup a replication
environment from oracle to oracle. The rep agent and the dco
are up and running and so are the DSI on the rep server
side.

I marked a sample table for replication, stopped and
restarted the rao and hit <resume> <go>, the rao went to the
admin state and had this seemingly simple message:

W. 2003/09/15 11:53:11.96. com.sybase.ra.lti.RSSDFormatter
COLUMN_INFO_NOT_FOUND
E. 2003/09/15 11:53:11.96. com.sybase.ra.lti.LTI No columns
for table <EMP> were found in the RSSD.

I ran into some trouble previously with case and hence named
all tables, subscriptions and rep defs in CAPS only.

I checked the rs_columsn in the rssd database and it seems
to contain the correct columns as well.

Is there anyway i can trace out the query being sent to the
RSSD. Please explain if possible.

Please help.

Thanks in advance,

Regards,
Shriek


Wanda Beck Posted on 2003-09-15 21:14:53.0Z
From: "Wanda Beck" <wbeck@sybase.com>
Newsgroups: sybase.public.rep-agent
References: <3f66115f.21f5.846930886@sybase.com>
Subject: Re: Column Info Not Found Error
Lines: 71
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: wbeckw2k.sybase.com
X-Original-NNTP-Posting-Host: wbeckw2k.sybase.com
Message-ID: <3f662bcd$1@forums-1-dub>
Date: 15 Sep 2003 14:14:53 -0700
X-Trace: forums-1-dub 1063660493 157.133.80.197 (15 Sep 2003 14:14:53 -0700)
X-Original-Trace: 15 Sep 2003 14:14:53 -0700, wbeckw2k.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:623
Article PK: 862275

Hi, Shriek,

The RepAgent property ltl_character_case governs how the RepAgent treats
identifiers (table AND column names). The default value is "as_is", which
means that identifiers coming from Oracle will remain upper case. If you
want identifiers to be converted to lower case before being passed to
RepServer, set the value to "lower":

ra_config ltl_character_case, lower

If you want to keep identifiers in upper case, are the column names in your
repdef also in upper case?

If you want to see the queries RepAgent is using against the RSSD, turn on
tracing
trace all, true
After you resume, look in your $SYBASE/rax-12_5/<instance>/log/trace.log for
the SQL. This is the query to get all the repdefs:

RACONTRCSQL WBECKW2K 2003/08/05 09:49:27.66 wbeck
com.sybase.ra.conn.RAConnection LTI Thread select rs_databases.dsname,
rs_databases.dbname, rs_objects.objname, rs_objects.phys_tablename,
rs_objects.phys_objowner, rs_objects.has_baserepdef, rs_columns.colname,
rs_columns.colnum, rs_columns.coltype, rs_columns.length from rs_databases,
rs_objects, rs_columns where rs_databases.dbid=rs_objects.dbid and
rs_objects.objid=rs_columns.objid and rs_databases.dsname='rao_rat' and
rs_databases.dbname='dsora92' and rs_objects.has_baserepdef=0x00 order by
4,8

When you're done with tracing, remember to turn it off because it slows
performance:

trace all, false

Thanks,
Wanda

<Shriek> wrote in message news:3f66115f.21f5.846930886@sybase.com...
> Hello All,
>
> I am a newbie to replication. I have setup a replication
> environment from oracle to oracle. The rep agent and the dco
> are up and running and so are the DSI on the rep server
> side.
>
> I marked a sample table for replication, stopped and
> restarted the rao and hit <resume> <go>, the rao went to the
> admin state and had this seemingly simple message:
>
> W. 2003/09/15 11:53:11.96. com.sybase.ra.lti.RSSDFormatter
> COLUMN_INFO_NOT_FOUND
> E. 2003/09/15 11:53:11.96. com.sybase.ra.lti.LTI No columns
> for table <EMP> were found in the RSSD.
>
> I ran into some trouble previously with case and hence named
> all tables, subscriptions and rep defs in CAPS only.
>
> I checked the rs_columsn in the rssd database and it seems
> to contain the correct columns as well.
>
> Is there anyway i can trace out the query being sent to the
> RSSD. Please explain if possible.
>
> Please help.
>
> Thanks in advance,
>
> Regards,
> Shriek


Shriek Posted on 2003-09-16 14:00:28.0Z
Sender: 47a6.3f6717ac.1804289383@sybase.com
From: Shriek
Newsgroups: sybase.public.rep-agent
Subject: Re: Column Info Not Found Error
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f6717f7.47ad.846930886@sybase.com>
References: <3f66115f.21f5.846930886@sybase.com><3f662bcd$1@forums-1-dub>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 16 Sep 2003 07:02:31 -0700, 10.22.241.42
Lines: 108
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 16 Sep 2003 06:57:04 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 16 Sep 2003 07:00:28 -0700
X-Trace: forums-1-dub 1063720828 10.22.108.75 (16 Sep 2003 07:00:28 -0700)
X-Original-Trace: 16 Sep 2003 07:00:28 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:624
Article PK: 862277

Hello Wanda,

Thanks for the information. I tried it out and it worked as
well. The only difference was that changing the case to
lower still gave me problems since the tables were stored in
caps (oracle). I hence changed the case to upper and
everything starting working properly, or rather the error
that i was getting in this regard was not happening any
more.

However i now have a new problem. I think the RepAgent is
not writing the transaction that is it is picking up into
the stable queue. There are no error messages at all in the
logs, the generation_id in the replication server is kept at
zero and so is the locator.

The logs indicate that for every new insert i performed the
rep agent picked it up and it did some kind of a rs_insert
statement. But the queue does not seem to be moving. I dont
know where it is writing this into. I tried to dump all the
contents of the queue and found that all the create/drop
replication/subscriptions were present but no transactions
at all. All DSI's are up as well.

Does anyone have any idea why? Please let me know if you
need further information in this regard.

Thanks in advance,

Regards,
Shriek

> Hi, Shriek,
>
> The RepAgent property ltl_character_case governs how the
> RepAgent treats identifiers (table AND column names). The
> default value is "as_is", which means that identifiers
> coming from Oracle will remain upper case. If you want
> identifiers to be converted to lower case before being
> passed to RepServer, set the value to "lower":
>
> ra_config ltl_character_case, lower
>
> If you want to keep identifiers in upper case, are the
> column names in your repdef also in upper case?
>
> If you want to see the queries RepAgent is using against
> the RSSD, turn on tracing
> trace all, true
> After you resume, look in your
> $SYBASE/rax-12_5/<instance>/log/trace.log for the SQL.
> This is the query to get all the repdefs:
>
> RACONTRCSQL WBECKW2K 2003/08/05 09:49:27.66 wbeck
> com.sybase.ra.conn.RAConnection LTI Thread select
> rs_databases.dsname, rs_databases.dbname,
> rs_objects.objname, rs_objects.phys_tablename,
> rs_objects.phys_objowner, rs_objects.has_baserepdef,
> rs_columns.colname, rs_columns.colnum, rs_columns.coltype,
> rs_columns.length from rs_databases, rs_objects,
> rs_columns where rs_databases.dbid=rs_objects.dbid and
> rs_objects.objid=rs_columns.objid and
> rs_databases.dsname='rao_rat' and
> rs_databases.dbname='dsora92' and
> rs_objects.has_baserepdef=0x00 order by 4,8
>
> When you're done with tracing, remember to turn it off
> because it slows performance:
>
> trace all, false
>
> Thanks,
> Wanda
>
> <Shriek> wrote in message
> > news:3f66115f.21f5.846930886@sybase.com... Hello All,
> >
> > I am a newbie to replication. I have setup a replication
> > environment from oracle to oracle. The rep agent and the
> > dco are up and running and so are the DSI on the rep
> > server side.
> >
> > I marked a sample table for replication, stopped and
> > restarted the rao and hit <resume> <go>, the rao went to
> > the admin state and had this seemingly simple message:
> >
> > W. 2003/09/15 11:53:11.96.
> > com.sybase.ra.lti.RSSDFormatter COLUMN_INFO_NOT_FOUND
> > E. 2003/09/15 11:53:11.96. com.sybase.ra.lti.LTI No
> > columns for table <EMP> were found in the RSSD.
> >
> > I ran into some trouble previously with case and hence
> > named all tables, subscriptions and rep defs in CAPS
> only. >
> > I checked the rs_columsn in the rssd database and it
> > seems to contain the correct columns as well.
> >
> > Is there anyway i can trace out the query being sent to
> > the RSSD. Please explain if possible.
> >
> > Please help.
> >
> > Thanks in advance,
> >
> > Regards,
> > Shriek
>
>


Wanda Beck Posted on 2003-09-16 20:40:41.0Z
From: "Wanda Beck" <wbeck@sybase.com>
Newsgroups: sybase.public.rep-agent
References: <3f66115f.21f5.846930886@sybase.com><3f662bcd$1@forums-1-dub> <3f6717f7.47ad.846930886@sybase.com>
Subject: Re: Column Info Not Found Error
Lines: 159
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
X-Original-NNTP-Posting-Host: wbeckw2k.sybase.com
Message-ID: <3f6775c4$1@forums-2-dub>
X-Original-Trace: 16 Sep 2003 13:42:44 -0700, wbeckw2k.sybase.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 16 Sep 2003 13:37:14 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 16 Sep 2003 13:40:41 -0700
X-Trace: forums-1-dub 1063744841 10.22.108.75 (16 Sep 2003 13:40:41 -0700)
X-Original-Trace: 16 Sep 2003 13:40:41 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:625
Article PK: 862278

Hi, Shriek,

Are you sure RepAgent is sending data to RepServer? There are a couple of
ways to verify this:

- Before resuming replication, set "trace LTITRACELTL, true",
then check the ltitraceltl.log to verify that RepAgent is sending the
data you expect.

- check RepAgent statistics (ra_statistics) several times during
replication --
specifically make sure the following values are increasing

Number of XLog scans
Number of operations replicated
Number of transactions replicated
Number of LTL commands sent

If "Number of XLog operations skipped" is increasing, then
you're probably using
the maintenance user when inserting into the primary table, and
the operations are
getting filtered out.

If you know that LTL is getting to RepServer but not getting to your
replicate:

When you created your replicate table, did you remember to grant permissions
to the maintenance user? At the replicate database, I usually just "grant
all on table <mytable> to public".

Also, does the character case of the *replicate* table match that defined in
the repdef? If you want me to take a look, please supply:

- replicate table create statement
- RS repdef

Also, it's possible that you owner-qualified (using the Oracle owner) the
replicate table in the repdef but that owner is dbo in the replicate
database?

If all these things are correct and you're still not getting data into your
replicate, I recommend you post your questions to the
sybase.public.rep-server forum.

Thanks,
Wanda

<Shriek> wrote in message news:3f6717f7.47ad.846930886@sybase.com...
> Hello Wanda,
>
> Thanks for the information. I tried it out and it worked as
> well. The only difference was that changing the case to
> lower still gave me problems since the tables were stored in
> caps (oracle). I hence changed the case to upper and
> everything starting working properly, or rather the error
> that i was getting in this regard was not happening any
> more.
>
> However i now have a new problem. I think the RepAgent is
> not writing the transaction that is it is picking up into
> the stable queue. There are no error messages at all in the
> logs, the generation_id in the replication server is kept at
> zero and so is the locator.
>
> The logs indicate that for every new insert i performed the
> rep agent picked it up and it did some kind of a rs_insert
> statement. But the queue does not seem to be moving. I dont
> know where it is writing this into. I tried to dump all the
> contents of the queue and found that all the create/drop
> replication/subscriptions were present but no transactions
> at all. All DSI's are up as well.
>
> Does anyone have any idea why? Please let me know if you
> need further information in this regard.
>
> Thanks in advance,
>
> Regards,
> Shriek
>
> > Hi, Shriek,
> >
> > The RepAgent property ltl_character_case governs how the
> > RepAgent treats identifiers (table AND column names). The
> > default value is "as_is", which means that identifiers
> > coming from Oracle will remain upper case. If you want
> > identifiers to be converted to lower case before being
> > passed to RepServer, set the value to "lower":
> >
> > ra_config ltl_character_case, lower
> >
> > If you want to keep identifiers in upper case, are the
> > column names in your repdef also in upper case?
> >
> > If you want to see the queries RepAgent is using against
> > the RSSD, turn on tracing
> > trace all, true
> > After you resume, look in your
> > $SYBASE/rax-12_5/<instance>/log/trace.log for the SQL.
> > This is the query to get all the repdefs:
> >
> > RACONTRCSQL WBECKW2K 2003/08/05 09:49:27.66 wbeck
> > com.sybase.ra.conn.RAConnection LTI Thread select
> > rs_databases.dsname, rs_databases.dbname,
> > rs_objects.objname, rs_objects.phys_tablename,
> > rs_objects.phys_objowner, rs_objects.has_baserepdef,
> > rs_columns.colname, rs_columns.colnum, rs_columns.coltype,
> > rs_columns.length from rs_databases, rs_objects,
> > rs_columns where rs_databases.dbid=rs_objects.dbid and
> > rs_objects.objid=rs_columns.objid and
> > rs_databases.dsname='rao_rat' and
> > rs_databases.dbname='dsora92' and
> > rs_objects.has_baserepdef=0x00 order by 4,8
> >
> > When you're done with tracing, remember to turn it off
> > because it slows performance:
> >
> > trace all, false
> >
> > Thanks,
> > Wanda
> >
> > <Shriek> wrote in message
> > > news:3f66115f.21f5.846930886@sybase.com... Hello All,
> > >
> > > I am a newbie to replication. I have setup a replication
> > > environment from oracle to oracle. The rep agent and the
> > > dco are up and running and so are the DSI on the rep
> > > server side.
> > >
> > > I marked a sample table for replication, stopped and
> > > restarted the rao and hit <resume> <go>, the rao went to
> > > the admin state and had this seemingly simple message:
> > >
> > > W. 2003/09/15 11:53:11.96.
> > > com.sybase.ra.lti.RSSDFormatter COLUMN_INFO_NOT_FOUND
> > > E. 2003/09/15 11:53:11.96. com.sybase.ra.lti.LTI No
> > > columns for table <EMP> were found in the RSSD.
> > >
> > > I ran into some trouble previously with case and hence
> > > named all tables, subscriptions and rep defs in CAPS
> > only. >
> > > I checked the rs_columsn in the rssd database and it
> > > seems to contain the correct columns as well.
> > >
> > > Is there anyway i can trace out the query being sent to
> > > the RSSD. Please explain if possible.
> > >
> > > Please help.
> > >
> > > Thanks in advance,
> > >
> > > Regards,
> > > Shriek
> >
> >


Shriek Posted on 2003-09-17 09:08:40.0Z
Sender: 410b.3f682399.1804289383@sybase.com
From: Shriek
Newsgroups: sybase.public.rep-agent
Subject: Re: Column Info Not Found Error
X-Mailer: WebNews to Mail Gateway v1.1s
Message-ID: <3f682498.411c.846930886@sybase.com>
References: <3f66115f.21f5.846930886@sybase.com><3f662bcd$1@forums-1-dub> <3f6717f7.47ad.846930886@sybase.com><3f6775c4$1@forums-2-dub>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 17 Sep 2003 02:08:40 -0700
X-Trace: forums-1-dub 1063789720 10.22.241.41 (17 Sep 2003 02:08:40 -0700)
X-Original-Trace: 17 Sep 2003 02:08:40 -0700, 10.22.241.41
Lines: 174
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:626
Article PK: 862279

Hi Wanda,

Thanks for the info. I actually managed to solve the problem
finally. I increased the generation id value in the repagent
to 10 and everything started working. I just increased it on
gut feel without knowing exactly what it does though.

Thanks again for you help.

Regards,
Srikanth

> Hi, Shriek,
>
> Are you sure RepAgent is sending data to RepServer? There
> are a couple of ways to verify this:
>
> - Before resuming replication, set "trace LTITRACELTL,
> true",
> then check the ltitraceltl.log to verify that
> RepAgent is sending the data you expect.
>
> - check RepAgent statistics (ra_statistics) several
> times during replication --
> specifically make sure the following values are
> increasing
>
> Number of XLog scans
> Number of operations replicated
> Number of transactions replicated
> Number of LTL commands sent
>
> If "Number of XLog operations skipped" is
> increasing, then you're probably using
> the maintenance user when inserting into the
> primary table, and the operations are
> getting filtered out.
>
> If you know that LTL is getting to RepServer but not
> getting to your replicate:
>
> When you created your replicate table, did you remember to
> grant permissions to the maintenance user? At the
> replicate database, I usually just "grant all on table
> <mytable> to public".
>
> Also, does the character case of the *replicate* table
> match that defined in the repdef? If you want me to take
> a look, please supply:
>
> - replicate table create statement
> - RS repdef
>
> Also, it's possible that you owner-qualified (using the
> Oracle owner) the replicate table in the repdef but that
> owner is dbo in the replicate database?
>
> If all these things are correct and you're still not
> getting data into your replicate, I recommend you post
> your questions to the sybase.public.rep-server forum.
>
> Thanks,
> Wanda
>
> <Shriek> wrote in message
> > news:3f6717f7.47ad.846930886@sybase.com... Hello Wanda,
> >
> > Thanks for the information. I tried it out and it worked
> > as well. The only difference was that changing the case
> > to lower still gave me problems since the tables were
> > stored in caps (oracle). I hence changed the case to
> > upper and everything starting working properly, or
> > rather the error that i was getting in this regard was
> > not happening any more.
> >
> > However i now have a new problem. I think the RepAgent
> > is not writing the transaction that is it is picking up
> > into the stable queue. There are no error messages at
> > all in the logs, the generation_id in the replication
> > server is kept at zero and so is the locator.
> >
> > The logs indicate that for every new insert i performed
> > the rep agent picked it up and it did some kind of a
> > rs_insert statement. But the queue does not seem to be
> > moving. I dont know where it is writing this into. I
> > tried to dump all the contents of the queue and found
> > that all the create/drop replication/subscriptions were
> > present but no transactions at all. All DSI's are up as
> well. >
> > Does anyone have any idea why? Please let me know if you
> > need further information in this regard.
> >
> > Thanks in advance,
> >
> > Regards,
> > Shriek
> >
> > > Hi, Shriek,
> > >
> > > The RepAgent property ltl_character_case governs how
> > > the RepAgent treats identifiers (table AND column
> > > names). The default value is "as_is", which means
> > > that identifiers coming from Oracle will remain upper
> > > case. If you want identifiers to be converted to
> > > lower case before being passed to RepServer, set the
> > value to "lower": >
> > > ra_config ltl_character_case, lower
> > >
> > > If you want to keep identifiers in upper case, are the
> > > column names in your repdef also in upper case?
> > >
> > > If you want to see the queries RepAgent is using
> > > against the RSSD, turn on tracing
> > > trace all, true
> > > After you resume, look in your
> > > $SYBASE/rax-12_5/<instance>/log/trace.log for the SQL.
> > > This is the query to get all the repdefs:
> > >
> > > RACONTRCSQL WBECKW2K 2003/08/05 09:49:27.66 wbeck
> > > com.sybase.ra.conn.RAConnection LTI Thread select
> > > rs_databases.dsname, rs_databases.dbname,
> > > rs_objects.objname, rs_objects.phys_tablename,
> > > rs_objects.phys_objowner, rs_objects.has_baserepdef,
> > > rs_columns.colname, rs_columns.colnum,
> > > rs_columns.coltype, rs_columns.length from
> > > rs_databases, rs_objects, rs_columns where
> > > rs_databases.dbid=rs_objects.dbid and
> > > rs_objects.objid=rs_columns.objid and
> > > rs_databases.dsname='rao_rat' and
> > > rs_databases.dbname='dsora92' and
> > rs_objects.has_baserepdef=0x00 order by 4,8 >
> > > When you're done with tracing, remember to turn it off
> > > because it slows performance:
> > >
> > > trace all, false
> > >
> > > Thanks,
> > > Wanda
> > >
> > > <Shriek> wrote in message
> > > > news:3f66115f.21f5.846930886@sybase.com... Hello All
> > > , >
> > > > I am a newbie to replication. I have setup a
> > > > replication environment from oracle to oracle. The
> > > > rep agent and the dco are up and running and so are
> > > > the DSI on the rep server side.
> > > >
> > > > I marked a sample table for replication, stopped and
> > > > restarted the rao and hit <resume> <go>, the rao
> > > > went to the admin state and had this seemingly
> > > simple message: >
> > > > W. 2003/09/15 11:53:11.96.
> > > > com.sybase.ra.lti.RSSDFormatter
> > > > COLUMN_INFO_NOT_FOUND E. 2003/09/15 11:53:11.96.
> > > > com.sybase.ra.lti.LTI No columns for table <EMP>
> > > were found in the RSSD. >
> > > > I ran into some trouble previously with case and
> > > > hence named all tables, subscriptions and rep defs
> > > in CAPS only. >
> > > > I checked the rs_columsn in the rssd database and it
> > > > seems to contain the correct columns as well.
> > > >
> > > > Is there anyway i can trace out the query being sent
> > > > to the RSSD. Please explain if possible.
> > > >
> > > > Please help.
> > > >
> > > > Thanks in advance,
> > > >
> > > > Regards,
> > > > Shriek
> > >
> > >
>
>


Wanda Beck Posted on 2003-09-17 20:11:52.0Z
From: "Wanda Beck" <wbeck@sybase.com>
Newsgroups: sybase.public.rep-agent
References: <3f66115f.21f5.846930886@sybase.com><3f662bcd$1@forums-1-dub> <3f6717f7.47ad.846930886@sybase.com><3f6775c4$1@forums-2-dub> <3f682498.411c.846930886@sybase.com>
Subject: Re: Column Info Not Found Error
Lines: 193
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: wbeckw2k.sybase.com
X-Original-NNTP-Posting-Host: wbeckw2k.sybase.com
Message-ID: <3f68c008$1@forums-1-dub>
Date: 17 Sep 2003 13:11:52 -0700
X-Trace: forums-1-dub 1063829512 157.133.80.197 (17 Sep 2003 13:11:52 -0700)
X-Original-Trace: 17 Sep 2003 13:11:52 -0700, wbeckw2k.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:627
Article PK: 862280

Hi, Shriek,

The generation id is the first two bytes of the Origin Queue ID (OQID) that
RepAgent constructs to identify an operation to RepServer. RepServer
requires that the OQID be always increasing. See the RepAgent Admin Guide,
Appendix D, Oracle-Specific issues, Format of origin queue ID:
http://sybooks.sybase.com/onlinebooks/group-ra/rag1250e/ra125ag/@Generic__BookTextView/25413;pt=25413#X

If you were sending the same set of operations to RepServer over and over,
it may be that RepServer saw them as duplicates and discarded them. By
increasing the generation id, you have guaranteed that the operations have
new OQIDs so cannot be treated as duplicates.

Thanks,
Wanda

<Shriek> wrote in message news:3f682498.411c.846930886@sybase.com...
> Hi Wanda,
>
> Thanks for the info. I actually managed to solve the problem
> finally. I increased the generation id value in the repagent
> to 10 and everything started working. I just increased it on
> gut feel without knowing exactly what it does though.
>
> Thanks again for you help.
>
> Regards,
> Srikanth
> > Hi, Shriek,
> >
> > Are you sure RepAgent is sending data to RepServer? There
> > are a couple of ways to verify this:
> >
> > - Before resuming replication, set "trace LTITRACELTL,
> > true",
> > then check the ltitraceltl.log to verify that
> > RepAgent is sending the data you expect.
> >
> > - check RepAgent statistics (ra_statistics) several
> > times during replication --
> > specifically make sure the following values are
> > increasing
> >
> > Number of XLog scans
> > Number of operations replicated
> > Number of transactions replicated
> > Number of LTL commands sent
> >
> > If "Number of XLog operations skipped" is
> > increasing, then you're probably using
> > the maintenance user when inserting into the
> > primary table, and the operations are
> > getting filtered out.
> >
> > If you know that LTL is getting to RepServer but not
> > getting to your replicate:
> >
> > When you created your replicate table, did you remember to
> > grant permissions to the maintenance user? At the
> > replicate database, I usually just "grant all on table
> > <mytable> to public".
> >
> > Also, does the character case of the *replicate* table
> > match that defined in the repdef? If you want me to take
> > a look, please supply:
> >
> > - replicate table create statement
> > - RS repdef
> >
> > Also, it's possible that you owner-qualified (using the
> > Oracle owner) the replicate table in the repdef but that
> > owner is dbo in the replicate database?
> >
> > If all these things are correct and you're still not
> > getting data into your replicate, I recommend you post
> > your questions to the sybase.public.rep-server forum.
> >
> > Thanks,
> > Wanda
> >
> > <Shriek> wrote in message
> > > news:3f6717f7.47ad.846930886@sybase.com... Hello Wanda,
> > >
> > > Thanks for the information. I tried it out and it worked
> > > as well. The only difference was that changing the case
> > > to lower still gave me problems since the tables were
> > > stored in caps (oracle). I hence changed the case to
> > > upper and everything starting working properly, or
> > > rather the error that i was getting in this regard was
> > > not happening any more.
> > >
> > > However i now have a new problem. I think the RepAgent
> > > is not writing the transaction that is it is picking up
> > > into the stable queue. There are no error messages at
> > > all in the logs, the generation_id in the replication
> > > server is kept at zero and so is the locator.
> > >
> > > The logs indicate that for every new insert i performed
> > > the rep agent picked it up and it did some kind of a
> > > rs_insert statement. But the queue does not seem to be
> > > moving. I dont know where it is writing this into. I
> > > tried to dump all the contents of the queue and found
> > > that all the create/drop replication/subscriptions were
> > > present but no transactions at all. All DSI's are up as
> > well. >
> > > Does anyone have any idea why? Please let me know if you
> > > need further information in this regard.
> > >
> > > Thanks in advance,
> > >
> > > Regards,
> > > Shriek
> > >
> > > > Hi, Shriek,
> > > >
> > > > The RepAgent property ltl_character_case governs how
> > > > the RepAgent treats identifiers (table AND column
> > > > names). The default value is "as_is", which means
> > > > that identifiers coming from Oracle will remain upper
> > > > case. If you want identifiers to be converted to
> > > > lower case before being passed to RepServer, set the
> > > value to "lower": >
> > > > ra_config ltl_character_case, lower
> > > >
> > > > If you want to keep identifiers in upper case, are the
> > > > column names in your repdef also in upper case?
> > > >
> > > > If you want to see the queries RepAgent is using
> > > > against the RSSD, turn on tracing
> > > > trace all, true
> > > > After you resume, look in your
> > > > $SYBASE/rax-12_5/<instance>/log/trace.log for the SQL.
> > > > This is the query to get all the repdefs:
> > > >
> > > > RACONTRCSQL WBECKW2K 2003/08/05 09:49:27.66 wbeck
> > > > com.sybase.ra.conn.RAConnection LTI Thread select
> > > > rs_databases.dsname, rs_databases.dbname,
> > > > rs_objects.objname, rs_objects.phys_tablename,
> > > > rs_objects.phys_objowner, rs_objects.has_baserepdef,
> > > > rs_columns.colname, rs_columns.colnum,
> > > > rs_columns.coltype, rs_columns.length from
> > > > rs_databases, rs_objects, rs_columns where
> > > > rs_databases.dbid=rs_objects.dbid and
> > > > rs_objects.objid=rs_columns.objid and
> > > > rs_databases.dsname='rao_rat' and
> > > > rs_databases.dbname='dsora92' and
> > > rs_objects.has_baserepdef=0x00 order by 4,8 >
> > > > When you're done with tracing, remember to turn it off
> > > > because it slows performance:
> > > >
> > > > trace all, false
> > > >
> > > > Thanks,
> > > > Wanda
> > > >
> > > > <Shriek> wrote in message
> > > > > news:3f66115f.21f5.846930886@sybase.com... Hello All
> > > > , >
> > > > > I am a newbie to replication. I have setup a
> > > > > replication environment from oracle to oracle. The
> > > > > rep agent and the dco are up and running and so are
> > > > > the DSI on the rep server side.
> > > > >
> > > > > I marked a sample table for replication, stopped and
> > > > > restarted the rao and hit <resume> <go>, the rao
> > > > > went to the admin state and had this seemingly
> > > > simple message: >
> > > > > W. 2003/09/15 11:53:11.96.
> > > > > com.sybase.ra.lti.RSSDFormatter
> > > > > COLUMN_INFO_NOT_FOUND E. 2003/09/15 11:53:11.96.
> > > > > com.sybase.ra.lti.LTI No columns for table <EMP>
> > > > were found in the RSSD. >
> > > > > I ran into some trouble previously with case and
> > > > > hence named all tables, subscriptions and rep defs
> > > > in CAPS only. >
> > > > > I checked the rs_columsn in the rssd database and it
> > > > > seems to contain the correct columns as well.
> > > > >
> > > > > Is there anyway i can trace out the query being sent
> > > > > to the RSSD. Please explain if possible.
> > > > >
> > > > > Please help.
> > > > >
> > > > > Thanks in advance,
> > > > >
> > > > > Regards,
> > > > > Shriek
> > > >
> > > >
> >
> >