topic Re: DBconnect - input data the Redshift with error (Unable to process JSON) in Getting Data In

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

dennisaraujo — Wed, 29 Apr 2020 00:14:57 GMT

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!

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

Amusthofa — Wed, 19 Aug 2020 07:14:46 GMT

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.

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

ghollmann — Wed, 30 Sep 2020 22:37:43 GMT

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.

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

Amusthofa — Mon, 19 Oct 2020 09:26:53 GMT

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.

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

rapmancz — Mon, 08 Feb 2021 10:10:12 GMT

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?

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

tlay — Thu, 18 Feb 2021 17:10:05 GMT

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

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

mvarga2 — Thu, 05 Aug 2021 16:00:08 GMT

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

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

mvarga2 — Thu, 05 Aug 2021 19:47:14 GMT

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

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

amartin6 — Thu, 26 May 2022 17:50:59 GMT

We were getting this error on one of our standalone search heads when trying to update the password of identities after a jre update, we noticed the jars/server.jar file didn't match with the other search centers, once we replaced that we were able to add identities and update existing ones.