3 Replies Latest reply: Nov 5, 2012 6:17 AM by Keith Hollins RSS

    ERROR   OGG-00367  Error in COLS/COLSEXCEPT list: could not find close para

    Keith Hollins
      I'm getting ERROR OGG-00367 Error in COLS/COLSEXCEPT list: could not find close parantheses. when I try to use COLS clause in
      SQL Server 2005
      Windows 2003 Standard Edition SP2
      GoldenGate 11.1.1.1.2
      but my COLS clause seems fine (I've tried various combinations of whitespace, double quotes):

      TABLE DBO.SYSTEMTIMEDSTATS, COLS ("statdate", "agentsloggedon", "agentsonline", "emailsinoutbox", "activecallbacks", "activetelephony", "activevoip", "ip", "aid");

      Where is it expecting a closing parenthesis?

      The only way I can get it working is to remove the COLS clause and capture all columns.

      Keith H.