DB Connect: Why am I getting an error: "column does not exist" when trying to search query of new added field?

saeki_takuya_mk — Fri, 21 Aug 2015 11:19:11 GMT

Hi,

I had connected to PostgreSQL view using DB Connect.
After I add new fields to the view, I tried to select the new fields on 'Database Query' tab but failed with follow error : "column does not exist".

It seems DB Connect doesn't recognize to be changed schema.
But I can get complete schema data on 'Database Info'.

How can I use the new field on query?

I did restart Splunk on browser , but couldn't resolve it.
Configuration > Server Control > restart Splunk

Thanks

Re: DB Connect: Why am I getting an error: "column does not exist" when trying to search query of new added field?

saeki_takuya_mk — Thu, 27 Aug 2015 01:36:52 GMT

The problem has been resolved.

Solution is that specify view-name with double quote ' " '.

like this..

| dbquery "myDB" "SELECT * FROM \"the_view_name\"" limit=1000

topic DB Connect: Why am I getting an error: "column does not exist" when trying to search query of new added field? in Getting Data In

DB Connect: Why am I getting an error: "column does not exist" when trying to search query of new added field?

Re: DB Connect: Why am I getting an error: "column does not exist" when trying to search query of new added field?