All Apps and Add-ons

What's causing the error 'Incorrect syntax near the keyword 'user' when trying to output data to a table containing a field named "user" in DBConnect 3.1.1?

Path Finder

Hello,

I'm trying to output data to a table containing a field named "user". User being a reserved keyword in SQL, it throws the following error:

2018-05-01 10:15:09.378 +0200  [QuartzScheduler_Worker-10] INFO  com.splunk.dbx.connector.logger.AuditLogger - operation=dboutput connection_name=aaa stanza_name=bbb state=error sql='INSERT INTO "ccc"."dbo"."ddd" (eee,**user**,fff,ggg) values (?,?,?,?)' message='Incorrect syntax near the keyword 'user'.'

Is there any way to workaround this, such as forcing it to be called enclosed by brackets

sql='INSERT INTO "ccc"."dbo"."ddd" ([eee],**[user]**,[fff],[ggg]) values (?,?,?,?)' 

Thanks!

0 Karma
1 Solution

Path Finder

Answering my own question...

I was able to work around this by enclosing my user (to [user]) field in the customized_mappings stanza in db_outputs.conf and restarting splunk.

View solution in original post

Path Finder

Answering my own question...

I was able to work around this by enclosing my user (to [user]) field in the customized_mappings stanza in db_outputs.conf and restarting splunk.

View solution in original post

Don’t Miss Global Splunk
User Groups Week!

Free LIVE events worldwide 2/8-2/12
Connect, learn, and collect rad prizes and swag!