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

[imanpoeiri]

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.

[imanpoeiri · Accepted solution]

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!

[hemendralodhi]

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

[anupjishnu]

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

[laiyongmao]

The perfect solution to my problem.

[anupjishnu]

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

[imanpoeiri]

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.

[anupjishnu]

🙂 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.

[anupjishnu]

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.