9 Replies Latest reply: Feb 13, 2013 12:00 PM by stevencallan RSS

    Error in COLMAP clause. Column name not found

    user5827076
      Hi guys,

      I must be missing something extremely simple here but I can't figure it out. I have a very simple test I am trying to perform. Remap a column from 1 table into another on replicat.

      I have created the defgens file.
      *
      * Definitions created/modified 2013-02-12 13:08
      *
      * Field descriptions for each column entry:
      *
      * 1 Name
      * 2 Data Type
      * 3 External Length
      * 4 Fetch Offset
      * 5 Scale
      * 6 Level
      * 7 Null
      * 8 Bump if Odd
      * 9 Internal Length
      * 10 Binary Length
      * 11 Table Length
      * 12 Most Significant DT
      * 13 Least Significant DT
      * 14 High Precision
      * 15 Low Precision
      * 16 Elementary Item
      * 17 Occurs
      * 18 Key Column
      * 19 Sub Data Type
      *
      *
      Definition for table BILLING.B1
      Record length: 92
      Syskey: 0
      Columns: 2
      B_ID 64 50 0 0 0 1 0 50 50 50 0 0 0 0 1 0 1 2
      B_F_NAME 64 30 56 0 0 1 0 30 30 0 0 0 0 0 1 0 0 0
      End of definition
      *
      Definition for table BILLING.B2
      Record length: 92
      Syskey: 0
      Columns: 2
      B_ID 64 50 0 0 0 1 0 50 50 50 0 0 0 0 1 0 1 2
      B_L_NAME 64 30 56 0 0 1 0 30 30 0 0 0 0 0 1 0 1 0
      End of definition


      I have setup the replicat to read the sourcedefs and remap the column

      -- Identify the Replicat group:
      REPLICAT rxtest
      -- State that source and target definitions are identical:
      --ASSUMETARGETDEFS
      SOURCEDEFS /u12/oracle/golden_gate_11_rep/dirsql/defgen_billing.sql
      --Discard Setup
      DISCARDFILE /u12/oracle/golden_gate_11_rep/dirout/rxtest.txt , PURGE
      SETENV (NLS_LANG="AMERICAN_AMERICA.WE8MSWIN1252")
      -- Specify database login information as needed for the database:
      USERID gg, PASSWORD
      -- Specify error handling rules:
      REPERROR (DEFAULT, ABEND)

      DDL EXCLUDE ALL

      MAP billing.b1, TARGET billing.r1,
      COLMAP (
      B_ID = id,
      b_f_name = f_name);

      Now when I try and start the rxtest replicat I get this error in the report.

      MAP resolved (entry BILLING.B1):
      MAP BILLING.B1, TARGET billing.r1, COLMAP ( B_ID = id, b_f_name = f_name);
      ...( B_ID = id, b_f_name = f_name...
      ^
      Error in COLMAP clause. Column name not found.

      Any ideas? Thanks