Question

5
Replies
1592
Views
Giridhar Metikal (Giridhar_Metikal)
Instellars Global Consulting
Consultant
Instellars Global Consulting
SG
Giridhar_Metikal Member since 2014 95 posts
Instellars Global Consulting
Posted: August 9, 2016
Last activity: July 14, 2017
Posted: 9 Aug 2016 8:15 EDT
Last activity: 14 Jul 2017 10:40 EDT
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, This thread is closed to future replies. Content and links will no longer be updated. If you have the same/similar Question, please write a new Question.