10 Replies Latest reply: Jan 23, 2014 7:22 PM by petra-K RSS

    Table contains one or more variable length columns???

      Hi all.

       

      GG 11.2.0.1

       

      I am replicating 2 mssql table to oracle which are:

      ACRBLOCKCARDDETAILS

      ACRMASTER

       

      One of the pre-reqs is to add trandata:

       

      ADD TRANDATA DBO.ACRBLOCKCARDDETAILS

      ADD TRANDATA DBO.ACRMASTER

       

      The first table has no error, but the 2nd has this error:

      ==============

      2014-01-19 18:57:10  WARNING OGG-01483  The key for table [dtc2.dbo.TRANS_MSTR] contains one or more variable length columns. 

      These columns may not have their pre-images written to the transaction log during updates.  Please use KEYCOLS to specify a key for Oracle GoldenGate to use on this table.

       

      When I describe structure of the two tables, they are  similar. What makes GG flag the 2nd table as having variable length columns? Thanks a lot.

       

      =============

       

      CREATE TABLE [dbo].[ACRBlockCardDetails](

          [TransId] [bigint] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL,

          [ApplicationId] [varchar](15) NULL,

          [ACRNumber] [varchar](15) NOT NULL,

          [CardSerialNumber] [varchar](50) NOT NULL,

          [CardIssuerNumber] [int] NULL,

          [CardStatus] [varchar](5) NULL,

          [BlockDate] [datetime] NOT NULL,

          [Remarks] [varchar](50) NULL,

          [Username] [varchar](30) NULL,

          [BlockReason] [smallint] NULL,

          [AmendmentId] [bigint] NULL,

      CONSTRAINT [PK_ACRBlockCardDetails] PRIMARY KEY CLUSTERED

      (

          [TransId] ASC

      )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

      ) ON [PRIMARY]

       

      ==============

       

      CREATE TABLE [dbo].[ACRMSTR](

          [SSRNID] [varchar](20) NOT NULL,

          [LASTNAME] [varchar](100) NULL,

          [FIRSTNAME] [varchar](100) NULL,

          [MIDDLENAME] [varchar](100) NULL,

          [ALIASNAME] [varchar](100) NULL,

          [FULLNAME] [varchar](500) NULL,

          [BDATE] [varchar](10) NULL,

          [GENDER] [varchar](1) NULL,

          [CITIZENOF] [int] NULL,

          [STATUS] [smallint] NULL,

          [REG_DATE] [datetime] NULL,

          [LOC_ID] [smallint] NULL,

      CONSTRAINT [PK_REG_MSTR] PRIMARY KEY CLUSTERED

      (

          [SSRNID] ASC

      )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON) ON [PRIMARY]

      ) ON [PRIMARY]

       

      GO

       

      ==============

       

       

       

      I