Problem Statement:

Receiving error creating a Query: "Parser encountered a syntax error at or near token".

Solution:

Need to use the correct syntax.

  1. Check for extra or missing characters and parenthesis.
  2. If this occurs with a date field, check that the correct date wrapper is being used.
  3. If using a Group By clause: Do Not use a Group By clause with a sub-string

 

Ref#: 1475534

 

 

 

 


Still have questions? We can help. Submit a case to Technical Support.

Last Modified On: April 21, 2017