Question

5
Replies
1460
Views
Giridhar_Metikal Member since 2014 95 posts
Instellars Global Consulting
Posted: 4 years ago
Last activity: 3 years 2 months ago
Closed
Solved

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

Data Integration
Moderation Team has archived post
Share this page LinkedIn