1 Reply Latest reply: Aug 9, 2014 8:05 AM by 960104 RSS

    ERROR MAPPING sqlserver2005 to oracle11.2,help!!!

    2727345

      hello,all

      env is as below:

      source:windows 2003 X64,sqlserver 2005

      target:centos 5.8 x86_64;oracle 11g

      i configured the data source,and maked the defgen file to target server;but the replicat is always abend like this

       

      Source Context :
        SourceModule            : [er.errors]
        SourceID                : [/scratch/aime1/adestore/views/aime1_adc4150267/oggcore/OpenSys/src/app/er/errors.cpp]
        SourceFunction          : [take_rep_err_action]
        SourceLine              : [632]
        ThreadBacktrace         : [12] elements
                                : [/opt/ggate/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x2b8bbd7ca28e]]
                                : [/opt/ggate/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2ec) [0x2b8bbd7c2dec]]
                                : [/opt/ggate/libgglog.so(_MSG_ERR_MAP_TO_TANDEM_FAILED(CSourceContext*, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1
      > const&, CMessageFactory::MessageDisposition)+0x53) [0x2b8bbd7bedc1]]
                                : [/opt/ggate/replicat(take_rep_err_action(short, int, char const*, extr_ptr_def*, __std_rec_hdr*, char*, file_def*, bool)+0xaa7) [0x5275b1]]
                                : [/opt/ggate/replicat(process_extract_loop()+0x26ce) [0x54187e]]
                                : [/opt/ggate/replicat(replicat_main(int, char**)+0x759) [0x553ce9]]
                                : [/opt/ggate/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f) [0x5f240f]]
                                : [/opt/ggate/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x104) [0x5f2664]]
                                : [/opt/ggate/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x8b) [0x5f276b]]
                                : [/opt/ggate/replicat(main+0x2c) [0x552e8c]]
                                : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x37b741d994]]
                                : [/opt/ggate/replicat(__gxx_personality_v0+0x342) [0x4c4caa]]

      2014-08-06 17:27:24  ERROR   OGG-01296  Error mapping from dbo.OperationRecord to PCDFJ.OPERATIONRECORD.

       

      source table structure:

      CREATE TABLE dbo.OperationRecord

      (

          ID         int           IDENTITY NOT FOR REPLICATION,

          Department nvarchar(20)  COLLATE Chinese_PRC_CI_AS NOT NULL,

          Operator   nvarchar(20)  COLLATE Chinese_PRC_CI_AS NOT NULL,

          Operation  nvarchar(20)  COLLATE Chinese_PRC_CI_AS NOT NULL,

          Moment     datetime      NOT NULL,

          Success    bit           NOT NULL,

          Keyword    nvarchar(250) COLLATE Chinese_PRC_CI_AS NULL,

          Message    ntext         COLLATE Chinese_PRC_CI_AS NULL,

          CONSTRAINT PK_OperationRecord

          PRIMARY KEY CLUSTERED (ID)

      )

       

      target oracle table structure:

      CREATE TABLE PCDFJ.OPERATIONRECORD

      (

          ID         NUMBER(10,0)   NOT NULL,

          DEPARTMENT NVARCHAR2(20)  NOT NULL,

          OPERATOR   NVARCHAR2(20)  NOT NULL,

          OPERATION  NVARCHAR2(20)  NOT NULL,

          MOMENT     DATE           NOT NULL,

          SUCCESS    NUMBER(1,0)    NOT NULL,

          KEYWORD    NVARCHAR2(250)     NULL,

          MESSAGE    NCLOB              NULL

      CONSTRAINT PK_OperationRecord

          PRIMARY KEY (ID)

      );

       

      params file:

      REPLICAT repgjf

      --SETENV (ORACLE_SID=center)

      setenv(NLS_LANG =AMERICAN_AMERICA.ZHS16GBK)

      USERID fjmsa, PASSWORD fjmsa13579

      sourcedefs ./dirdef/gjf.def

      HANDLECOLLISIONS

      ASSUMETARGETDEFS

      allownoopupdates

      dynamicresolution

      numfiles 3000

      map dbo.OPERATION , target pcdfj.OPERATION;

      map dbo.OPERATIONRECORD , target pcdfj.OPERATIONRECORD,colmap(ID=ID,Department=Department,Operator=Operator,Operation=Operation,Moment=Moment,Success=@NUMSTR(Success),Keyword=Keyword,Message=@binary(Me

      ssage));

       

      replicat REPORT :

      GGSCI (rac2) 5> view report repgjf


      ***********************************************************************
                       Oracle GoldenGate Delivery for Oracle
      Version 11.2.1.0.19 18124625 OGGCORE_11.2.1.0.0OGGBP_PLATFORMS_140209.2142_FBO
         Linux, x64, 64bit (optimized), Oracle 11g on Feb 10 2014 02:21:10

      Copyright (C) 1995, 2014, Oracle and/or its affiliates. All rights reserved.


                          Starting at 2014-08-06 17:27:23
      ***********************************************************************

      Operating System Version:
      Linux
      Version #1 SMP Fri Jan 27 17:17:51 EST 2012, Release 2.6.18-308.el5
      Node: rac2
      Machine: x86_64
                               soft limit   hard limit
      Address Space Size   :    unlimited    unlimited
      Heap Size            :    unlimited    unlimited
      File Size            :    unlimited    unlimited
      CPU Time             :    unlimited    unlimited

      Process id: 19500

      Description:

      ***********************************************************************
      **            Running with the following parameters                  **
      ***********************************************************************

      2014-08-06 17:27:23  INFO    OGG-03035  Operating system character set identified as US-ASCII. Locale: en_US_POSIX, LC_ALL:.

      2014-08-06 17:27:23  INFO    OGG-02696  NON-ANSI SQL parameter syntax is used for parameter parsing.
      REPLICAT repgjf
      setenv(NLS_LANG =AMERICAN_AMERICA.ZHS16GBK)

      2014-08-06 17:27:23  INFO    OGG-02095  Successfully set environment variable NLS_LANG=AMERICAN_AMERICA.ZHS16GBK.
      USERID fjmsa, PASSWORD **********
      sourcedefs ./dirdef/gjf.def
      HANDLECOLLISIONS
      ASSUMETARGETDEFS
      allownoopupdates
      dynamicresolution
      numfiles 3000

      2014-08-06 17:27:24  WARNING OGG-00363  numfiles must occur before SOURCEDEFS/TARGETDEFS entries to have an effect. Parameter ignored.
      map dbo.ACCOUNT , target pcdfj.ACCOUNT;
      map dbo.ADDITION , target pcdfj.ADDITION;
      map dbo.ADVANCE , target pcdfj.ADVANCE;
      map dbo.ADVANCECONFIRM , target pcdfj.ADVANCECONFIRM;
      map dbo.AGENCY , target pcdfj.AGENCY,colmap(Code=Code,Name=NAME,Owner=Owner,Account=Account,Credit=Credit,Cipher=@binary(Cipher),Factor=Factor,Type=Type,Devoir=Devoir,Disable=Disable,Recent=Recent,Vers
      ion=Version);
      map dbo.ARCHIVE , target pcdfj.ARCHIVE;
      map dbo.ARCHIVECONFIRM , target pcdfj.ARCHIVECONFIRM;
      map dbo.ASSOCIATE , target pcdfj.ASSOCIATE;
      map dbo.BALANCE , target pcdfj.BALANCE;
      map dbo.CALCULATE , target pcdfj.CALCULATE;
      map dbo.CALCULATEAFFIRM , target pcdfj.CALCULATEAFFIRM;
      map dbo.CARGOHS , target pcdfj.CARGOHS;
      map dbo.CARGOJT , target pcdfj.CARGOJT;
      map dbo.CARRYFORWARD , target pcdfj.CARRYFORWARD;
      map dbo.CHARGE , target pcdfj.CHARGE;
      map dbo.CONFIGURE , target pcdfj.CONFIGURE;
      map dbo.DECLARANT , target pcdfj.DECLARANT;
      map dbo.DEPARTMENT , target pcdfj.DEPARTMENT;
      map dbo.DEPOSIT , target pcdfj.DEPOSIT;
      map dbo.DEPOSITINVOICE , target pcdfj.DEPOSITINVOICE;
      map dbo.DEVOIR ,target pcdfj.DEVOIR;
      map dbo.DISPOSE ,target pcdfj.DISPOSE;
      map dbo.DISPOSECONFIRM ,target pcdfj.DISPOSECON FIRM;
      map dbo.FREIGHT , target pcdfj.FREIGHT,colmap(Code=Code,ManIFest=ManIFest,Sheet=Sheet,Layer=Layer,Payer=Payer,goods=goods,Cargo=Cargo,Weight=Weight,Container=Container,Rebate=Rebate,Transit=Transit,Ext
      end=@binary(Extend),Revenue=Revenue,Reporter=Reporter,Remark=Remark,Creator=Creator,Agency=Agency,CreateCode=CreateCode,CreateName=CreateName,CreateTime=CreateTime,Process=Process,Remove=@numstr(Remove
      ));
      map dbo.FREIGHTPAYER , target pcdfj.FREIGHTPAYER;
      map dbo.GROUPHARBOR , target pcdfj.GROUPHARBOR;
      map dbo.GROUPMANAGE , target pcdfj.GROUPMANAGE;
      map dbo.INVOICE , target pcdfj.INVOICE;
      map dbo.INVOICEDETAIL , target pcdfj.INVOICEDETAIL;
      map dbo.INVOICEHEADER , target pcdfj.INVOICEHEADER;
      map dbo.MACHINE , target pcdfj.MACHINE;
      map dbo.MANIFESTAFFIRM , target pcdfj.MANIFESTAFFIRM;
      map dbo.MANIFESTCENSOR , target pcdfj.MANIFESTCENSOR;
      map dbo.MANIFESTREJECT , target pcdfj.MANIFESTREJECT;
      map dbo.MANIFESTREVISE , target pcdfj.MANIFESTREVISE;
      map dbo.MASTERY , target pcdfj.MASTERY;
      map dbo.MISSION , target pcdfj.MISSION;
      map dbo.OPERATION , target pcdfj.OPERATION;
      map dbo.OPERATIONRECORD , target pcdfj.OPERATIONRECORD,colmap(ID=ID,Department=Department,Operator=Operator,Operation=Operation,Moment=Moment,Success=@NUMSTR(Success),Keyword=Keyword,Message=@binary(Me
      ssage));
      map dbo.OPERATOR , target pcdfj.OPERATOR;
      map dbo.PAYER , target pcdfj.PAYER;
      map dbo.PAYERCONFIRM , target pcdfj.PAYERCONFIRM;
      map dbo.PAYERSCOPE , target pcdfj.PAYERSCOPE;
      map dbo.PAYMENT , target pcdfj.PAYMENT;
      map dbo.PAYMENTINVOICE , target pcdfj.PAYMENTINVOICE;
      map dbo.RECEIPT , target pcdfj.RECEIPT;
      map dbo.REQUEST ,target pcdfj.REQUEST;
      map dbo.SETTLE ,target pcdfj.SETTLE;
      map dbo.SETTLECONFIG ,target pcdfj.SETTLECONFIG;
      map dbo.SPECIES ,target pcdfj.SPECIES;
      map dbo.STORAGE ,target pcdfj.STORAGE;
      map dbo.TURNIN ,target pcdfj.TURNIN;
      map dbo.TURNINDEPOSIT ,target pcdfj.TURNINDEPOSIT;
      map dbo.TURNININVOICE ,target pcdfj.TURNININVOICE;
      map dbo.WHARF ,target pcdfj.WHARF;
      map dbo.ZT_CALCULATE ,target pcdfj.ZT_CALCULATE;
      map dbo.ZT_DEPARTMENT ,target pcdfj.ZT_DEPARTMENT;
      map dbo.ZT_DEVOIR ,target pcdfj.ZT_DEVOIR;
      map dbo.ZT_INVOICE ,target pcdfj.ZT_INVOICE;
      map dbo.ZT_INVOICEDETAIL ,target pcdfj.ZT_INVOICEDETAIL;
      map dbo.ZT_MACHINE ,target pcdfj.ZT_MACHINE;
      map dbo.ZT_MASTERY ,target pcdfj.ZT_MASTERY;
      map dbo.ZT_OPERATOR ,target pcdfj.ZT_OPERATOR;
      map dbo.ZT_PROCESS ,target pcdfj.ZT_PROCESS;
      map dbo.ZT_STORAGE ,target pcdfj.ZT_STORAGE;
      map dbo.ZT_WHARF ,target pcdfj.ZT_WHARF;

      2014-08-06 17:27:24  INFO    OGG-01815  Virtual Memory Facilities for: COM
          anon alloc: mmap(MAP_ANON)  anon free: munmap
          file alloc: mmap(MAP_SHARED)  file free: munmap
          target directories:
          /opt/ggate/dirtmp.

      CACHEMGR virtual memory values (may have been adjusted)
      CACHESIZE:                                2G
      CACHEPAGEOUTSIZE (normal):                8M
      PROCESS VM AVAIL FROM OS (min):           4G
      CACHESIZEMAX (strict force to disk):   3.41G

      Database Version:
      Oracle Database 11g Enterprise Edition Release 11.2.0.1.0 - 64bit Production
      PL/SQL Release 11.2.0.1.0 - Production
      CORE    11.2.0.1.0      Production
      TNS for Linux: Version 11.2.0.1.0 - Production
      NLSRTL Version 11.2.0.1.0 - Production

      Database Language and Character Set:
      NLS_LANG         = "AMERICAN_AMERICA.ZHS16GBK"
      NLS_LANGUAGE     = "AMERICAN"
      NLS_TERRITORY    = "AMERICA"
      NLS_CHARACTERSET = "ZHS16GBK"

      ***********************************************************************
      **                     Run Time Messages                             **
      ***********************************************************************

      Opened trail file /opt/ggate/dirdat/sa000000 at 2014-08-06 17:27:24

      MAP resolved (entry dbo.OPERATIONRECORD):
        map dbo.OperationRecord , target pcdfj.OPERATIONRECORD,colmap(ID=ID,Department=Department,Operator=Operator,Operation=Operation,Moment=Moment,Success=@NUMSTR(Success),Keyword=Keyword,Message=@binary(
      Message));

      2014-08-06 17:27:24  WARNING OGG-00869  No unique key is defined for table 'OPERATIONRECORD'. All viable columns will be used to represent the key, but may not guarantee uniqueness.  KEYCOLS may be use
      d to define the key.
      Using the following key columns for target table PCDFJ.OPERATIONRECORD: ID, DEPARTMENT, OPERATOR, OPERATION, MOMENT, SUCCESS, KEYWORD.

       

      2014-08-06 17:27:24  WARNING OGG-01431  Aborted grouped transaction on 'PCDFJ.OPERATIONRECORD', Mapping error.

      2014-08-06 17:27:24  WARNING OGG-01003  Repositioning to rba 477511 in seqno 0.

      2014-08-06 17:27:24  WARNING OGG-01151  Error mapping from dbo.OperationRecord to PCDFJ.OPERATIONRECORD.

      2014-08-06 17:27:24  WARNING OGG-01003  Repositioning to rba 477511 in seqno 0.

      Source Context :
        SourceModule            : [er.errors]
        SourceID                : [/scratch/aime1/adestore/views/aime1_adc4150267/oggcore/OpenSys/src/app/er/errors.cpp]
        SourceFunction          : [take_rep_err_action]
        SourceLine              : [632]
        ThreadBacktrace         : [12] elements
                                : [/opt/ggate/libgglog.so(CMessageContext::AddThreadContext()+0x1e) [0x2b8bbd7ca28e]]
                                : [/opt/ggate/libgglog.so(CMessageFactory::CreateMessage(CSourceContext*, unsigned int, ...)+0x2ec) [0x2b8bbd7c2dec]]
                                : [/opt/ggate/libgglog.so(_MSG_ERR_MAP_TO_TANDEM_FAILED(CSourceContext*, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1> const&, ggs::gglib::ggapp::CQualDBObjName<(DBObjType)1
      > const&, CMessageFactory::MessageDisposition)+0x53) [0x2b8bbd7bedc1]]
                                : [/opt/ggate/replicat(take_rep_err_action(short, int, char const*, extr_ptr_def*, __std_rec_hdr*, char*, file_def*, bool)+0xaa7) [0x5275b1]]
                                : [/opt/ggate/replicat(process_extract_loop()+0x26ce) [0x54187e]]
                                : [/opt/ggate/replicat(replicat_main(int, char**)+0x759) [0x553ce9]]
                                : [/opt/ggate/replicat(ggs::gglib::MultiThreading::MainThread::ExecMain()+0x4f) [0x5f240f]]
                                : [/opt/ggate/replicat(ggs::gglib::MultiThreading::Thread::RunThread(ggs::gglib::MultiThreading::Thread::ThreadArgs*)+0x104) [0x5f2664]]
                                : [/opt/ggate/replicat(ggs::gglib::MultiThreading::MainThread::Run(int, char**)+0x8b) [0x5f276b]]
                                : [/opt/ggate/replicat(main+0x2c) [0x552e8c]]
                                : [/lib64/libc.so.6(__libc_start_main+0xf4) [0x37b741d994]]
                                : [/opt/ggate/replicat(__gxx_personality_v0+0x342) [0x4c4caa]]

      2014-08-06 17:27:24  ERROR   OGG-01296  Error mapping from dbo.OperationRecord to PCDFJ.OPERATIONRECORD.