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!

Index This | I am a number, but when you add ‘G’ to me, I go away. What number am I?

March 2024 Edition Hayyy Splunk Education Enthusiasts and the Eternally Curious!  We’re back with another ...

What’s New in Splunk App for PCI Compliance 5.3.1?

The Splunk App for PCI Compliance allows customers to extend the power of their existing Splunk solution with ...

Extending Observability Content to Splunk Cloud

Register to join us !   In this Extending Observability Content to Splunk Cloud Tech Talk, you'll see how to ...