Question
BlueRose Technologies
AU
Last activity: 14 Jul 2017 10:40 EDT
When do we get the exception " The specified SQL is invalid: Encountered "" at line 0, column 0. Was expecting one of: "{" ... "/*" ... "\\{" ... "\\}" ... "\\\\" ... ..." in the Connect-SQL rule
Hi All,
I am invoking a Connect-SQL rule via "RDB-List" method in my activity. When I run the activity as a stand alone, it is throwing the exception " The specified SQL is invalid: Encountered "" at line 0, column 0. Was expecting one of: "{" ... "/*" ... "\\{" ... "\\}" ... "\\\\" ... ..." "
Please find my query here "select distinct r.PYRULENAME,r.PYCLASSNAME,r.PYRULESET,r.pyrulesetversion from PBSTD01.pr4_rule r where r.pxobjclass='Rule-Obj-Listview' and r.PYRULESET in ('AEXP_WS_QN','AEXP_WS_QNInt','AEXP_WS','AEXPWSInt','AEXP_FW_QN','AEXP_FW_QNInt','AEXPFWQUICKAPP','AEXPFWEnt-UI','AEXP_FW_EntService','AEXP_FW_Ent','AEXPConnectorFW','AEXP_FW_EntInt','AEXPService','AEXP','AEXPInt','AEXPBaseline');"
Can anybody help me troubleshoot this issue? Thanks in advance.
Can anybody
Accepted Solution
Pegasystems Inc.
US
Can you please attach the complete server log along your pega version as well? The query itself seems to be fine. This link may be relevant to you as the user misconfigured the Connect-SQL:
https://pdn.pega.com/community/pega-platform/question/sorting-list-views
Bank of Nova Scotia
CA
May be you are using RDB-List method in your activity and your Connect-SQL is trying to Save/Update.
If you are making any udpates to DB, then use RDB-Save.
EY
IN
Hi,
This Error msg comes when you are using RDB-LIST and you have posted your query under "open" tab in "Connect- SQL"
Cross check that in "Connect SQL" whether you have posted your SQL Query under "BROWSE" tab or not.
Thank You,
Apurva