push subscribe problem(String data, right truncation)

os : windows2000 server
sql : sql2000 enterprise edition
mdac version is same each other.. version 2.8
i have two sql server(devsrv and parkchangsoon)
i configured the transaction replication
parkchangsoon : publisher,distributer
devsrv : subscriber
articles are 10 of all tables and 10 of all procedures
at first
the snapshot agent status is succss and the last action is "the snapshot of
24 articles have created"
after that
the distributer agent is pushing to devsrv (subscriber system)
but the distributer agent status is fail and the last action is "could not
bulk copy to 'jobs' table"
so..
i saw the distributer agent error information
publisher(P) : parkchangsoon agent(A) : PARKCHANGSOON-albaroot_3th-DEVSRV-5
publish(U) : albaroot_3th subscribe : DEVSRV:albaroot_3th
error message(E) : could not bulk copy to 'jobs' table
last command (V) : select * from workey_jobs where 1=1
error infomation(E) : String data, right truncation
source : DEVSRV(ODBC); eror number : 22001
below is the schema of the jobs table
CREATE TABLE [devuser].[Jobs] (
[seq] [int] IDENTITY (1, 1) NOT NULL ,
[title] [varchar] (100) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[findPrsn] [tinyint] NOT NULL ,
[ageZn] [varchar] (50) COLLATE Korean_Wansung_CI_AS NULL ,
[applyRght] [varchar] (4000) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[emplrId] [varchar] (30) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[readCnt] [int] NOT NULL ,
[sido] [tinyint] NOT NULL ,
[workTyp] [char] (8) COLLATE Korean_Wansung_CI_AS NULL ,
[applyDcmnt] [varchar] (100) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[findYmd2] [smalldatetime] NOT NULL ,
[gugun] [tinyint] NOT NULL ,
[finishYmd] [bit] NOT NULL ,
[ymd] [smalldatetime] NOT NULL ,
[particular] [char] (1) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[position] [varchar] (100) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[makeup_color] [bit] NOT NULL ,
[makeup_icon] [bit] NOT NULL ,
[makeup_marquee] [bit] NOT NULL ,
[logo] [varchar] (50) COLLATE Korean_Wansung_CI_AS NOT NULL ,
[endymd] [smalldatetime] NOT NULL ,
[jobtype1] [tinyint] NULL ,
[jobtype2] [tinyint] NULL ,
[jobtype3] [tinyint] NULL ,
[paytype] [char] (4) COLLATE Korean_Wansung_CI_AS NULL ,
[pay1] [int] NULL ,
[pay2] [bit] NULL ,
[suprise] [tinyint] NULL ,
[ts] [timestamp] NULL ,
[visible] [bit] NULL ,
[createdYmd] [smalldatetime] NULL ,
[msrepl_tran_version] [uniqueidentifier] NOT NULL
) ON [PRIMARY]
GO
nonclustered primary key is seq column
how can i solve this problem?
any suggestion?
help...
thanks
On each article can you ensure that the collation is sent over - this is a
checkbox option on the article properties, snapshot tab.
Regards,
Paul Ibison
|||thanks for replying.~
on the article properties, snapshot tab..
those three options are checked..
Includes declared referential integrity
clustered index
non clustered index
"Paul Ibison" <Paul.Ibison@.Pygmalion.Com> wrote in message
news:us917DwbEHA.2760@.TK2MSFTNGP09.phx.gbl...
> On each article can you ensure that the collation is sent over - this is a
> checkbox option on the article properties, snapshot tab.
> Regards,
> Paul Ibison
>
|||OK - select the collation checkbox for each table and
reinitialize - hopefully this will remove the truncation
issue which may be due to different codepages.
Regards,
Paul Ibison