All Apps and Add-ons

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

imanpoeiri
Communicator

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.

1 Solution

imanpoeiri
Communicator

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!

View solution in original post

imanpoeiri
Communicator

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
Contributor

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

0 Karma

anupjishnu
Path Finder

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

laiyongmao
Path Finder

The perfect solution to my problem.

anupjishnu
Path Finder

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

imanpoeiri
Communicator

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.

0 Karma

anupjishnu
Path Finder

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

0 Karma

anupjishnu
Path Finder

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.

0 Karma
Get Updates on the Splunk Community!

Announcing Scheduled Export GA for Dashboard Studio

We're excited to announce the general availability of Scheduled Export for Dashboard Studio. Starting in ...

Extending Observability Content to Splunk Cloud

Watch Now!   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to leverage ...

More Control Over Your Monitoring Costs with Archived Metrics GA in US-AWS!

What if there was a way you could keep all the metrics data you need while saving on storage costs?This is now ...