Hi, and thanks for reaching out.

I took the liberty of reformatting your message and also truncating the syntax error string which looks odd to me. Is there any chance that's an API key you are using to authenticate? I wouldn't expect a key to ever appear in an error message like that and can't reproduce that happening, but it looks like something generated...

As some general troubleshooting steps, what happens if you drop the line setting colNameOpt from the executeSql? What if you add it to the selectRows? Do any of your field names contain a special character or are they excessively long perhaps? If you try only selecting one named column in your sql, does that succeed? Select * will also include 'internal' or system columns, which you may not want to be loading anyway.

test<-labkey.executeSql(
     baseUrl="http://localhost:8080/labkey", 
     folderPath = "/DEMO",
     schemaName = "lists",
     sql="SELECT Date from Test")

Another consideration is how you are authenticating. If you are using an API key or netrc file, have you tried directly authenticating using labkey.setDefaults in RStudio to see if there is a different result? As this is on your local machine, can you try adding another user account to see if the same behavior happens (and if the odd error code message is the same)?

To help any further, I'd need a bit more information from you. What version of LabKey are you running? Did you confirm that you are using (supported versions of tomcat, Java, and your database](https://www.labkey.org/Documentation/wiki-page.view?name=supported)?

--Molly