Support Article
AES fails to parse SQL
SA-47100
Summary
Autonomic Event Services (AES) occasionally fails to parse SQL and throws an error message in its log file.
Error Messages
2017-10-24 08:41:00,548 [fault (self-tuning)'] [ STANDARD] [ ] [ AES:07.30] (Action_QueryPerformance.Action) ERROR - Encountered error while trying to parse the following SQL:
SELECT "Operator"."pyUserName" AS "pyUserName" , "PC0"."pyStatusWork" AS "pyStatusWork", COUNT("PC0"."pyID") AS "pySummaryCount(1)" FROM DATA.pc_work "PC0" INNER JOIN DATA.pc_assign_worklist "WL" ON ( ( "WL"."pxRefObjectKey" = "PC0"."pzInsKey" ) AND ( "PC0"."pxObjClass" NOT LIKE ? AND "PC0"."pxObjClass" NOT LIKE ? ) AND "WL"."pxObjClass" = ? ) INNER JOIN DATA.pr_operators "Operator" ON ( ( "WL"."pxAssignedOperatorID" = "Operator"."pyUserIdentifier" ) AND "Operator"."pxObjClass" = ? AND "WL"."pxObjClass" = ? ) WHERE ( "Operator"."pyWorkGroup" = ? ) GROUP BY "Operator"."pyUserName" , "PC0"."pyStatusWork" ORDER BY 1 ASC, 2 ASC
Expected a comparison operator!!!!: {type=PERIOD, spos=226, epos=226, text='.'}
com.pega.aes.utils.sql.ParseException: Expected a comparison operator!!!!: {type=PERIOD, spos=226, epos=226, text='.'}
at com.pega.aes.utils.sql.BinaryExpression.parseBinaryExpression(BinaryExpression.java:128) ~[aes_utilities.jar:?]
at com.pega.aes.utils.sql.LogicalExpression.parseLogicalExpression(LogicalExpression.java:123) ~[aes_utilities.jar:?]
at com.pega.aes.utils.sql.LogicalExpression.parseLogicalExpression(LogicalExpression.java:112) ~[aes_utilities.jar:?]
at com.pega.aes.utils.sql.LogicalExpression.parseLogicalExpression(LogicalExpression.java:112) ~[aes_utilities.jar:?]
at com.pega.aes.utils.sql.SQLParser.parseJoinClause(SQLParser.java:277) ~[aes_utilities.jar:?]
at com.pega.aes.utils.sql.SQLParser.parseFromClause(SQLParser.java:237) ~[aes_utilities.jar:?]
at com.pega.aes.utils.sql.SQLParser.parseSelectStatement(SQLParser.java:589) ~[aes_utilities.jar:?]
at com.pega.aes.utils.sql.SQLParser._parse(SQLParser.java:602) ~[aes_utilities.jar:?]
at com.pega.aes.utils.sql.SQLParser.parse(SQLParser.java:828) ~[aes_utilities.jar:?]
at com.pegarules.generated.activity.ra_action_generateadvice_d18723eb9efc4a6cc53b1695051e45b7.step7_circum0(ra_action_generateadvice_d18723eb9efc4a6cc53b1695051e45b7.java:1056) ~[?:?]
Steps to Reproduce
Not Applicable
Root Cause
A defect in Pegasystems’ code or rules:
Since AES features do not depend on the ability to parse SQL in the action item, this is not considered as an issue.
Resolution
This issue is planned to be fixed as part of a larger enhancement to SQL parsing in AES in a future release.
This specific request is tracked in FDBK-23576.
Tags:
Published January 13, 2018 - 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.