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.

Warm standby and replication > 128 columns causes error 32048

2 posts in Replication Agent Last posting was on 2005-06-15 00:48:18.0Z
Muralidharan Posted on 2005-06-09 01:53:15.0Z
Sender: 2164.42a79fae.1804289383@sybase.com
From: Muralidharan
Newsgroups: sybase.public.rep-agent
Subject: Warm standby and replication > 128 columns causes error 32048
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <42a7a10a.217c.1681692777@sybase.com>
MIME-Version: 1.0
Content-Type: multipart/mixed; boundary="-=_forums-1-dub42a7a10a"
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 8 Jun 2005 18:53:15 -0700
X-Trace: forums-1-dub 1118281995 10.22.241.41 (8 Jun 2005 18:53:15 -0700)
X-Original-Trace: 8 Jun 2005 18:53:15 -0700, 10.22.241.41
Lines: 172
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:802
Article PK: 862392

Hi all,

We've a situation where a table having 164 columns is
consistently failing to replicate in a Warm standby setup
with error 32048.

ERROR #32048 REP AGENT(SYB_HKGLS1_TKU.hk201_uat_intf) -
/nrm/nrm.c(540)
Can not replicate Table Swift_send_sdw without a Replication
Definition because it has more than 128 columns

The sequence of steps that causes this error is:
* insert 1 row to the table on active, it is correctly
replicated
* execute 'delete from table' and RepAgent goes down with
error 32048
* drop/recreate RepDef and restart RepAgent, goes down again
with same error

Attached is the RepDef used for this table.

I suspect that the orderID2 column defined as an identity
and as a primary key in both RepDef and on the table might
be causing this problem ?
Are there any problems with this RepDef ?

Any help is much appreciated.
Thanks in advance

The versions of products involved are:
ASE - 12.0.0.8 ESD2
REP - Replication Server/12.0/EBF 9593/Sun_svr4/OS
5.6/1/OPT/Tue Apr 17 15:53:37 PDT 2001

CREATE REPLICATION DEFINITION Swift_send_sdw
WITH PRIMARY AT SYB_HKGLS1_TKL.hk201_uat_intf
WITH ALL TABLES NAMED 'Swift_send_sdw'
(
cmd varchar(12),
old_Status char(1),
old_Seq_no numeric,
old_Action char(1),
old_MT_type char(1),
old_Trade_ref char(1),
old_Trade_ver int,
old_Inst_no int,
old_Related_Inst_no int,
old_Sender_ref char(1),
old_Related_sender_ref char(1),
old_Place char(1),
old_Trade_date datetime,
old_Settle_date datetime,
old_Client_ac char(1) ,
old_Sub_ac char(1) ,
old_Trade_type char(1) ,
old_ISIN_code char(1) ,
old_Sec_code char(1) ,
old_Sec_name_1 varchar(1),
old_Sec_name_2 varchar(1),
old_Price_type char(1) ,
old_Trade_price float ,
old_Buy_sell_id char(1) ,
old_Trade_qty float ,
old_Trade_ccy char(1) ,
old_Trade_amt float ,
old_Settle_ccy char(1) ,
old_Fx_rate float ,
old_Mul_Div_id char(1) ,
old_Comm float ,
old_Comm_settle_ccy float ,
old_Settle_amt float ,
old_Our_safe_ac char(1) ,
old_Our_cash_ac char(1) ,
old_Settle_narr_1 varchar(1),
old_Settle_narr_2 varchar(1),
old_Settle_narr_3 varchar(1),
old_Settle_narr_4 varchar(1),
old_Settle_narr_5 varchar(1),
old_Settle_narr_6 varchar(1),
old_Sett_place_id_type char(1) ,
old_Sett_place_country_code char(1) ,
old_Sett_place_id_code char(1) ,
old_Sett_place_addr_1 varchar(1),
old_Sett_place_addr_2 varchar(1),
old_Sett_place_addr_3 varchar(1),
old_Sett_place_addr_4 varchar(1),
old_Client_id_type char(1) ,
old_Client_id_code char(1) ,
old_Client_name_addr_1 varchar(1),
old_Client_name_addr_2 varchar(1),
old_Client_name_addr_3 varchar(1),
old_Client_name_addr_4 varchar(1),
old_Sub_ac_id_type char(1) ,
old_Sub_ac_id_code char(1) ,
old_Sub_ac_name_addr_1 varchar(1),
old_Sub_ac_name_addr_2 varchar(1),
old_Sub_ac_name_addr_3 varchar(1),
old_Sub_ac_name_addr_4 varchar(1),
old_Cpty_dr_agent_id_type char(1) ,
old_Cpty_dr_agent_id_code char(1) ,
old_Cpty_dr_agent_name_addr_1 varchar(1),
old_Cpty_dr_agent_name_addr_2 varchar(1),
old_Cpty_dr_agent_name_addr_3 varchar(1),
old_Cpty_dr_agent_name_addr_4 varchar(1),
old_Cpty_safe_ac_with_dr_agent char(1) ,
old_Cpty_cust_id_type char(1) ,
old_Cpty_cust_id_code char(1) ,
old_Cpty_cust_name_addr_1 varchar(1),
old_Cpty_cust_name_addr_2 varchar(1),
old_Cpty_cust_name_addr_3 varchar(1),
old_Cpty_cust_name_addr_4 varchar(1),
old_Cpty_safe_ac_with_cust char(1) ,
old_STCO char(1) ,
old_Our_depot_BIC_code char(1) ,
old_Our_nostro_BIC_code char(1) ,
old_Company_code char(1) ,
old_Our_BIC_code char(1) ,
old_Salesperson char(1) ,
old_Error_message varchar(1),
old_Timestamp datetime ,
new_Status char(1) ,
new_Seq_no numeric,
new_Action char(1) ,
new_MT_type char(3) ,
new_Trade_ref char(13) ,
new_Trade_ver int ,
new_Inst_no int ,
new_Related_Inst_no int ,
new_Sender_ref char(16) ,
new_Related_sender_ref char(16) ,
new_Place char(12) ,
new_Trade_date datetime ,
new_Settle_date datetime ,
new_Client_ac char(12) ,
new_Sub_ac char(12) ,
new_Trade_type char(4) ,
new_ISIN_code char(12) ,
new_Sec_code char(12) ,
new_Sec_name_1 varchar(35),
new_Sec_name_2 varchar(35),
new_Price_type char(4) ,
new_Trade_price float ,
new_Buy_sell_id char(4) ,
new_Trade_qty float ,
new_Trade_ccy char(3) ,
new_Trade_amt float ,
new_Settle_ccy char(3) ,
new_Fx_rate float ,
new_Mul_Div_id char(1) ,
new_Comm float ,
new_Comm_settle_ccy float ,
new_Settle_amt float ,
new_Our_safe_ac char(20) ,
new_Our_cash_ac char(20) ,
new_Settle_narr_1 varchar(35),
new_Settle_narr_2 varchar(35),
new_Settle_narr_3 varchar(35),
new_Settle_narr_4 varchar(35),
new_Settle_narr_5 varchar(35),
new_Settle_narr_6 varchar(35),
new_Sett_place_id_type char(1) ,
new_Sett_place_country_code char(2) ,
new_Sett_place_id_code char(12) ,
new_Sett_place_addr_1 varchar(35),
new_Sett_place_addr_2 varchar(35),
new_Sett_place_addr_3 varchar(35),
new_Sett_place_addr_4 varchar(35),
new_Client_id_type char(1) ,
new_Client_id_code char(12) ,
new_Client_name_addr_1 varchar(35),
new_Client_name_addr_2 varchar(35),
new_Client_name_addr_3 varchar(35),
new_Client_name_addr_4 varchar(35),
new_Sub_ac_id_type char(1) ,
new_Sub_ac_id_code char(12) ,
new_Sub_ac_name_addr_1 varchar(35),
new_Sub_ac_name_addr_2 varchar(35),
new_Sub_ac_name_addr_3 varchar(35),
new_Sub_ac_name_addr_4 varchar(35),
new_Cpty_dr_agent_id_type char(1) ,
new_Cpty_dr_agent_id_code char(12) ,
new_Cpty_dr_agent_name_addr_1 varchar(35),
new_Cpty_dr_agent_name_addr_2 varchar(35),
new_Cpty_dr_agent_name_addr_3 varchar(35),
new_Cpty_dr_agent_name_addr_4 varchar(35),
new_Cpty_safe_ac_with_dr_agent char(20) ,
new_Cpty_cust_id_type char(1) ,
new_Cpty_cust_id_code char(12) ,
new_Cpty_cust_name_addr_1 varchar(35),
new_Cpty_cust_name_addr_2 varchar(35),
new_Cpty_cust_name_addr_3 varchar(35),
new_Cpty_cust_name_addr_4 varchar(35),
new_Cpty_safe_ac_with_cust char(20) ,
new_STCO char(4) ,
new_Our_depot_BIC_code char(12) ,
new_Our_nostro_BIC_code char(12) ,
new_Company_code char(12) ,
new_Our_BIC_code char(12) ,
new_Salesperson char(12) ,
new_Error_message varchar(1),
new_Timestamp datetime ,
orderID1 datetime,
orderID2 identity
)
primary key (orderID2)
send standby replication definition columns
go


Muralidharan Posted on 2005-06-15 00:48:18.0Z
Sender: 2540.42af7a7e.1804289383@sybase.com
From: Muralidharan
Newsgroups: sybase.public.rep-agent
Subject: Re: Warm standby and replication > 128 columns causes error 32048
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <42af7acc.2544.1681692777@sybase.com>
References: <42a7a10a.217c.1681692777@sybase.com>
X-Original-NNTP-Posting-Host: 10.22.241.42
X-Original-Trace: 14 Jun 2005 17:48:12 -0700, 10.22.241.42
Lines: 218
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 14 Jun 2005 17:48:15 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 14 Jun 2005 17:48:18 -0700
X-Trace: forums-1-dub 1118796498 10.22.108.75 (14 Jun 2005 17:48:18 -0700)
X-Original-Trace: 14 Jun 2005 17:48:18 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.rep-agent:803
Article PK: 862394

Following this up by myself:

Sybase Tech Support couldnt reproduce this issue in their
environment.
We decided to drop and recreate the table and mysteriously,
the error went away !

> Hi all,
>
> We've a situation where a table having 164 columns is
> consistently failing to replicate in a Warm standby setup
> with error 32048.
>
> ERROR #32048 REP AGENT(SYB_HKGLS1_TKU.hk201_uat_intf) -
> /nrm/nrm.c(540)
> Can not replicate Table Swift_send_sdw without a
> Replication Definition because it has more than 128
> columns
>
> The sequence of steps that causes this error is:
> * insert 1 row to the table on active, it is correctly
> replicated
> * execute 'delete from table' and RepAgent goes down with
> error 32048
> * drop/recreate RepDef and restart RepAgent, goes down
> again with same error
>
> Attached is the RepDef used for this table.
>
> I suspect that the orderID2 column defined as an identity
> and as a primary key in both RepDef and on the table might
> be causing this problem ?
> Are there any problems with this RepDef ?
>
> Any help is much appreciated.
> Thanks in advance
>
> The versions of products involved are:
> ASE - 12.0.0.8 ESD2
> REP - Replication Server/12.0/EBF 9593/Sun_svr4/OS
> 5.6/1/OPT/Tue Apr 17 15:53:37 PDT 2001
>
>
> [Swift_send_sdw]
> CREATE REPLICATION DEFINITION Swift_send_sdw
> WITH PRIMARY AT SYB_HKGLS1_TKL.hk201_uat_intf
> WITH ALL TABLES NAMED 'Swift_send_sdw'
> (
> cmd varchar(12),
> old_Status char(1),
> old_Seq_no numeric,
> old_Action char(1),
> old_MT_type char(1),
> old_Trade_ref char(1),
> old_Trade_ver int,
> old_Inst_no int,
> old_Related_Inst_no int,
> old_Sender_ref char(1),
> old_Related_sender_ref char(1),
> old_Place char(1),
> old_Trade_date datetime,
> old_Settle_date datetime,
> old_Client_ac char(1) ,
> old_Sub_ac char(1) ,
> old_Trade_type char(1) ,
> old_ISIN_code char(1) ,
> old_Sec_code char(1) ,
> old_Sec_name_1 varchar(1),
> old_Sec_name_2 varchar(1),
> old_Price_type char(1) ,
> old_Trade_price float ,
> old_Buy_sell_id char(1) ,
> old_Trade_qty float ,
> old_Trade_ccy char(1) ,
> old_Trade_amt float ,
> old_Settle_ccy char(1) ,
> old_Fx_rate float ,
> old_Mul_Div_id char(1) ,
> old_Comm float ,
> old_Comm_settle_ccy float ,
> old_Settle_amt float ,
> old_Our_safe_ac char(1) ,
> old_Our_cash_ac char(1) ,
> old_Settle_narr_1 varchar(1),
> old_Settle_narr_2 varchar(1),
> old_Settle_narr_3 varchar(1),
> old_Settle_narr_4 varchar(1),
> old_Settle_narr_5 varchar(1),
> old_Settle_narr_6 varchar(1),
> old_Sett_place_id_type char(1) ,
> old_Sett_place_country_code char(1) ,
> old_Sett_place_id_code char(1) ,
> old_Sett_place_addr_1 varchar(1),
> old_Sett_place_addr_2 varchar(1),
> old_Sett_place_addr_3 varchar(1),
> old_Sett_place_addr_4 varchar(1),
> old_Client_id_type char(1) ,
> old_Client_id_code char(1) ,
> old_Client_name_addr_1 varchar(1),
> old_Client_name_addr_2 varchar(1),
> old_Client_name_addr_3 varchar(1),
> old_Client_name_addr_4 varchar(1),
> old_Sub_ac_id_type char(1) ,
> old_Sub_ac_id_code char(1) ,
> old_Sub_ac_name_addr_1 varchar(1),
> old_Sub_ac_name_addr_2 varchar(1),
> old_Sub_ac_name_addr_3 varchar(1),
> old_Sub_ac_name_addr_4 varchar(1),
> old_Cpty_dr_agent_id_type char(1) ,
> old_Cpty_dr_agent_id_code char(1) ,
> old_Cpty_dr_agent_name_addr_1 varchar(1),
> old_Cpty_dr_agent_name_addr_2 varchar(1),
> old_Cpty_dr_agent_name_addr_3 varchar(1),
> old_Cpty_dr_agent_name_addr_4 varchar(1),
> old_Cpty_safe_ac_with_dr_agent char(1) ,
> old_Cpty_cust_id_type char(1) ,
> old_Cpty_cust_id_code char(1) ,
> old_Cpty_cust_name_addr_1 varchar(1),
> old_Cpty_cust_name_addr_2 varchar(1),
> old_Cpty_cust_name_addr_3 varchar(1),
> old_Cpty_cust_name_addr_4 varchar(1),
> old_Cpty_safe_ac_with_cust char(1) ,
> old_STCO char(1) ,
> old_Our_depot_BIC_code char(1) ,
> old_Our_nostro_BIC_code char(1) ,
> old_Company_code char(1) ,
> old_Our_BIC_code char(1) ,
> old_Salesperson char(1) ,
> old_Error_message varchar(1),
> old_Timestamp datetime ,
> new_Status char(1) ,
> new_Seq_no numeric,
> new_Action char(1) ,
> new_MT_type char(3) ,
> new_Trade_ref char(13) ,
> new_Trade_ver int ,
> new_Inst_no int ,
> new_Related_Inst_no int ,
> new_Sender_ref char(16) ,
> new_Related_sender_ref char(16) ,
> new_Place char(12) ,
> new_Trade_date datetime ,
> new_Settle_date datetime ,
> new_Client_ac char(12) ,
> new_Sub_ac char(12) ,
> new_Trade_type char(4) ,
> new_ISIN_code char(12) ,
> new_Sec_code char(12) ,
> new_Sec_name_1 varchar(35),
> new_Sec_name_2 varchar(35),
> new_Price_type char(4) ,
> new_Trade_price float ,
> new_Buy_sell_id char(4) ,
> new_Trade_qty float ,
> new_Trade_ccy char(3) ,
> new_Trade_amt float ,
> new_Settle_ccy char(3) ,
> new_Fx_rate float ,
> new_Mul_Div_id char(1) ,
> new_Comm float ,
> new_Comm_settle_ccy float ,
> new_Settle_amt float ,
> new_Our_safe_ac char(20) ,
> new_Our_cash_ac char(20) ,
> new_Settle_narr_1 varchar(35),
> new_Settle_narr_2 varchar(35),
> new_Settle_narr_3 varchar(35),
> new_Settle_narr_4 varchar(35),
> new_Settle_narr_5 varchar(35),
> new_Settle_narr_6 varchar(35),
> new_Sett_place_id_type char(1) ,
> new_Sett_place_country_code char(2) ,
> new_Sett_place_id_code char(12) ,
> new_Sett_place_addr_1 varchar(35),
> new_Sett_place_addr_2 varchar(35),
> new_Sett_place_addr_3 varchar(35),
> new_Sett_place_addr_4 varchar(35),
> new_Client_id_type char(1) ,
> new_Client_id_code char(12) ,
> new_Client_name_addr_1 varchar(35),
> new_Client_name_addr_2 varchar(35),
> new_Client_name_addr_3 varchar(35),
> new_Client_name_addr_4 varchar(35),
> new_Sub_ac_id_type char(1) ,
> new_Sub_ac_id_code char(12) ,
> new_Sub_ac_name_addr_1 varchar(35),
> new_Sub_ac_name_addr_2 varchar(35),
> new_Sub_ac_name_addr_3 varchar(35),
> new_Sub_ac_name_addr_4 varchar(35),
> new_Cpty_dr_agent_id_type char(1) ,
> new_Cpty_dr_agent_id_code char(12) ,
> new_Cpty_dr_agent_name_addr_1 varchar(35),
> new_Cpty_dr_agent_name_addr_2 varchar(35),
> new_Cpty_dr_agent_name_addr_3 varchar(35),
> new_Cpty_dr_agent_name_addr_4 varchar(35),
> new_Cpty_safe_ac_with_dr_agent char(20) ,
> new_Cpty_cust_id_type char(1) ,
> new_Cpty_cust_id_code char(12) ,
> new_Cpty_cust_name_addr_1 varchar(35),
> new_Cpty_cust_name_addr_2 varchar(35),
> new_Cpty_cust_name_addr_3 varchar(35),
> new_Cpty_cust_name_addr_4 varchar(35),
> new_Cpty_safe_ac_with_cust char(20) ,
> new_STCO char(4) ,
> new_Our_depot_BIC_code char(12) ,
> new_Our_nostro_BIC_code char(12) ,
> new_Company_code char(12) ,
> new_Our_BIC_code char(12) ,
> new_Salesperson char(12) ,
> new_Error_message varchar(1),
> new_Timestamp datetime ,
> orderID1 datetime,
> orderID2 identity
> )
> primary key (orderID2)
> send standby replication definition columns
> go
> [Attachment: Swift_send_sdw]