Getting Data In

DBconnect - input data the Redshift with error (Unable to process JSON)

dennisaraujo
Path Finder

Hi,

I successfully configured the AWS Red Shift JDBC driver, I can connect to the database and run queries, but when I create a data entry, in the last step, after clicking the "finish" button it shows the error message "Unable to process JSON" .

This error only occurs when I define a rising column (I'm using int following the dbconnect documentation).

Anyone else get past this?

Thanks!

0 Karma

rapmancz
Explorer

I have the same issue using Splunk DB connect 3.4.2 and Splunk 8.1.1. Any other ideas how to solve this issue?

0 Karma

ghollmann
Engager

Any solutions to this?  I'm trying to define DB Connect input to attach to a table in MS SQL Server with a rising column and when I try to save it get the "Unable to process JSON" error.  

0 Karma

Amusthofa
Explorer

Anyone ever got this solved?

We also got this kind of error when creating a DB Input for McAfee ePO 5.10. We could execute SQL queries & set it to rising column just fine, but when we tried to save the configuration, the "Unable to process JSON" error message appears.

0 Karma

mvarga2
Explorer

Same issue occurring in my environment, running the latest and greatest DBConnect v3.5.1.

0 Karma

mvarga2
Explorer

So if I populated the checkpoint field with something, it was able to save the input.

0 Karma

Amusthofa
Explorer

I got my issue solved.

The culprit was because I had used DBConnect 3.2.

When I changed to DBConnect 3.3, the problem was solved.

Solution to the issue in original question might be the same.

0 Karma

tlay
Explorer

I am seeing this message in 3.4.1.  Trying to work with ePO DLP.

0 Karma
*NEW* Splunk Love Promo!
Snag a $25 Visa Gift Card for Giving Your Review!

It's another Splunk Love Special! For a limited time, you can review one of our select Splunk products through Gartner Peer Insights and receive a $25 Visa gift card!

Review:





Or Learn More in Our Blog >>