Sage Connector 2016 Syntax error

SOLVED

Have a report built container in Sage 2016 Connector.   The test runs fine, but when I attempt to run in Report Manager I get a syntax error near ','   (that's a comma).  here's the error text

Description : [Microsoft][ODBC SQL Server Driver][SQL Server]Incorrect syntax near ','.
Number : -2147217900
Source :
Driver Error : 102
SQL State : 37000

Now, usually I'd pull up the full query in a SQL editor but I can't see the full query, of course, because Connector is making it in the background.... how so I run this down?  

  • +1
    verified answer

    You have to have a Connector License and open up that particular Container in Connector. Once you are there, if you highlight your container, you will see several options in the Home Ribbon at the top. I would hit Check/Test. This button checks to see if there are errors in the main Source Container syntax. If that succeeds, then the error is likely in your individual expressions' coding. Hit Check/Test All Expressions. If it comes up with the error, then you still need to figure out which expression it is (unfortunately it doesn't give you that detail). To figure that out, highlight each expression one-by-one and hit the Check/Test while that expression is highlighted. Eventually, you will find your troublesome expression. Change the faulty code and try your Check/Tests again.

  • +2 in reply to Gabriela Yates
    verified answer

    I was able to figure out how to determine where the error was ocurring.    In Report Manager, right click on Home and Switch Output Mode.  Switch to Screen (SQL Debug).    I then tested the query there, which, of course, gave the same error and was able to drop the query into Notepad++ and figure out where the extra comma got created.    Once I established this, it was a matter of going into that particular expression and noticing my CASE Statement was written improperly.