Support Article
AES SQL Parser unable to parse statement
SA-616
Summary
The AES SQL Parser throws an error when attempting to parse a complex SQL statement produced by the application.
Error Messages
2014-06-16 08:03:31,036 | ERROR | WorkManager.PRPCWorkManager_WM : 2 | : | GenerateAdvice.PegaAES_Work_Action_QueryPerformance.Action | Msg: Encountered error while trying to parse the following SQL:
SELECT . . .
Expected FROM token!: {type=LPAREN, spos=236, epos=236, text='('}
Expected FROM token!: {type=LPAREN, spos=236, epos=236, text='('}
at com.pega.aes.utils.sql.SQLParser.parseSelectStatement(SQLParser.java:581)
at com.pega.aes.utils.sql.SQLParser._parse(SQLParser.java:597)
at com.pega.aes.utils.sql.SQLParser.parse(SQLParser.java:823)
Steps to Reproduce
Run application in such a way as to produce complex SQL statements.
Root Cause
The root cause of this problem is a defect in Pegasystems’ code/rules.
Resolution
This issue is addressed by HFix-9842.
Published March 21, 2016 - Updated December 2, 2021
Have a question? Get answers now.
Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.