Hi All ,
I replicat from oracle to ms-sql . the relication process abende with below error .Oure OGG release is 12.2.01 however the table struvure between source"oracle" and sql "tarf=get" like below
Target
CREATE TABLE [dbo].[RD_CCB_bills](
[ACCT_ID] [varchar](10) NULL,
[CCBBILL_ID] [varchar](10) NULL,
[DUE_AMOUNT] [decimal](18, 2) NULL,
[CIS_DIVISION] [varchar](5) NULL,
[BATCH_NO] [int] NULL,
[CRE_DT] [datetime] NULL,
[IS_PROCESSED] [bit] NULL
) ON [PRIMARY]
GO
Source
CREATE TABLE "GGATE"."CM_SADAD_CUST_DEBT_UPLOAD"
( "ACCT_ID" CHAR(10 BYTE) DEFAULT ' ' NOT NULL ENABLE,
"CCBBILL_ID" CHAR(12 BYTE) DEFAULT ' ' NOT NULL ENABLE,
"DUE_AMOUNT" NUMBER(17,3) DEFAULT 0 NOT NULL ENABLE,
"CIS_DIVISION" CHAR(4 BYTE) DEFAULT ' ' NOT NULL ENABLE,
"BATCH_NO" NUMBER(8,0) DEFAULT 0 NOT NULL ENABLE,
"CRE_DT" DATE,
"IS_PROCESSED" CHAR(1 BYTE) DEFAULT '',
PRIMARY KEY ("ACCT_ID")
2018-05-09 10:06:32 WARNING OGG-01003 Oracle GoldenGate Delivery for SQL Server, CCBSA01.prm: Repositioning to rba 404801265 in seqno 0.
2018-05-09 10:07:01 INFO OGG-01021 Oracle GoldenGate Delivery for SQL Server, CCBSA01.prm: Command received from GGSCI: STATS.
2018-05-09 10:09:20 INFO OGG-00987 Oracle GoldenGate Command Interpreter for SQL Server: GGSCI command (omohei): info all.
2018-05-09 10:09:25 INFO OGG-01971 Oracle GoldenGate Delivery for SQL Server, CCBSA01.prm: The previous message, 'INFO OGG-01021', repeated 1 times.
2018-05-09 10:09:25 WARNING OGG-00869 Oracle GoldenGate Delivery for SQL Server, CCBSA01.prm:
Parameter #: 1 Data Type: 129 DB Part: 7 Length: 10 Max Length: 10 Status: 6 Precision: 10 Scale: 0 Data Overflow
Native Error: 0, 0
State: 0, 22018
Class: 0
Source: Line Number: 0
Description: Invalid character value for cast specification.
2018-05-09 10:09:25 WARNING OGG-01154 Oracle GoldenGate Delivery for SQL Server, CCBSA01.prm: SQL error -2147217887 mapping GGATE.CM_SADAD_CUST_DEBT_UPLOAD to dbo.RD_CCB_bills [SQL error -2147217887 (0x80040e21)]
Parameter #: 1 Data Type: 129 DB Part: 7 Length: 10 Max Length: 10 Status: 6 Precision: 10 Scale: 0 Data Overflow
Native Error: 0, 0
State: 0, 22018
Class: 0