Security

DBConnect v2 Hung Parsing Job

fdarrigo
Path Finder

All,
DBConnect v2 is hanging when parsing the job during configuration. I am adding a new DB Input, which uses a SQL connection to a SQL Server. The identity is a local SQL account with read permissions in the database. I can log into SQL as the DBConnect identity user and I can run a query against the table, so the SQL permissions are correct.

I have tried the following Database Types:
MS_SQL Server using jTDS Driver;
MS_SQL Server using jTDS Driver with Windows Authentication
MS-SQL Server Using Generic Driver
MS-SQL Server Using Generic Driver with Windows Authentication.

The connection passes the validation step.
Steps to reproduce issue

Click Operations>DB Inputs> Select Input (i.e. TestDBInput)> Make sure its enabled ("Valid Connection" displays)>Continue>Choose and Preview Table> "Parsing job..." indicator spins> Make sure I have specified the correct catalog, schema, table>Set Max Rows to 100.

Clicked Simple Query Mode drop down >(in the advanced query editor)>confirm the sql is correct.

I am running DBConnect v2 on a 6.3.3 Heavy Forwarder.

JRE Status
JRE Installation Path /usr/lib/jvm/java-8-oracle
JVM Options: -Xmx1024m -XX:+UseConcMarkSweepGC
RPC Server Port 9998
RPS Server SSL Disbaled

Any ideas what would cause this?

1 Solution

fdarrigo
Path Finder

SOLVED!

I opened a ticket with Splunk Support. Randy Morlen grabbed the ticket and asked for a diag. After investigating, he found the following error:
HTTPError: HTTP 402 Payment Required -- In handler 'shclusterconfig': Requires license feature='DistSearch'

After a little back and forth, Randy provided a 1-byte license for my HF . DBX2 immediately parsed the SQL and connected. Data is now flowing from my SQL server to Splunk.

Thanks Randy. I appreciate your help

Note for Splunk Dev: Please add a check for the appropriate license during the DBX setup to avoid this issue in the future.

View solution in original post

fdarrigo
Path Finder

SOLVED!

I opened a ticket with Splunk Support. Randy Morlen grabbed the ticket and asked for a diag. After investigating, he found the following error:
HTTPError: HTTP 402 Payment Required -- In handler 'shclusterconfig': Requires license feature='DistSearch'

After a little back and forth, Randy provided a 1-byte license for my HF . DBX2 immediately parsed the SQL and connected. Data is now flowing from my SQL server to Splunk.

Thanks Randy. I appreciate your help

Note for Splunk Dev: Please add a check for the appropriate license during the DBX setup to avoid this issue in the future.

Get Updates on the Splunk Community!

Mastering Data Pipelines: Unlocking Value with Splunk

 In today's AI-driven world, organizations must balance the challenges of managing the explosion of data with ...

The Latest Cisco Integrations With Splunk Platform!

Join us for an exciting tech talk where we’ll explore the latest integrations in Cisco + Splunk! We’ve ...

AI Adoption Hub Launch | Curated Resources to Get Started with AI in Splunk

Hey Splunk Practitioners and AI Enthusiasts! It’s no secret (or surprise) that AI is at the forefront of ...