Skip to main content

This content has been archived and is no longer being updated. Links may not function; however, this content may be relevant to outdated versions of the product.

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.

Published January 13, 2018 - Updated December 2, 2021

Was this useful?

100% found this useful

Have a question? Get answers now.

Visit the Collaboration Center to ask questions, engage in discussions, share ideas, and help others.

Did you find this content helpful?

We'd prefer it if you saw us at our best.

Pega Community has detected you are using a browser which may prevent you from experiencing the site as intended. To improve your experience, please update your browser.

Close Deprecation Notice