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!

More Ways To Control Your Costs With Archived Metrics | Register for Tech Talk

Tuesday, May 14, 2024  |  11AM PT / 2PM ET Register to Attend Join us for this Tech Talk and learn how to ...

.conf24 | Personalize your .conf experience with Learning Paths!

Personalize your .conf24 Experience Learning paths allow you to level up your skill sets and dive deeper ...

Threat Hunting Unlocked: How to Uplevel Your Threat Hunting With the PEAK Framework ...

WATCH NOWAs AI starts tackling low level alerts, it's more critical than ever to uplevel your threat hunting ...