This discussion is archived
3 Replies Latest reply: Nov 5, 2012 4:17 AM by Keith Hollins RSS

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

Keith Hollins Newbie
Currently Being Moderated
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.

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points