Oracle replication failed

We are using MSSQL2005 (64-bits) and replicating data from oracle to
mssql2005 DB. Some replication jobs failed and it shows 'data conversion
failed' error MSSQL_REPL20037. Any idea on it ? I can't find the error in
online book. THanks in advance!
Which agent is this failing on? Can you enable logging to see the problem
statement?
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"stephanie" <stephanie@.discussions.microsoft.com> wrote in message
news:25858670-C644-4B8F-8B2A-288E1460AC3F@.microsoft.com...
> We are using MSSQL2005 (64-bits) and replicating data from oracle to
> mssql2005 DB. Some replication jobs failed and it shows 'data conversion
> failed' error MSSQL_REPL20037. Any idea on it ? I can't find the error
> in
> online book. THanks in advance!
>
|||Below is the trace info on the failed replication. Thanks a lot!
EXECUTE msdb.dbo.sp_sqlagent_log_jobhistory @.job_id =
0x0564E4D45972EC48A051BBA5B6CB9F5D, @.step_id = 2, @.sql_message_id = 0,
@.sql_severity = 0, @.run_status = 4, @.run_date = 20051216, @.run_time = 93014,
@.run_duration = 2220,
@.operator_id_emailed = 0, @.operator_id_netsent = 0, @.operator_id_paged = 0,
@.retries_attempted = 0, @.session_id = 5, @.message = N'
2005-12-16 01:52:05.319 Bulk copying data into table ''SYSTWODB_CNCOM''
2005-12-16 01:52:29.413 Bulk copied data into table ''SYSTWODB_CNCOM''
(90546 rows)
2005-12-16 01:52:29.648 Applied script ''SYSTWODB_CNEOD_4.sch''
2005-12-16 01:52:29.663 Bulk copying data into table ''SYSTWODB_CNEOD''
2005-12-16 01:52:34.038 Agent message code 20037. The process could not bulk
copy into table ''"dbo"."SYSTWODB_CNEOD"''.
2005-12-16 01:52:34.101 Category:NULL
Source: Microsoft SQL Native Client
Number:
Message: Data conversion failed
2005-12-16 01:52:34.116 Category:NULL
Source: Microsoft SQL Native Client
Number:
Message: Data conversion failed
2005-12-16 01:52:34.116 Category:NULL
Source: Microsoft SQL Native Client
Number:
Message: Data conversion failed
2005-12-16 01:52:34.132 Category:NULL
Source: Microsoft SQL Native Client
Number:
Message: Data conversion failed
2005-12-16 01:52:34.132 Category:NULL
Source: Microsoft SQL Native Client
Number:
Message: Data conversion failed
'
"Hilary Cotter" wrote:

> Which agent is this failing on? Can you enable logging to see the problem
> statement?
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "stephanie" <stephanie@.discussions.microsoft.com> wrote in message
> news:25858670-C644-4B8F-8B2A-288E1460AC3F@.microsoft.com...
>
>
|||can you post the schema of SYSTWODB_CNEOD
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"stephanie" <stephanie@.discussions.microsoft.com> wrote in message
news:6181D00E-B82E-4EA2-AE13-9EBE37337F2F@.microsoft.com...[vbcol=seagreen]
> Below is the trace info on the failed replication. Thanks a lot!
> EXECUTE msdb.dbo.sp_sqlagent_log_jobhistory @.job_id =
> 0x0564E4D45972EC48A051BBA5B6CB9F5D, @.step_id = 2, @.sql_message_id = 0,
> @.sql_severity = 0, @.run_status = 4, @.run_date = 20051216, @.run_time =
> 93014,
> @.run_duration = 2220,
> @.operator_id_emailed = 0, @.operator_id_netsent = 0, @.operator_id_paged =
> 0,
> @.retries_attempted = 0, @.session_id = 5, @.message = N'
> 2005-12-16 01:52:05.319 Bulk copying data into table ''SYSTWODB_CNCOM''
> 2005-12-16 01:52:29.413 Bulk copied data into table ''SYSTWODB_CNCOM''
> (90546 rows)
> 2005-12-16 01:52:29.648 Applied script ''SYSTWODB_CNEOD_4.sch''
> 2005-12-16 01:52:29.663 Bulk copying data into table ''SYSTWODB_CNEOD''
> 2005-12-16 01:52:34.038 Agent message code 20037. The process could not
> bulk
> copy into table ''"dbo"."SYSTWODB_CNEOD"''.
> 2005-12-16 01:52:34.101 Category:NULL
> Source: Microsoft SQL Native Client
> Number:
> Message: Data conversion failed
> 2005-12-16 01:52:34.116 Category:NULL
> Source: Microsoft SQL Native Client
> Number:
> Message: Data conversion failed
> 2005-12-16 01:52:34.116 Category:NULL
> Source: Microsoft SQL Native Client
> Number:
> Message: Data conversion failed
> 2005-12-16 01:52:34.132 Category:NULL
> Source: Microsoft SQL Native Client
> Number:
> Message: Data conversion failed
> 2005-12-16 01:52:34.132 Category:NULL
> Source: Microsoft SQL Native Client
> Number:
> Message: Data conversion failed
> '
> "Hilary Cotter" wrote:
|||Below is the ddl of table (in both mssql and oracle) which failed in
replication
USE [dev]
GO
/****** Object: Table [dbo].[SYSTWODB_EXCHR] Script Date: 12/14/2005
14:22:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[SYSTWODB_EXCHR](
[GLB_DTIME] [numeric](16, 0) NOT NULL,
[CCY] [varchar](4) COLLATE Chinese_Hong_Kong_Stroke_90_CI_AS NOT NULL,
[XCCY] [varchar](4) COLLATE Chinese_Hong_Kong_Stroke_90_CI_AS NOT NULL,
[EXCH_GRP] [varchar](4) COLLATE Chinese_Hong_Kong_Stroke_90_CI_AS NOT NULL,
[XEXCH_GRP] [varchar](4) COLLATE Chinese_Hong_Kong_Stroke_90_CI_AS NOT NULL,
[REL_DAY] [numeric](5, 0) NOT NULL,
[XREL_DAY] [numeric](5, 0) NOT NULL,
[BASEX_CCY] [varchar](4) COLLATE Chinese_Hong_Kong_Stroke_90_CI_AS NOT NULL,
[BSE_RATEID] [varchar](7) COLLATE Chinese_Hong_Kong_Stroke_90_CI_AS NOT NULL,
[INP_DATE] [numeric](5, 0) NOT NULL,
[INP_TIME] [numeric](6, 0) NOT NULL,
[MID_MKT_LN] [numeric](14, 10) NOT NULL,
[MID_MKT_TY] [numeric](14, 10) NOT NULL,
[MKT_BUY] [numeric](14, 10) NOT NULL,
[MKT_RATEID] [varchar](7) COLLATE Chinese_Hong_Kong_Stroke_90_CI_AS NOT NULL,
[MKT_SELL] [numeric](14, 10) NOT NULL,
[RATE_USAGE] [varchar](1) COLLATE Chinese_Hong_Kong_Stroke_90_CI_AS NOT NULL,
[SOFTLOCK] [numeric](2, 0) NOT NULL,
[WIDTH] [varchar](1) COLLATE Chinese_Hong_Kong_Stroke_90_CI_AS NOT NULL,
CONSTRAINT [MSHREPL_49_PK] PRIMARY KEY CLUSTERED
(
[GLB_DTIME] ASC
)WITH (IGNORE_DUP_KEY = OFF) ON [PRIMARY]
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
*******************************************
CREATE TABLE "LINC"."SYSTWODB_EXCHR"("GLB_DTIME" NUMBER(16) NOT
NULL, "CCY" VARCHAR2(4) NOT NULL, "XCCY" VARCHAR2(4) NOT NULL,
"EXCH_GRP" VARCHAR2(4) NOT NULL, "XEXCH_GRP" VARCHAR2(4) NOT
NULL, "REL_DAY" NUMBER(5) NOT NULL, "XREL_DAY" NUMBER(5) NOT
NULL, "BASEX_CCY" VARCHAR2(4) NOT NULL, "BSE_RATEID" VARCHAR2(7)
NOT NULL, "INP_DATE" NUMBER(5) NOT NULL, "INP_TIME" NUMBER(6)
NOT NULL, "MID_MKT_LN" NUMBER(14, 10) NOT NULL, "MID_MKT_TY"
NUMBER(14, 10) NOT NULL, "MKT_BUY" NUMBER(14, 10) NOT NULL,
"MKT_RATEID" VARCHAR2(7) NOT NULL, "MKT_SELL" NUMBER(14, 10) NOT
NULL, "RATE_USAGE" VARCHAR2(1) NOT NULL, "SOFTLOCK" NUMBER(2)
NOT NULL, "WIDTH" VARCHAR2(1) NOT NULL,
CONSTRAINT "SYSTWODB_EXCHR_PK" PRIMARY KEY("GLB_DTIME"),
CONSTRAINT "SYS_C0022019" CHECK("GLB_DTIME" IS NOT NULL),
CONSTRAINT "SYS_C0022020" CHECK("CCY" IS NOT NULL),
CONSTRAINT "SYS_C0022021" CHECK("XCCY" IS NOT NULL),
CONSTRAINT "SYS_C0022022" CHECK("EXCH_GRP" IS NOT NULL),
CONSTRAINT "SYS_C0022023" CHECK("XEXCH_GRP" IS NOT NULL),
CONSTRAINT "SYS_C0022024" CHECK("REL_DAY" IS NOT NULL),
CONSTRAINT "SYS_C0022025" CHECK("XREL_DAY" IS NOT NULL),
CONSTRAINT "SYS_C0022026" CHECK("BASEX_CCY" IS NOT NULL),
CONSTRAINT "SYS_C0022027" CHECK("BSE_RATEID" IS NOT NULL),
CONSTRAINT "SYS_C0022028" CHECK("INP_DATE" IS NOT NULL),
CONSTRAINT "SYS_C0022029" CHECK("INP_TIME" IS NOT NULL),
CONSTRAINT "SYS_C0022030" CHECK("MID_MKT_LN" IS NOT NULL),
CONSTRAINT "SYS_C0022031" CHECK("MID_MKT_TY" IS NOT NULL),
CONSTRAINT "SYS_C0022032" CHECK("MKT_BUY" IS NOT NULL),
CONSTRAINT "SYS_C0022033" CHECK("MKT_RATEID" IS NOT NULL),
CONSTRAINT "SYS_C0022034" CHECK("MKT_SELL" IS NOT NULL),
CONSTRAINT "SYS_C0022035" CHECK("RATE_USAGE" IS NOT NULL),
CONSTRAINT "SYS_C0022036" CHECK("SOFTLOCK" IS NOT NULL),
CONSTRAINT "SYS_C0022037" CHECK("WIDTH" IS NOT NULL))
TABLESPACE "URBIS" PCTFREE 10 PCTUSED 70 INITRANS 1 MAXTRANS 255
STORAGE ( INITIAL 2604K NEXT 352K MINEXTENTS 1 MAXEXTENTS
2147483645 PCTINCREASE 0 FREELISTS 1 FREELIST GROUPS 1)
LOGGING
Thanks a lot!
"Hilary Cotter" wrote:

> can you post the schema of SYSTWODB_CNEOD
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "stephanie" <stephanie@.discussions.microsoft.com> wrote in message
> news:6181D00E-B82E-4EA2-AE13-9EBE37337F2F@.microsoft.com...
>
>