topic [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData. in All Apps and Add-ons

[ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.

imanpoeiri — Wed, 06 May 2015 11:30:21 GMT

Hi Experts,

I use DB Inputs to collect data from DB and applying cron-job to collect it every 5 mins but I found this flooded in the dbx2.log.
Any advise what is happening here?

05/06/2015 18:05:19 [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.
05/06/2015 18:05:19 [ERROR] [websocket.py] ERROR: statement handle not executed: getMetaData.
05/06/2015 18:10:19 [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.
05/06/2015 18:10:19 [ERROR] [websocket.py] ERROR: statement handle not executed: getMetaData.
05/06/2015 18:15:19 [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.
05/06/2015 18:15:19 [ERROR] [websocket.py] ERROR: statement handle not executed: getMetaData.
05/06/2015 18:20:21 [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.
05/06/2015 18:20:21 [ERROR] [websocket.py] ERROR: statement handle not executed: getMetaData.
05/06/2015 18:25:20 [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.
05/06/2015 18:25:20 [ERROR] [websocket.py] ERROR: statement handle not executed: getMetaData.
05/06/2015 18:30:20 [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.
05/06/2015 18:30:20 [ERROR] [websocket.py] ERROR: statement handle not executed: getMetaData.
05/06/2015 18:35:17 [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.
05/06/2015 18:35:17 [ERROR] [websocket.py] ERROR: statement handle not executed: getMetaData.
05/06/2015 18:40:19 [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.
05/06/2015 18:40:19 [ERROR] [websocket.py] ERROR: statement handle not executed: getMetaData.
05/06/2015 18:45:20 [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.
05/06/2015 18:45:20 [ERROR] [websocket.py] ERROR: statement handle not executed: getMetaData.
05/06/2015 18:50:18 [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.
05/06/2015 18:50:18 [ERROR] [websocket.py] ERROR: statement handle not executed: getMetaData.
05/06/2015 18:55:20 [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.
05/06/2015 18:55:20 [ERROR] [websocket.py] ERROR: statement handle not executed: getMetaData.
05/06/2015 19:00:20 [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.
05/06/2015 19:00:20 [ERROR] [websocket.py] ERROR: statement handle not executed: getMetaData.
05/06/2015 19:05:18 [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.
05/06/2015 19:05:18 [ERROR] [websocket.py] ERROR: statement handle not executed: getMetaData.
05/06/2015 19:10:19 [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.
05/06/2015 19:10:19 [ERROR] [websocket.py] ERROR: statement handle not executed: getMetaData.
05/06/2015 19:15:20 [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.
05/06/2015 19:15:20 [ERROR] [websocket.py] ERROR: statement handle not executed: getMetaData.
05/06/2015 19:20:20 [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.
05/06/2015 19:20:20 [ERROR] [websocket.py] ERROR: statement handle not executed: getMetaData.
05/06/2015 19:25:19 [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.
05/06/2015 19:25:19 [ERROR] [websocket.py] ERROR: statement handle not executed: getMetaData.

Re: [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.

anupjishnu — Wed, 06 May 2015 15:18:06 GMT

I have the exact same error and am trying to search for a solution. While creating the DBInput, it does show data from Database in Preview. But no data is being indexed while I see this error being logged. I read somewhere about ojdbc5.jar having this problem, but I am using ojdbc6.jar. Continuing to search.

Re: [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.

imanpoeiri — Thu, 07 May 2015 10:00:34 GMT

I logged a case to SPLUNK as I couldnt find any article that could help me to lighten the issue. Any updates from developer will be posted here by me or by the developer itself.

Re: [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.

anupjishnu — Thu, 07 May 2015 13:36:07 GMT

🙂 I opened a case with Splunk as well. Lets hope they provide some solution fast.

I uninstalled and re-sinstalled Splunk DB Connect just to confirm if I missed anything. But still the same issue. Enabling DEBUG logging in Splunk DB Connect did not give me additional information to cause or resolution.

Re: [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.

imanpoeiri — Fri, 08 May 2015 04:09:37 GMT

Hey Guys,

Finally I made it works! What was happen is I have my PC runs in JRE 8 and been use ojdbc6.jar as a lib. Notice that ojdbc7 was the latest release so I update it into the latest one, and hoollaaaa! it works very well.

Hope it helps developers out there.
Cheers!

Re: [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.

anupjishnu — Fri, 08 May 2015 13:40:46 GMT

Interesting....I will give it a shot now.

Re: [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.

anupjishnu — Fri, 08 May 2015 13:58:24 GMT

imanpoeiri, you saved my day.
As you mentioned, I updated ojdbc to ojdbc7.jar and it works now
Thanks again.

Re: [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.

laiyongmao — Thu, 18 Jun 2015 07:57:11 GMT

The perfect solution to my problem.

Re: [ERROR] [ws.py] [DBInput Service] ERROR: statement handle not executed: getMetaData.

hemendralodhi — Fri, 03 Jun 2016 02:58:29 GMT

I have a question on this: For Oracle 11g release 2 - ojdbc6.jar is specified and ojdbc7.jar is for Oracle 12c. Isn't it specific to what Oracle version is used? Will ojdbc7.jar works with Oracle 11g release 2? Also on Oracle driver page it is said that ojdbc6.jar is compatible with Java 8.

I have installed the app with ojdbc6.jar but not tested yet.

Thanks
Hemendra