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.

Rep Svr not reping column

15 posts in General Discussion Last posting was on 2012-04-19 17:31:29.0Z
rick_806 Posted on 2012-03-02 15:28:44.0Z
Sender: 6ccb.4f50e683.1804289383@sybase.com
From: rick_806
Newsgroups: sybase.public.rep-server
Subject: Rep Svr not reping column
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f50e72c.6cef.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 2 Mar 2012 07:28:44 -0800
X-Trace: forums-1-dub 1330702124 172.20.134.41 (2 Mar 2012 07:28:44 -0800)
X-Original-Trace: 2 Mar 2012 07:28:44 -0800, 172.20.134.41
Lines: 10
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9163
Article PK: 870326

Rep Svr 15.6, ASE 15.0.1 I have a repdef defined that
include a PK column that is also an identity. The
subscription takes all records from the repdef (no select).
When Rep Svr creates the transactions for replicate side it
is leaving off the 1st column (identity PK). The replicate
table has same column as numerci, not identity. Any idea why
Rep Svr would ignore this column?

Thx,
rick_806


peta62 Posted on 2012-03-02 19:05:12.0Z
From: peta62 <no@mail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0) Gecko/20111105 Thunderbird/8.0
MIME-Version: 1.0
Newsgroups: sybase.public.rep-server
Subject: Re: Rep Svr not reping column
References: <4f50e72c.6cef.1681692777@sybase.com>
In-Reply-To: <4f50e72c.6cef.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f5119e8@forums-1-dub>
Date: 2 Mar 2012 11:05:12 -0800
X-Trace: forums-1-dub 1330715112 10.22.241.152 (2 Mar 2012 11:05:12 -0800)
X-Original-Trace: 2 Mar 2012 11:05:12 -0800, vip152.sybase.com
Lines: 19
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9164
Article PK: 870327

Hi Rick,
did you check
http://infocenter.sybase.com/help/index.jsp?workingSet=All%20topics ?
Cheers,
Peter

On 3/2/2012 4:28 PM, rick_806 wrote:
> Rep Svr 15.6, ASE 15.0.1 I have a repdef defined that
> include a PK column that is also an identity. The
> subscription takes all records from the repdef (no select).
> When Rep Svr creates the transactions for replicate side it
> is leaving off the 1st column (identity PK). The replicate
> table has same column as numerci, not identity. Any idea why
> Rep Svr would ignore this column?
>
> Thx,
> rick_806


peta62 Posted on 2012-03-02 19:08:45.0Z
From: peta62 <no@mail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0) Gecko/20111105 Thunderbird/8.0
MIME-Version: 1.0
Newsgroups: sybase.public.rep-server
Subject: Re: Rep Svr not reping column
References: <4f50e72c.6cef.1681692777@sybase.com> <4f5119e8@forums-1-dub>
In-Reply-To: <4f5119e8@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f511abd@forums-1-dub>
Date: 2 Mar 2012 11:08:45 -0800
X-Trace: forums-1-dub 1330715325 10.22.241.152 (2 Mar 2012 11:08:45 -0800)
X-Original-Trace: 2 Mar 2012 11:08:45 -0800, vip152.sybase.com
Lines: 25
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9165
Article PK: 870328

Sorry, should have been
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32511.1570/doc/html/san1275527333935.html

On 3/2/2012 8:05 PM, peta62 wrote:
> Hi Rick,
> did you check
> http://infocenter.sybase.com/help/index.jsp?workingSet=All%20topics ?
> Cheers,
> Peter
>
>
> On 3/2/2012 4:28 PM, rick_806 wrote:
>> Rep Svr 15.6, ASE 15.0.1 I have a repdef defined that
>> include a PK column that is also an identity. The
>> subscription takes all records from the repdef (no select).
>> When Rep Svr creates the transactions for replicate side it
>> is leaving off the 1st column (identity PK). The replicate
>> table has same column as numerci, not identity. Any idea why
>> Rep Svr would ignore this column?
>>
>> Thx,
>> rick_806
>


rick_806 Posted on 2012-03-02 20:52:19.0Z
Sender: 6ccb.4f50e683.1804289383@sybase.com
From: rick_806
Newsgroups: sybase.public.rep-server
Subject: Re: Rep Svr not reping column
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f513302.7864.1681692777@sybase.com>
References: <4f511abd@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 2 Mar 2012 12:52:19 -0800
X-Trace: forums-1-dub 1330721539 172.20.134.41 (2 Mar 2012 12:52:19 -0800)
X-Original-Trace: 2 Mar 2012 12:52:19 -0800, 172.20.134.41
Lines: 36
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9167
Article PK: 870330

That doesn't help either. Although the PDS table column is a
identity, the repdef treats it as numeric and the replicate
table does not have that column as identity so the doc does
not explain what happens when a identity column is
replicated to a non-identity column. However, this is
development and I have the same repdef/sub in production and
it works correctly.

> Sorry, should have been
>
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32511.1570/doc/html/san1275527333935.html
>
>
> On 3/2/2012 8:05 PM, peta62 wrote:
> > Hi Rick,
> > did you check
> >
> http://infocenter.sybase.com/help/index.jsp?workingSet=All
topics
> > ? Cheers,
> > Peter
> >
> >
> > On 3/2/2012 4:28 PM, rick_806 wrote:
> >> Rep Svr 15.6, ASE 15.0.1 I have a repdef defined that
> >> include a PK column that is also an identity. The
> >> subscription takes all records from the repdef (no
> select). >> When Rep Svr creates the transactions for
> replicate side it >> is leaving off the 1st column
> (identity PK). The replicate >> table has same column as
> numerci, not identity. Any idea why >> Rep Svr would
> ignore this column? >>
> >> Thx,
> >> rick_806
> >
>


"Mark A. Parsons" <iron_horse Posted on 2012-03-03 02:56:33.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.rep-server
Subject: Re: Rep Svr not reping column
References: <4f511abd@forums-1-dub> <4f513302.7864.1681692777@sybase.com>
In-Reply-To: <4f513302.7864.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f518861@forums-1-dub>
Date: 2 Mar 2012 18:56:33 -0800
X-Trace: forums-1-dub 1330743393 10.22.241.152 (2 Mar 2012 18:56:33 -0800)
X-Original-Trace: 2 Mar 2012 18:56:33 -0800, vip152.sybase.com
Lines: 63
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9168
Article PK: 870331

You may have already done a lot of the following, but since you haven't explicitly listed all the steps you've taken ...

- verify the dev and prod copies of the PDB and RDB tables are identical

- verify the dev and prod repdefs are identical (column definitions, pk definition, replicate minimal/all columns, etc)

- capture the dev and prod versions of the SQL that's actually being submitted by the DSI (either pull from the
repserver queue or the RDS's monSysSQLText table)

I'd be curious to see if the DSI is sending through a NULL for the ident/numeric column value, or if it's submitting a
column list (sans ident column name) and because the RDB table column is not defined as 'identity' then the missing
column/value in the insert statement is causing the RDB to assign a default value of NULL into a non-NULLable column.
In other words, which of the following do your dev/prod DSIs submit to the RDB:

insert table (identcol, col1, col2) values (NULL,'a','b')
insert table (col1, col2) values ('a','b') -- identcol implicitly set to NULL

NOTE: If you can run your test in a relatively quiet setup I'd recommend quiescing rep, suspending the DSI, performing
the insert in the PDB, resume the DSI, and pull all of the recent maintuser queries from monSysSQLText in the RDS.
You're looking for the set of initial commands being issued by the DSI connection when it first connects as well as any
commands preceding the insert to your table (eg, set triggers off, set identity_insert on, etc).

- are you running different ASE and/or RS versions between dev and prod?

Nope, these steps aren't going to *tell* you what the problem is but they may help zero in on where the issue lies.

On 03/02/2012 13:52, rick_806 wrote:
> That doesn't help either. Although the PDS table column is a
> identity, the repdef treats it as numeric and the replicate
> table does not have that column as identity so the doc does
> not explain what happens when a identity column is
> replicated to a non-identity column. However, this is
> development and I have the same repdef/sub in production and
> it works correctly.
>
>> Sorry, should have been
>>
> http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32511.1570/doc/html/san1275527333935.html
>>
>>
>> On 3/2/2012 8:05 PM, peta62 wrote:
>>> Hi Rick,
>>> did you check
>>>
>> http://infocenter.sybase.com/help/index.jsp?workingSet=All
> topics
>>> ? Cheers,
>>> Peter
>>>
>>>
>>> On 3/2/2012 4:28 PM, rick_806 wrote:
>>>> Rep Svr 15.6, ASE 15.0.1 I have a repdef defined that
>>>> include a PK column that is also an identity. The
>>>> subscription takes all records from the repdef (no
>> select).>> When Rep Svr creates the transactions for
>> replicate side it>> is leaving off the 1st column
>> (identity PK). The replicate>> table has same column as
>> numerci, not identity. Any idea why>> Rep Svr would
>> ignore this column?>>
>>>> Thx,
>>>> rick_806
>>>
>>


peta62 Posted on 2012-03-03 09:51:36.0Z
From: peta62 <no@mail.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:8.0) Gecko/20111105 Thunderbird/8.0
MIME-Version: 1.0
Newsgroups: sybase.public.rep-server
Subject: Re: Rep Svr not reping column
References: <4f511abd@forums-1-dub> <4f513302.7864.1681692777@sybase.com> <4f518861@forums-1-dub>
In-Reply-To: <4f518861@forums-1-dub>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f51e9a8@forums-1-dub>
Date: 3 Mar 2012 01:51:36 -0800
X-Trace: forums-1-dub 1330768296 10.22.241.152 (3 Mar 2012 01:51:36 -0800)
X-Original-Trace: 3 Mar 2012 01:51:36 -0800, vip152.sybase.com
Lines: 86
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9169
Article PK: 870334

Hello,
just to add to Mark. I think ( did not test on weekend ;-) ) if
replicate table does not have identity, it should not be in rep def
either. If you set save interval you can just dump the queue to see DSI
commands.
HTH,
Peter

On 3/3/2012 3:56 AM, Mark A. Parsons wrote:
> You may have already done a lot of the following, but since you haven't
> explicitly listed all the steps you've taken ...
>
> - verify the dev and prod copies of the PDB and RDB tables are identical
>
> - verify the dev and prod repdefs are identical (column definitions, pk
> definition, replicate minimal/all columns, etc)
>
> - capture the dev and prod versions of the SQL that's actually being
> submitted by the DSI (either pull from the repserver queue or the RDS's
> monSysSQLText table)
>
> I'd be curious to see if the DSI is sending through a NULL for the
> ident/numeric column value, or if it's submitting a column list (sans
> ident column name) and because the RDB table column is not defined as
> 'identity' then the missing column/value in the insert statement is
> causing the RDB to assign a default value of NULL into a non-NULLable
> column. In other words, which of the following do your dev/prod DSIs
> submit to the RDB:
>
> insert table (identcol, col1, col2) values (NULL,'a','b')
> insert table (col1, col2) values ('a','b') -- identcol implicitly set to
> NULL
>
> NOTE: If you can run your test in a relatively quiet setup I'd recommend
> quiescing rep, suspending the DSI, performing the insert in the PDB,
> resume the DSI, and pull all of the recent maintuser queries from
> monSysSQLText in the RDS. You're looking for the set of initial commands
> being issued by the DSI connection when it first connects as well as any
> commands preceding the insert to your table (eg, set triggers off, set
> identity_insert on, etc).
>
> - are you running different ASE and/or RS versions between dev and prod?
>
> Nope, these steps aren't going to *tell* you what the problem is but
> they may help zero in on where the issue lies.
>
> On 03/02/2012 13:52, rick_806 wrote:
>> That doesn't help either. Although the PDS table column is a
>> identity, the repdef treats it as numeric and the replicate
>> table does not have that column as identity so the doc does
>> not explain what happens when a identity column is
>> replicated to a non-identity column. However, this is
>> development and I have the same repdef/sub in production and
>> it works correctly.
>>
>>> Sorry, should have been
>>>
>> http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32511.1570/doc/html/san1275527333935.html
>>
>>>
>>>
>>> On 3/2/2012 8:05 PM, peta62 wrote:
>>>> Hi Rick,
>>>> did you check
>>>>
>>> http://infocenter.sybase.com/help/index.jsp?workingSet=All
>> topics
>>>> ? Cheers,
>>>> Peter
>>>>
>>>>
>>>> On 3/2/2012 4:28 PM, rick_806 wrote:
>>>>> Rep Svr 15.6, ASE 15.0.1 I have a repdef defined that
>>>>> include a PK column that is also an identity. The
>>>>> subscription takes all records from the repdef (no
>>> select).>> When Rep Svr creates the transactions for
>>> replicate side it>> is leaving off the 1st column
>>> (identity PK). The replicate>> table has same column as
>>> numerci, not identity. Any idea why>> Rep Svr would
>>> ignore this column?>>
>>>>> Thx,
>>>>> rick_806
>>>>
>>>


rick_806 Posted on 2012-03-05 19:19:42.0Z
Sender: 4e6c.4f550f0c.1804289383@sybase.com
From: rick_806
Newsgroups: sybase.public.rep-server
Subject: Re: Rep Svr not reping column
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f5511ce.4ede.1681692777@sybase.com>
References: <4f518861@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 5 Mar 2012 11:19:42 -0800
X-Trace: forums-1-dub 1330975182 172.20.134.41 (5 Mar 2012 11:19:42 -0800)
X-Original-Trace: 5 Mar 2012 11:19:42 -0800, 172.20.134.41
Lines: 91
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9177
Article PK: 870340


> You may have already done a lot of the following, but
> since you haven't explicitly listed all the steps you've
> taken ...
>
> - verify the dev and prod copies of the PDB and RDB tables
> are identical - they are identical
>
> - verify the dev and prod repdefs are identical (column
> definitions, pk definition, replicate minimal/all columns,
> etc) --they are identical
>
> - capture the dev and prod versions of the SQL that's
> actually being submitted by the DSI (either pull from the
> repserver queue or the RDS's monSysSQLText table) Dev
leaves off the required first column, Prod does not.
>
> I'd be curious to see if the DSI is sending through a NULL
> for the ident/numeric column value, or if it's submitting
> a column list (sans ident column name) and because the
> RDB table column is not defined as 'identity' then the
> missing column/value in the insert statement is causing
> the RDB to assign a default value of NULL into a
> non-NULLable column. In other words, which of the
> following do your dev/prod DSIs submit to the RDB:
>
> insert table (identcol, col1, col2) values (NULL,'a'
> ,'b')
> insert table (col1, col2) values ('a','b') --
> identcol implicitly set to NULL --it is sending a

col/values list and the first col/value is missing, it needs
to replciate the value assigned by IDENTITY in PDB to the
RDB
>
> NOTE: If you can run your test in a relatively quiet
> setup I'd recommend quiescing rep, suspending the DSI,
> performing the insert in the PDB, resume the DSI, and
> pull all of the recent maintuser queries from
> monSysSQLText in the RDS. You're looking for the set of
> initial commands being issued by the DSI connection when
> it first connects as well as any commands preceding the
> insert to your table (eg, set triggers off, set
> identity_insert on, etc).
>
> - are you running different ASE and/or RS versions between
> dev and prod? yes, Rep 12.5 in Prod, 15.6 in DEV, ASE is
15.0.3 in Prod, 15.0.1 in DEV
>
> Nope, these steps aren't going to *tell* you what the
> problem is but they may help zero in on where the issue
> lies.
>
> On 03/02/2012 13:52, rick_806 wrote:
> > That doesn't help either. Although the PDS table column
> > is a identity, the repdef treats it as numeric and the
> > replicate table does not have that column as identity so
> > the doc does not explain what happens when a identity
> > column is replicated to a non-identity column. However,
> > this is development and I have the same repdef/sub in
> > production and it works correctly.
> >
> >> Sorry, should have been
> >>
> >
>
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32511.1570/doc/html/san1275527333935.html
> >>
> >>
> >> On 3/2/2012 8:05 PM, peta62 wrote:
> >>> Hi Rick,
> >>> did you check
> >>>
> >>
> >
> http://infocenter.sybase.com/help/index.jsp?workingSet=All
> topics >>> ? Cheers,
> >>> Peter
> >>>
> >>>
> >>> On 3/2/2012 4:28 PM, rick_806 wrote:
> >>>> Rep Svr 15.6, ASE 15.0.1 I have a repdef defined that
> >>>> include a PK column that is also an identity. The
> >>>> subscription takes all records from the repdef (no
> >> select).>> When Rep Svr creates the transactions for
> >> replicate side it>> is leaving off the 1st column
> >> (identity PK). The replicate>> table has same column
> as >> numerci, not identity. Any idea why>> Rep Svr would
> >> ignore this column?>>
> >>>> Thx,
> >>>> rick_806
> >>>
> >>


rick_906 Posted on 2012-03-21 18:04:03.0Z
Sender: 59ce.4f6a130c.1804289383@sybase.com
From: rick_906
Newsgroups: sybase.public.rep-server
Subject: Re: Rep Svr not reping column
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f6a1813.5afd.1681692777@sybase.com>
References: <4f5511ce.4ede.1681692777@sybase.com>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 21 Mar 2012 10:04:03 -0800
X-Trace: forums-1-dub 1332353043 172.20.134.41 (21 Mar 2012 10:04:03 -0800)
X-Original-Trace: 21 Mar 2012 10:04:03 -0800, 172.20.134.41
Lines: 101
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9188
Article PK: 870351

Apparently Sybase does not know what is causing this either,
so far I have rebuilt repdefs/sub without custom FS class
(even though we only change the rs_delete), recreated the
PDB/RDB tables and create new repdef/sub without custom
FSclass (same issue). Now they are telling me to rebuild the
entire rep server and try again without using custom FS
class.

> > You may have already done a lot of the following, but
> > since you haven't explicitly listed all the steps you've
> > taken ...
> >
> > - verify the dev and prod copies of the PDB and RDB
> > tables are identical - they are identical
> >
> > - verify the dev and prod repdefs are identical (column
> > definitions, pk definition, replicate minimal/all
> > columns, etc) --they are identical
> >
> > - capture the dev and prod versions of the SQL that's
> > actually being submitted by the DSI (either pull from
> > the repserver queue or the RDS's monSysSQLText table)
> Dev leaves off the required first column, Prod does not.
> >
> > I'd be curious to see if the DSI is sending through a
> > NULL for the ident/numeric column value, or if it's
> > submitting a column list (sans ident column name) and
> > because the RDB table column is not defined as
> > 'identity' then the missing column/value in the insert
> > statement is causing the RDB to assign a default value
> > of NULL into a non-NULLable column. In other words,
> > which of the following do your dev/prod DSIs submit to
> the RDB: >
> > insert table (identcol, col1, col2) values (NULL
> > ,'a' ,'b')
> > insert table (col1, col2) values ('a','b') --
> > identcol implicitly set to NULL --it is sending a
> col/values list and the first col/value is missing, it
> needs to replciate the value assigned by IDENTITY in PDB
> to the RDB
> >
> > NOTE: If you can run your test in a relatively quiet
> > setup I'd recommend quiescing rep, suspending the DSI,
> > performing the insert in the PDB, resume the DSI, and
> > pull all of the recent maintuser queries from
> > monSysSQLText in the RDS. You're looking for the set of
> > initial commands being issued by the DSI connection when
> > it first connects as well as any commands preceding the
> > insert to your table (eg, set triggers off, set
> > identity_insert on, etc).
> >
> > - are you running different ASE and/or RS versions
> > between dev and prod? yes, Rep 12.5 in Prod, 15.6 in DEV
> , ASE is 15.0.3 in Prod, 15.0.1 in DEV
> >
> > Nope, these steps aren't going to *tell* you what the
> > problem is but they may help zero in on where the issue
> > lies.
> >
> > On 03/02/2012 13:52, rick_806 wrote:
> > > That doesn't help either. Although the PDS table
> > > column is a identity, the repdef treats it as numeric
> > > and the replicate table does not have that column as
> > > identity so the doc does not explain what happens when
> > > a identity column is replicated to a non-identity
> > > column. However, this is development and I have the
> > > same repdef/sub in production and it works correctly.
> > >
> > >> Sorry, should have been
> > >>
> > >
> >
>
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32511.1570/doc/html/san1275527333935.html
> > >>
> > >>
> > >> On 3/2/2012 8:05 PM, peta62 wrote:
> > >>> Hi Rick,
> > >>> did you check
> > >>>
> > >>
> > >
> >
> >
> http://infocenter.sybase.com/help/index.jsp?workingSet=All
> > topics >>> ? Cheers, >>> Peter
> > >>>
> > >>>
> > >>> On 3/2/2012 4:28 PM, rick_806 wrote:
> > >>>> Rep Svr 15.6, ASE 15.0.1 I have a repdef defined
> > that >>>> include a PK column that is also an identity.
> > The >>>> subscription takes all records from the repdef
> > (no >> select).>> When Rep Svr creates the transactions
> > for >> replicate side it>> is leaving off the 1st
> > column >> (identity PK). The replicate>> table has same
> > column as >> numerci, not identity. Any idea why>> Rep
> > Svr would >> ignore this column?>>
> > >>>> Thx,
> > >>>> rick_806
> > >>>
> > >>


"Mark A. Parsons" <iron_horse Posted on 2012-03-22 00:09:47.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.rep-server
Subject: Re: Rep Svr not reping column
References: <4f5511ce.4ede.1681692777@sybase.com> <4f6a1813.5afd.1681692777@sybase.com>
In-Reply-To: <4f6a1813.5afd.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f6a6dcb$1@forums-1-dub>
Date: 21 Mar 2012 16:09:47 -0800
X-Trace: forums-1-dub 1332374987 10.22.241.152 (21 Mar 2012 16:09:47 -0800)
X-Original-Trace: 21 Mar 2012 16:09:47 -0800, vip152.sybase.com
Lines: 115
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9190
Article PK: 870354

Hmmmm, you're using a custom FS class? (Did I overlook that in a previous post?)

Curious ...

- did you assign another FS class as the parent of your custom FS class? or did you build your FS class as a standalone
base FS class?

- can you get the insert to work properly if you stick with the rs_sqlserver_function_class FS class? does the insert
continue to work if you then modify the rs_delete function (still using rs_sqlserver_function_class)?

Function string classes can be tricky to get working correctly if some basic concepts are glossed over and/or missed;
and then they become a b*tch to diagnose/fix. ("Duh, Mark!" ?)

On 03/21/2012 12:04, rick_906 wrote:
> Apparently Sybase does not know what is causing this either,
> so far I have rebuilt repdefs/sub without custom FS class
> (even though we only change the rs_delete), recreated the
> PDB/RDB tables and create new repdef/sub without custom
> FSclass (same issue). Now they are telling me to rebuild the
> entire rep server and try again without using custom FS
> class.
>
>>> You may have already done a lot of the following, but
>>> since you haven't explicitly listed all the steps you've
>>> taken ...
>>>
>>> - verify the dev and prod copies of the PDB and RDB
>>> tables are identical - they are identical
>>>
>>> - verify the dev and prod repdefs are identical (column
>>> definitions, pk definition, replicate minimal/all
>>> columns, etc) --they are identical
>>>
>>> - capture the dev and prod versions of the SQL that's
>>> actually being submitted by the DSI (either pull from
>>> the repserver queue or the RDS's monSysSQLText table)
>> Dev leaves off the required first column, Prod does not.
>>>
>>> I'd be curious to see if the DSI is sending through a
>>> NULL for the ident/numeric column value, or if it's
>>> submitting a column list (sans ident column name) and
>>> because the RDB table column is not defined as
>>> 'identity' then the missing column/value in the insert
>>> statement is causing the RDB to assign a default value
>>> of NULL into a non-NULLable column. In other words,
>>> which of the following do your dev/prod DSIs submit to
>> the RDB:>
>>> insert table (identcol, col1, col2) values (NULL
>>> ,'a' ,'b')
>>> insert table (col1, col2) values ('a','b') --
>>> identcol implicitly set to NULL --it is sending a
>> col/values list and the first col/value is missing, it
>> needs to replciate the value assigned by IDENTITY in PDB
>> to the RDB
>>>
>>> NOTE: If you can run your test in a relatively quiet
>>> setup I'd recommend quiescing rep, suspending the DSI,
>>> performing the insert in the PDB, resume the DSI, and
>>> pull all of the recent maintuser queries from
>>> monSysSQLText in the RDS. You're looking for the set of
>>> initial commands being issued by the DSI connection when
>>> it first connects as well as any commands preceding the
>>> insert to your table (eg, set triggers off, set
>>> identity_insert on, etc).
>>>
>>> - are you running different ASE and/or RS versions
>>> between dev and prod? yes, Rep 12.5 in Prod, 15.6 in DEV
>> , ASE is 15.0.3 in Prod, 15.0.1 in DEV
>>>
>>> Nope, these steps aren't going to *tell* you what the
>>> problem is but they may help zero in on where the issue
>>> lies.
>>>
>>> On 03/02/2012 13:52, rick_806 wrote:
>>>> That doesn't help either. Although the PDS table
>>>> column is a identity, the repdef treats it as numeric
>>>> and the replicate table does not have that column as
>>>> identity so the doc does not explain what happens when
>>>> a identity column is replicated to a non-identity
>>>> column. However, this is development and I have the
>>>> same repdef/sub in production and it works correctly.
>>>>
>>>>> Sorry, should have been
>>>>>
>>>>
>>>
>>
> http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32511.1570/doc/html/san1275527333935.html
>>>>>
>>>>>
>>>>> On 3/2/2012 8:05 PM, peta62 wrote:
>>>>>> Hi Rick,
>>>>>> did you check
>>>>>>
>>>>>
>>>>
>>>
>>>
>> http://infocenter.sybase.com/help/index.jsp?workingSet=All
>>> topics>>> ? Cheers,>>> Peter
>>>>>>
>>>>>>
>>>>>> On 3/2/2012 4:28 PM, rick_806 wrote:
>>>>>>> Rep Svr 15.6, ASE 15.0.1 I have a repdef defined
>>> that>>>> include a PK column that is also an identity.
>>> The>>>> subscription takes all records from the repdef
>>> (no>> select).>> When Rep Svr creates the transactions
>>> for>> replicate side it>> is leaving off the 1st
>>> column>> (identity PK). The replicate>> table has same
>>> column as>> numerci, not identity. Any idea why>> Rep
>>> Svr would>> ignore this column?>>
>>>>>>> Thx,
>>>>>>> rick_806
>>>>>>
>>>>>


rick_806 Posted on 2012-04-16 14:59:42.0Z
Sender: 578.4f8c2f37.1804289383@sybase.com
From: rick_806
Newsgroups: sybase.public.rep-server
Subject: Re: Rep Svr not reping column
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f8c33de.623.1681692777@sybase.com>
References: <4f6a6dcb$1@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 16 Apr 2012 07:59:42 -0700
X-Trace: forums-1-dub 1334588382 172.20.134.41 (16 Apr 2012 07:59:42 -0700)
X-Original-Trace: 16 Apr 2012 07:59:42 -0700, 172.20.134.41
Lines: 210
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9199
Article PK: 870363

Hi,

I have simplified this issue. I recreated the rep server
15.6 from scratch. I created a table with identity column
primary key and replicate table with numeric column Pk.
Created repdef & subscription. This does not work, it
ignores the identity column even though it is identified as
the primary key in the repdef. I am not using any functions
at all. I've had a ticket open with Sybase for over a month
and they have done nothing but tell me over & over I
"corrupted the function string class". This is obviously not
the case as I am now using the default class with no
changes. The only thing unusual about this setup is that I
am using the same ASE server as PDS & RDS, but different
DB's.

PDT DDL:
CREATE TABLE db1.ascent.PackagesMetaData
(
packagesMetadataId numeric(10,0) IDENTITY,
packageId varchar(64) DEFAULT '' NOT NULL,
packageInstanceKey numeric(7,0) DEFAULT 1 NOT NULL,
memberName varchar(64) DEFAULT '' NOT NULL,
memberAsString varchar(255) DEFAULT '' NULL,
memberUseType char(1) DEFAULT '' NOT NULL,
contentName varchar(64) DEFAULT '' NOT NULL,
parent numeric(10,0) NULL,
isContainer tinyint NULL,
isMcpPointer tinyint NULL,
memberData image NULL,
memberAsDate datetime NULL,
memberAsInt int NULL,
memberAsFloat float NULL,
CONSTRAINT PackagesMetaDataIndex1
PRIMARY KEY NONCLUSTERED (packagesMetadataId),
CONSTRAINT PackagesMetaDataIndex2
UNIQUE NONCLUSTERED (packageId,memberName,contentName),
CONSTRAINT PackagesMetaDataIndex3
UNIQUE NONCLUSTERED
(packageId,packageInstanceKey,memberName,contentName)
)
LOCK ALLPAGES

RDT:
CREATE TABLE db2.dbo.PackagesMetaData
(
packagesMetaDataId numeric(10,0) NOT NULL,
packageId varchar(25) NOT NULL,
name varchar(64) NOT NULL,
value varchar(255) NULL,
WHdateInserted datetime DEFAULT getdate() NOT
NULL,
WHdateLastModified datetime DEFAULT getdate() NOT
NULL,
WHdateDeleteReceived datetime NULL,
packageInstanceKey numeric(7,0) DEFAULT 1 NOT
NULL,
CONSTRAINT PackagesMetaData_PK
PRIMARY KEY CLUSTERED
(packagesMetaDataId,packageInstanceKey)
)
LOCK ALLPAGES

REPDEF:
create replication definition rd_ascent_PkgsMetaData
with primary at dev09.housedb_arc
with primary table named ascent.PackagesMetaData
with replicate table named dbo.PackagesMetaData
( packagesMetaDataId numeric
, packageId varchar(25)
, memberName as "name" varchar(64)
, memberAsString as value varchar(255)
, packageInstanceKey numeric
)
primary key
(packagesMetaDataId,packageInstanceKey)
replicate all columns

Subscription:
create subscription ascent_PkgsMetaData
for rd_ascent_PkgsMetaData
with replicate at dev09.ascent_report
without materialization

thx,
rick_806

> Hmmmm, you're using a custom FS class? (Did I overlook
> that in a previous post?)
>
> Curious ...
>
> - did you assign another FS class as the parent of your
> custom FS class? or did you build your FS class as a
> standalone base FS class?
>
> - can you get the insert to work properly if you stick
> with the rs_sqlserver_function_class FS class? does the
> insert continue to work if you then modify the rs_delete
> function (still using rs_sqlserver_function_class)?
>
> Function string classes can be tricky to get working
> correctly if some basic concepts are glossed over and/or
> missed; and then they become a b*tch to diagnose/fix.
> ("Duh, Mark!" ?)
>
> On 03/21/2012 12:04, rick_906 wrote:
> > Apparently Sybase does not know what is causing this
> > either, so far I have rebuilt repdefs/sub without custom
> > FS class (even though we only change the rs_delete),
> > recreated the PDB/RDB tables and create new repdef/sub
> > without custom FSclass (same issue). Now they are
> > telling me to rebuild the entire rep server and try
> > again without using custom FS class.
> >
> >>> You may have already done a lot of the following, but
> >>> since you haven't explicitly listed all the steps
> you've >>> taken ...
> >>>
> >>> - verify the dev and prod copies of the PDB and RDB
> >>> tables are identical - they are identical
> >>>
> >>> - verify the dev and prod repdefs are identical
> (column >>> definitions, pk definition, replicate
> minimal/all >>> columns, etc) --they are identical
> >>>
> >>> - capture the dev and prod versions of the SQL that's
> >>> actually being submitted by the DSI (either pull from
> >>> the repserver queue or the RDS's monSysSQLText table)
> >> Dev leaves off the required first column, Prod does
> not. >>>
> >>> I'd be curious to see if the DSI is sending through a
> >>> NULL for the ident/numeric column value, or if it's
> >>> submitting a column list (sans ident column name) and
> >>> because the RDB table column is not defined as
> >>> 'identity' then the missing column/value in the
> insert >>> statement is causing the RDB to assign a
> default value >>> of NULL into a non-NULLable column. In
> other words, >>> which of the following do your dev/prod
> DSIs submit to >> the RDB:>
> >>> insert table (identcol, col1, col2) values (NULL
> >>> ,'a' ,'b')
> >>> insert table (col1, col2) values ('a','b') --
> >>> identcol implicitly set to NULL --it is sending a
> >> col/values list and the first col/value is missing, it
> >> needs to replciate the value assigned by IDENTITY in
> PDB >> to the RDB
> >>>
> >>> NOTE: If you can run your test in a relatively quiet
> >>> setup I'd recommend quiescing rep, suspending the DSI,
> >>> performing the insert in the PDB, resume the DSI, and
> >>> pull all of the recent maintuser queries from
> >>> monSysSQLText in the RDS. You're looking for the set
> of >>> initial commands being issued by the DSI connection
> when >>> it first connects as well as any commands
> preceding the >>> insert to your table (eg, set triggers
> off, set >>> identity_insert on, etc).
> >>>
> >>> - are you running different ASE and/or RS versions
> >>> between dev and prod? yes, Rep 12.5 in Prod, 15.6 in
> DEV >> , ASE is 15.0.3 in Prod, 15.0.1 in DEV
> >>>
> >>> Nope, these steps aren't going to *tell* you what the
> >>> problem is but they may help zero in on where the
> issue >>> lies.
> >>>
> >>> On 03/02/2012 13:52, rick_806 wrote:
> >>>> That doesn't help either. Although the PDS table
> >>>> column is a identity, the repdef treats it as numeric
> >>>> and the replicate table does not have that column as
> >>>> identity so the doc does not explain what happens
> when >>>> a identity column is replicated to a
> non-identity >>>> column. However, this is development and
> I have the >>>> same repdef/sub in production and it works
> correctly. >>>>
> >>>>> Sorry, should have been
> >>>>>
> >>>>
> >>>
> >>
> >
>
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32511.1570/doc/html/san1275527333935.html
> >>>>>
> >>>>>
> >>>>> On 3/2/2012 8:05 PM, peta62 wrote:
> >>>>>> Hi Rick,
> >>>>>> did you check
> >>>>>>
> >>>>>
> >>>>
> >>>
> >>>
> >>
> http://infocenter.sybase.com/help/index.jsp?workingSet=All
> >>> topics>>> ? Cheers,>>> Peter >>>>>>
> >>>>>>
> >>>>>> On 3/2/2012 4:28 PM, rick_806 wrote:
> >>>>>>> Rep Svr 15.6, ASE 15.0.1 I have a repdef defined
> >>> that>>>> include a PK column that is also an
> identity. >>> The>>>> subscription takes all records from
> the repdef >>> (no>> select).>> When Rep Svr creates
> the transactions >>> for>> replicate side it>> is
> leaving off the 1st >>> column>> (identity PK). The
> replicate>> table has same >>> column as>> numerci, not
> identity. Any idea why>> Rep >>> Svr would>> ignore
> this column?>> >>>>>>> Thx,
> >>>>>>> rick_806
> >>>>>>
> >>>>>


"Mark A. Parsons" <iron_horse Posted on 2012-04-17 02:01:17.0Z
From: "Mark A. Parsons" <iron_horse@no_spamola.compuserve.com>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.9.2.13) Gecko/20101207 Lightning/1.0b2 Thunderbird/3.1.7
MIME-Version: 1.0
Newsgroups: sybase.public.rep-server
Subject: Re: Rep Svr not reping column
References: <4f6a6dcb$1@forums-1-dub> <4f8c33de.623.1681692777@sybase.com>
In-Reply-To: <4f8c33de.623.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f8cceed$1@forums-1-dub>
Date: 16 Apr 2012 19:01:17 -0700
X-Trace: forums-1-dub 1334628077 10.22.241.152 (16 Apr 2012 19:01:17 -0700)
X-Original-Trace: 16 Apr 2012 19:01:17 -0700, vip152.sybase.com
Lines: 244
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9200
Article PK: 870361

I was able to reproduce your issue (packagesMetaDataId being ignored/dropped by the DSI) with your code snippet ... and
you'll probably want to kick yourself ...

Your PDB table's column name: packagesMetadataId
Your RDB table's column name: packagesMetaDataId
Your repdef's column name: packagesMetaDataId

Look very closely ... see *any* difference in the spelling?

In your PDB you've got a lower case 'd' for 'data', while the RDB and repdef column has a upper case 'd' for 'Data'.

I'm assuming your system is setup like mine ... using a case-sensitive sort order ... in which case 'data' != 'Data'.

Sooooo ...

- repagent sends over a little 'd'/'packagesMetadataId'

- repdef is looking for a big 'D'/'packagesMetaDataId' so it ignores the little 'd'/'packagesMetadataID' sent by the
repagent (ie, repdef thinks these are 2 distinct/different columns)

- DSI builds the insert with the columns it's provided (ie, no value is provided for big 'D'/'packagesMetaDataId'),
hence the reason your insert is missing the big 'D'/packagesMetaDataId' column

If you change your repdef column name to match the column name from the PDB table ... you should still see the DSI go
down but with a different error ... something along the lines of little 'd'/'packagesMetadataId' is an invalid column
(in the RDB table).

You'll either want to use the same case in the PDB table and repdef and RDB table, or you could match the repdef column
to the PDB table spelling and then use a 'as packagesMetaDataId' clause in the repdef column definition to map to the
different spelling in the RDB table. (Third option would be to switch to a case insensitive sort order all around.)

On 04/16/2012 08:59, rick_806 wrote:
> Hi,
>
> I have simplified this issue. I recreated the rep server
> 15.6 from scratch. I created a table with identity column
> primary key and replicate table with numeric column Pk.
> Created repdef& subscription. This does not work, it
> ignores the identity column even though it is identified as
> the primary key in the repdef. I am not using any functions
> at all. I've had a ticket open with Sybase for over a month
> and they have done nothing but tell me over& over I
> "corrupted the function string class". This is obviously not
> the case as I am now using the default class with no
> changes. The only thing unusual about this setup is that I
> am using the same ASE server as PDS& RDS, but different
> DB's.
>
> PDT DDL:
> CREATE TABLE db1.ascent.PackagesMetaData
> (
> packagesMetadataId numeric(10,0) IDENTITY,
> packageId varchar(64) DEFAULT '' NOT NULL,
> packageInstanceKey numeric(7,0) DEFAULT 1 NOT NULL,
> memberName varchar(64) DEFAULT '' NOT NULL,
> memberAsString varchar(255) DEFAULT '' NULL,
> memberUseType char(1) DEFAULT '' NOT NULL,
> contentName varchar(64) DEFAULT '' NOT NULL,
> parent numeric(10,0) NULL,
> isContainer tinyint NULL,
> isMcpPointer tinyint NULL,
> memberData image NULL,
> memberAsDate datetime NULL,
> memberAsInt int NULL,
> memberAsFloat float NULL,
> CONSTRAINT PackagesMetaDataIndex1
> PRIMARY KEY NONCLUSTERED (packagesMetadataId),
> CONSTRAINT PackagesMetaDataIndex2
> UNIQUE NONCLUSTERED (packageId,memberName,contentName),
> CONSTRAINT PackagesMetaDataIndex3
> UNIQUE NONCLUSTERED
> (packageId,packageInstanceKey,memberName,contentName)
> )
> LOCK ALLPAGES
>
> RDT:
> CREATE TABLE db2.dbo.PackagesMetaData
> (
> packagesMetaDataId numeric(10,0) NOT NULL,
> packageId varchar(25) NOT NULL,
> name varchar(64) NOT NULL,
> value varchar(255) NULL,
> WHdateInserted datetime DEFAULT getdate() NOT
> NULL,
> WHdateLastModified datetime DEFAULT getdate() NOT
> NULL,
> WHdateDeleteReceived datetime NULL,
> packageInstanceKey numeric(7,0) DEFAULT 1 NOT
> NULL,
> CONSTRAINT PackagesMetaData_PK
> PRIMARY KEY CLUSTERED
> (packagesMetaDataId,packageInstanceKey)
> )
> LOCK ALLPAGES
>
> REPDEF:
> create replication definition rd_ascent_PkgsMetaData
> with primary at dev09.housedb_arc
> with primary table named ascent.PackagesMetaData
> with replicate table named dbo.PackagesMetaData
> ( packagesMetaDataId numeric
> , packageId varchar(25)
> , memberName as "name" varchar(64)
> , memberAsString as value varchar(255)
> , packageInstanceKey numeric
> )
> primary key
> (packagesMetaDataId,packageInstanceKey)
> replicate all columns
>
> Subscription:
> create subscription ascent_PkgsMetaData
> for rd_ascent_PkgsMetaData
> with replicate at dev09.ascent_report
> without materialization
>
> thx,
> rick_806
>
>> Hmmmm, you're using a custom FS class? (Did I overlook
>> that in a previous post?)
>>
>> Curious ...
>>
>> - did you assign another FS class as the parent of your
>> custom FS class? or did you build your FS class as a
>> standalone base FS class?
>>
>> - can you get the insert to work properly if you stick
>> with the rs_sqlserver_function_class FS class? does the
>> insert continue to work if you then modify the rs_delete
>> function (still using rs_sqlserver_function_class)?
>>
>> Function string classes can be tricky to get working
>> correctly if some basic concepts are glossed over and/or
>> missed; and then they become a b*tch to diagnose/fix.
>> ("Duh, Mark!" ?)
>>
>> On 03/21/2012 12:04, rick_906 wrote:
>>> Apparently Sybase does not know what is causing this
>>> either, so far I have rebuilt repdefs/sub without custom
>>> FS class (even though we only change the rs_delete),
>>> recreated the PDB/RDB tables and create new repdef/sub
>>> without custom FSclass (same issue). Now they are
>>> telling me to rebuild the entire rep server and try
>>> again without using custom FS class.
>>>
>>>>> You may have already done a lot of the following, but
>>>>> since you haven't explicitly listed all the steps
>> you've>>> taken ...
>>>>>
>>>>> - verify the dev and prod copies of the PDB and RDB
>>>>> tables are identical - they are identical
>>>>>
>>>>> - verify the dev and prod repdefs are identical
>> (column>>> definitions, pk definition, replicate
>> minimal/all>>> columns, etc) --they are identical
>>>>>
>>>>> - capture the dev and prod versions of the SQL that's
>>>>> actually being submitted by the DSI (either pull from
>>>>> the repserver queue or the RDS's monSysSQLText table)
>>>> Dev leaves off the required first column, Prod does
>> not.>>>
>>>>> I'd be curious to see if the DSI is sending through a
>>>>> NULL for the ident/numeric column value, or if it's
>>>>> submitting a column list (sans ident column name) and
>>>>> because the RDB table column is not defined as
>>>>> 'identity' then the missing column/value in the
>> insert>>> statement is causing the RDB to assign a
>> default value>>> of NULL into a non-NULLable column. In
>> other words,>>> which of the following do your dev/prod
>> DSIs submit to>> the RDB:>
>>>>> insert table (identcol, col1, col2) values (NULL
>>>>> ,'a' ,'b')
>>>>> insert table (col1, col2) values ('a','b') --
>>>>> identcol implicitly set to NULL --it is sending a
>>>> col/values list and the first col/value is missing, it
>>>> needs to replciate the value assigned by IDENTITY in
>> PDB>> to the RDB
>>>>>
>>>>> NOTE: If you can run your test in a relatively quiet
>>>>> setup I'd recommend quiescing rep, suspending the DSI,
>>>>> performing the insert in the PDB, resume the DSI, and
>>>>> pull all of the recent maintuser queries from
>>>>> monSysSQLText in the RDS. You're looking for the set
>> of>>> initial commands being issued by the DSI connection
>> when>>> it first connects as well as any commands
>> preceding the>>> insert to your table (eg, set triggers
>> off, set>>> identity_insert on, etc).
>>>>>
>>>>> - are you running different ASE and/or RS versions
>>>>> between dev and prod? yes, Rep 12.5 in Prod, 15.6 in
>> DEV>> , ASE is 15.0.3 in Prod, 15.0.1 in DEV
>>>>>
>>>>> Nope, these steps aren't going to *tell* you what the
>>>>> problem is but they may help zero in on where the
>> issue>>> lies.
>>>>>
>>>>> On 03/02/2012 13:52, rick_806 wrote:
>>>>>> That doesn't help either. Although the PDS table
>>>>>> column is a identity, the repdef treats it as numeric
>>>>>> and the replicate table does not have that column as
>>>>>> identity so the doc does not explain what happens
>> when>>>> a identity column is replicated to a
>> non-identity>>>> column. However, this is development and
>> I have the>>>> same repdef/sub in production and it works
>> correctly.>>>>
>>>>>>> Sorry, should have been
>>>>>>>
>>>>>>
>>>>>
>>>>
>>>
>>
> http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32511.1570/doc/html/san1275527333935.html
>>>>>>>
>>>>>>>
>>>>>>> On 3/2/2012 8:05 PM, peta62 wrote:
>>>>>>>> Hi Rick,
>>>>>>>> did you check
>>>>>>>>
>>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>> http://infocenter.sybase.com/help/index.jsp?workingSet=All
>>>>> topics>>> ? Cheers,>>> Peter>>>>>>
>>>>>>>>
>>>>>>>> On 3/2/2012 4:28 PM, rick_806 wrote:
>>>>>>>>> Rep Svr 15.6, ASE 15.0.1 I have a repdef defined
>>>>> that>>>> include a PK column that is also an
>> identity.>>> The>>>> subscription takes all records from
>> the repdef>>> (no>> select).>> When Rep Svr creates
>> the transactions>>> for>> replicate side it>> is
>> leaving off the 1st>>> column>> (identity PK). The
>> replicate>> table has same>>> column as>> numerci, not
>> identity. Any idea why>> Rep>>> Svr would>> ignore
>> this column?>> >>>>>>> Thx,
>>>>>>>>> rick_806
>>>>>>>>
>>>>>>>


rick_806 Posted on 2012-04-19 17:31:29.0Z
Sender: 1dc2.4f904b4f.1804289383@sybase.com
From: rick_806
Newsgroups: sybase.public.rep-server
Subject: Re: Rep Svr not reping column
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f904bf0.1dd3.1681692777@sybase.com>
References: <4f8cceed$1@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 19 Apr 2012 10:31:29 -0700
X-Trace: forums-1-dub 1334856689 172.20.134.41 (19 Apr 2012 10:31:29 -0700)
X-Original-Trace: 19 Apr 2012 10:31:29 -0700, 172.20.134.41
Lines: 266
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9201
Article PK: 870365

That's great, I've had a ticket open with Sybase for over a
month on this. Figures it was something on my side, I
couldn't believe that Rep server was ignoring it without an
error.

> I was able to reproduce your issue (packagesMetaDataId
> being ignored/dropped by the DSI) with your code snippet
> .. and you'll probably want to kick yourself ...
>
> Your PDB table's column name: packagesMetadataId
> Your RDB table's column name: packagesMetaDataId
> Your repdef's column name: packagesMetaDataId
>
> Look very closely ... see *any* difference in the
> spelling?
>
> In your PDB you've got a lower case 'd' for 'data', while
> the RDB and repdef column has a upper case 'd' for 'Data'.
>
> I'm assuming your system is setup like mine ... using a
> case-sensitive sort order ... in which case 'data' !=
> 'Data'.
>
> Sooooo ...
>
> - repagent sends over a little 'd'/'packagesMetadataId'
>
> - repdef is looking for a big 'D'/'packagesMetaDataId' so
> it ignores the little 'd'/'packagesMetadataID' sent by the
> repagent (ie, repdef thinks these are 2 distinct/different
> columns)
>
> - DSI builds the insert with the columns it's provided (ie
> , no value is provided for big 'D'/'packagesMetaDataId'),
> hence the reason your insert is missing the big
> 'D'/packagesMetaDataId' column
>
> If you change your repdef column name to match the column
> name from the PDB table ... you should still see the DSI
> go down but with a different error ... something along
> the lines of little 'd'/'packagesMetadataId' is an invalid
> column (in the RDB table).
>
> You'll either want to use the same case in the PDB table
> and repdef and RDB table, or you could match the repdef
> column to the PDB table spelling and then use a 'as
> packagesMetaDataId' clause in the repdef column definition
> to map to the different spelling in the RDB table.
> (Third option would be to switch to a case insensitive
> sort order all around.)
>
>
>
> On 04/16/2012 08:59, rick_806 wrote:
> > Hi,
> >
> > I have simplified this issue. I recreated the rep server
> > 15.6 from scratch. I created a table with identity
> > column primary key and replicate table with numeric
> > column Pk. Created repdef& subscription. This does not
> > work, it ignores the identity column even though it is
> > identified as the primary key in the repdef. I am not
> > using any functions at all. I've had a ticket open with
> > Sybase for over a month and they have done nothing but
> > tell me over& over I "corrupted the function string
> > class". This is obviously not the case as I am now using
> > the default class with no changes. The only thing
> > unusual about this setup is that I am using the same ASE
> > server as PDS& RDS, but different DB's.
> >
> > PDT DDL:
> > CREATE TABLE db1.ascent.PackagesMetaData
> > (
> > packagesMetadataId numeric(10,0) IDENTITY,
> > packageId varchar(64) DEFAULT '' NOT
> > NULL, packageInstanceKey numeric(7,0) DEFAULT 1
> > NOT NULL, memberName varchar(64) DEFAULT
> > '' NOT NULL, memberAsString varchar(255)
> > DEFAULT '' NULL, memberUseType char(1)
> > DEFAULT '' NOT NULL, contentName varchar(64)
> > DEFAULT '' NOT NULL, parent
> > numeric(10,0) NULL, isContainer tinyint
> > NULL, isMcpPointer tinyint NULL,
> > memberData image NULL,
> > memberAsDate datetime NULL,
> > memberAsInt int NULL,
> > memberAsFloat float NULL,
> > CONSTRAINT PackagesMetaDataIndex1
> > PRIMARY KEY NONCLUSTERED (packagesMetadataId),
> > CONSTRAINT PackagesMetaDataIndex2
> > UNIQUE NONCLUSTERED (packageId,memberName
> > ,contentName), CONSTRAINT PackagesMetaDataIndex3
> > UNIQUE NONCLUSTERED
> > (packageId,packageInstanceKey,memberName,contentName)
> > )
> > LOCK ALLPAGES
> >
> > RDT:
> > CREATE TABLE db2.dbo.PackagesMetaData
> > (
> > packagesMetaDataId numeric(10,0) NOT NULL,
> > packageId varchar(25) NOT NULL,
> > name varchar(64) NOT NULL,
> > value varchar(255) NULL,
> > WHdateInserted datetime DEFAULT
> > getdate() NOT NULL,
> > WHdateLastModified datetime DEFAULT
> > getdate() NOT NULL,
> > WHdateDeleteReceived datetime NULL,
> > packageInstanceKey numeric(7,0) DEFAULT 1
> > NOT NULL,
> > CONSTRAINT PackagesMetaData_PK
> > PRIMARY KEY CLUSTERED
> > (packagesMetaDataId,packageInstanceKey)
> > )
> > LOCK ALLPAGES
> >
> > REPDEF:
> > create replication definition rd_ascent_PkgsMetaData
> > with primary at dev09.housedb_arc
> > with primary table named ascent.PackagesMetaData
> > with replicate table named dbo.PackagesMetaData
> > ( packagesMetaDataId numeric
> > , packageId varchar(25)
> > , memberName as "name" varchar(64)
> > , memberAsString as value varchar(255)
> > , packageInstanceKey numeric
> > )
> > primary key
> > (packagesMetaDataId,packageInstanceKey)
> > replicate all columns
> >
> > Subscription:
> > create subscription ascent_PkgsMetaData
> > for rd_ascent_PkgsMetaData
> > with replicate at dev09.ascent_report
> > without materialization
> >
> > thx,
> > rick_806
> >
> >> Hmmmm, you're using a custom FS class? (Did I overlook
> >> that in a previous post?)
> >>
> >> Curious ...
> >>
> >> - did you assign another FS class as the parent of your
> >> custom FS class? or did you build your FS class as a
> >> standalone base FS class?
> >>
> >> - can you get the insert to work properly if you stick
> >> with the rs_sqlserver_function_class FS class? does
> the >> insert continue to work if you then modify the
> rs_delete >> function (still using
> rs_sqlserver_function_class)? >>
> >> Function string classes can be tricky to get working
> >> correctly if some basic concepts are glossed over
> and/or >> missed; and then they become a b*tch to
> diagnose/fix. >> ("Duh, Mark!" ?)
> >>
> >> On 03/21/2012 12:04, rick_906 wrote:
> >>> Apparently Sybase does not know what is causing this
> >>> either, so far I have rebuilt repdefs/sub without
> custom >>> FS class (even though we only change the
> rs_delete), >>> recreated the PDB/RDB tables and create
> new repdef/sub >>> without custom FSclass (same issue).
> Now they are >>> telling me to rebuild the entire rep
> server and try >>> again without using custom FS class.
> >>>
> >>>>> You may have already done a lot of the following,
> but >>>>> since you haven't explicitly listed all the
> steps >> you've>>> taken ...
> >>>>>
> >>>>> - verify the dev and prod copies of the PDB and RDB
> >>>>> tables are identical - they are identical
> >>>>>
> >>>>> - verify the dev and prod repdefs are identical
> >> (column>>> definitions, pk definition, replicate
> >> minimal/all>>> columns, etc) --they are identical
> >>>>>
> >>>>> - capture the dev and prod versions of the SQL
> that's >>>>> actually being submitted by the DSI (either
> pull from >>>>> the repserver queue or the RDS's
> monSysSQLText table) >>>> Dev leaves off the required
> first column, Prod does >> not.>>>
> >>>>> I'd be curious to see if the DSI is sending through
> a >>>>> NULL for the ident/numeric column value, or if
> it's >>>>> submitting a column list (sans ident column
> name) and >>>>> because the RDB table column is not
> defined as >>>>> 'identity' then the missing column/value
> in the >> insert>>> statement is causing the RDB to
> assign a >> default value>>> of NULL into a non-NULLable
> column. In >> other words,>>> which of the following do
> your dev/prod >> DSIs submit to>> the RDB:>
> >>>>> insert table (identcol, col1, col2) values
> (NULL >>>>> ,'a' ,'b')
> >>>>> insert table (col1, col2) values ('a','b') --
> >>>>> identcol implicitly set to NULL --it is sending a
> >>>> col/values list and the first col/value is missing,
> it >>>> needs to replciate the value assigned by IDENTITY
> in >> PDB>> to the RDB
> >>>>>
> >>>>> NOTE: If you can run your test in a relatively
> quiet >>>>> setup I'd recommend quiescing rep, suspending
> the DSI, >>>>> performing the insert in the PDB, resume
> the DSI, and >>>>> pull all of the recent maintuser
> queries from >>>>> monSysSQLText in the RDS. You're
> looking for the set >> of>>> initial commands being
> issued by the DSI connection >> when>>> it first connects
> as well as any commands >> preceding the>>> insert to
> your table (eg, set triggers >> off, set>>>
> identity_insert on, etc). >>>>>
> >>>>> - are you running different ASE and/or RS versions
> >>>>> between dev and prod? yes, Rep 12.5 in Prod, 15.6 in
> >> DEV>> , ASE is 15.0.3 in Prod, 15.0.1 in DEV
> >>>>>
> >>>>> Nope, these steps aren't going to *tell* you what
> the >>>>> problem is but they may help zero in on where
> the >> issue>>> lies.
> >>>>>
> >>>>> On 03/02/2012 13:52, rick_806 wrote:
> >>>>>> That doesn't help either. Although the PDS table
> >>>>>> column is a identity, the repdef treats it as
> numeric >>>>>> and the replicate table does not have that
> column as >>>>>> identity so the doc does not explain what
> happens >> when>>>> a identity column is replicated to a
> >> non-identity>>>> column. However, this is development
> and >> I have the>>>> same repdef/sub in production and
> it works >> correctly.>>>>
> >>>>>>> Sorry, should have been
> >>>>>>>
> >>>>>>
> >>>>>
> >>>>
> >>>
> >>
> >
>
http://infocenter.sybase.com/help/index.jsp?topic=/com.sybase.infocenter.dc32511.1570/doc/html/san1275527333935.html
> >>>>>>>
> >>>>>>>
> >>>>>>> On 3/2/2012 8:05 PM, peta62 wrote:
> >>>>>>>> Hi Rick,
> >>>>>>>> did you check
> >>>>>>>>
> >>>>>>>
> >>>>>>
> >>>>>
> >>>>>
> >>>>
> >>
> http://infocenter.sybase.com/help/index.jsp?workingSet=All
> >>>>> topics>>> ? Cheers,>>> Peter>>>>>> >>>>>>>>
> >>>>>>>> On 3/2/2012 4:28 PM, rick_806 wrote:
> >>>>>>>>> Rep Svr 15.6, ASE 15.0.1 I have a repdef defined
> >>>>> that>>>> include a PK column that is also an
> >> identity.>>> The>>>> subscription takes all records
> from >> the repdef>>> (no>> select).>> When Rep Svr
> creates >> the transactions>>> for>> replicate side
> it>> is >> leaving off the 1st>>> column>> (identity
> PK). The >> replicate>> table has same>>> column as>>
> numerci, not >> identity. Any idea why>> Rep>>> Svr
> would>> ignore >> this column?>> >>>>>>> Thx,
> >>>>>>>>> rick_806
> >>>>>>>>
> >>>>>>>


rick_806 Posted on 2012-03-02 20:47:48.0Z
Sender: 6ccb.4f50e683.1804289383@sybase.com
From: rick_806
Newsgroups: sybase.public.rep-server
Subject: Re: Rep Svr not reping column
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f5131f4.7825.1681692777@sybase.com>
References: <4f5119e8@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 2 Mar 2012 12:47:48 -0800
X-Trace: forums-1-dub 1330721268 172.20.134.41 (2 Mar 2012 12:47:48 -0800)
X-Original-Trace: 2 Mar 2012 12:47:48 -0800, 172.20.134.41
Lines: 34
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9166
Article PK: 870329

You mean did I check the basic docs?
Since there is no error involved other than:

Message from server: Message: 233, State 2, Severity 16 --
'The column packagesMDataId in table dbo.PackagesMData does
not allow null values. '. H. 2012/03/01 10:11:42. THREAD
FATAL ERROR #5049 DSI EXEC(112(1)

I wouldnt' know what to read to resolve this. The error is
obvious but so is the excepted transaction, it is attempting
to write a record wihout including a non-null column. But
that doesn't tell me why it isn't replcating the column.

> Hi Rick,
> did you check
> http://infocenter.sybase.com/help/index.jsp?workingSet=All
topics
> ? Cheers,
> Peter
>
>
> On 3/2/2012 4:28 PM, rick_806 wrote:
> > Rep Svr 15.6, ASE 15.0.1 I have a repdef defined that
> > include a PK column that is also an identity. The
> > subscription takes all records from the repdef (no
> > select). When Rep Svr creates the transactions for
> > replicate side it is leaving off the 1st column
> > (identity PK). The replicate table has same column as
> > numerci, not identity. Any idea why Rep Svr would ignore
> this column? >
> > Thx,
> > rick_806
>


Jeff Tallman [Sybase] Posted on 2012-03-05 04:00:17.0Z
From: "Jeff Tallman [Sybase]" <jeff.tallman@sybase.com>
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:10.0.2) Gecko/20120216 Thunderbird/10.0.2
MIME-Version: 1.0
Newsgroups: sybase.public.rep-server
Subject: Re: Rep Svr not reping column
References: <4f5119e8@forums-1-dub> <4f5131f4.7825.1681692777@sybase.com>
In-Reply-To: <4f5131f4.7825.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4f543a51$1@forums-1-dub>
Date: 4 Mar 2012 20:00:17 -0800
X-Trace: forums-1-dub 1330920017 10.22.241.152 (4 Mar 2012 20:00:17 -0800)
X-Original-Trace: 4 Mar 2012 20:00:17 -0800, vip152.sybase.com
Lines: 44
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9176
Article PK: 870339

It may not be your identity column....use trace
"on","dsi","dsi_buf_dump" to see what exactly RS is sending when error
occurs (done automatically for you in RS 15.7 btw).....

What does the repdef look like??? Are there any other targets than the
one??

PS: I assume no one fudged the fstring?

On 3/2/2012 3:47 PM, rick_806 wrote:
> You mean did I check the basic docs?
> Since there is no error involved other than:
>
> Message from server: Message: 233, State 2, Severity 16 --
> 'The column packagesMDataId in table dbo.PackagesMData does
> not allow null values. '. H. 2012/03/01 10:11:42. THREAD
> FATAL ERROR #5049 DSI EXEC(112(1)
>
> I wouldnt' know what to read to resolve this. The error is
> obvious but so is the excepted transaction, it is attempting
> to write a record wihout including a non-null column. But
> that doesn't tell me why it isn't replcating the column.
>
>
>> Hi Rick,
>> did you check
>> http://infocenter.sybase.com/help/index.jsp?workingSet=All
> topics
>> ? Cheers,
>> Peter
>>
>>
>> On 3/2/2012 4:28 PM, rick_806 wrote:
>>> Rep Svr 15.6, ASE 15.0.1 I have a repdef defined that
>>> include a PK column that is also an identity. The
>>> subscription takes all records from the repdef (no
>>> select). When Rep Svr creates the transactions for
>>> replicate side it is leaving off the 1st column
>>> (identity PK). The replicate table has same column as
>>> numerci, not identity. Any idea why Rep Svr would ignore
>> this column?>
>>> Thx,
>>> rick_806
>>


rick_806 Posted on 2012-03-05 19:22:47.0Z
Sender: 4e6c.4f550f0c.1804289383@sybase.com
From: rick_806
Newsgroups: sybase.public.rep-server
Subject: Re: Rep Svr not reping column
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4f551287.4ef9.1681692777@sybase.com>
References: <4f543a51$1@forums-1-dub>
NNTP-Posting-Host: 172.20.134.41
X-Original-NNTP-Posting-Host: 172.20.134.41
Date: 5 Mar 2012 11:22:47 -0800
X-Trace: forums-1-dub 1330975367 172.20.134.41 (5 Mar 2012 11:22:47 -0800)
X-Original-Trace: 5 Mar 2012 11:22:47 -0800, 172.20.134.41
Lines: 51
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-server:9178
Article PK: 870341

that trace is already on, it is not sending either column
name or value for the fist column.

> It may not be your identity column....use trace
> "on","dsi","dsi_buf_dump" to see what exactly RS is
> sending when error occurs (done automatically for you in
> RS 15.7 btw).....
>
> What does the repdef look like??? Are there any other
> targets than the one??
>
> PS: I assume no one fudged the fstring?
>
> On 3/2/2012 3:47 PM, rick_806 wrote:
> > You mean did I check the basic docs?
> > Since there is no error involved other than:
> >
> > Message from server: Message: 233, State 2, Severity 16
> > -- 'The column packagesMDataId in table
> > dbo.PackagesMData does not allow null values. '. H.
> > 2012/03/01 10:11:42. THREAD FATAL ERROR #5049 DSI
> EXEC(112(1) >
> > I wouldnt' know what to read to resolve this. The error
> > is obvious but so is the excepted transaction, it is
> > attempting to write a record wihout including a non-null
> > column. But that doesn't tell me why it isn't replcating
> the column. >
> >
> >> Hi Rick,
> >> did you check
> >>
> >
> http://infocenter.sybase.com/help/index.jsp?workingSet=All
> topics >> ? Cheers,
> >> Peter
> >>
> >>
> >> On 3/2/2012 4:28 PM, rick_806 wrote:
> >>> Rep Svr 15.6, ASE 15.0.1 I have a repdef defined
> that >>> include a PK column that is also an identity. The
> >>> subscription takes all records from the repdef (no
> >>> select). When Rep Svr creates the transactions for
> >>> replicate side it is leaving off the 1st column
> >>> (identity PK). The replicate table has same column as
> >>> numerci, not identity. Any idea why Rep Svr would
> ignore >> this column?>
> >>> Thx,
> >>> rick_806
> >>