arcsight cdf intelligence analytic error

Forum|Forum|3 years ago
May 17, 2023
5 replies
10 views

dgiorgobiani
New Participant

i have installed arcsight cdf with TH, intelligence but analytics not working:
May 17, 2023 2:02:43 AM com.interset.analytics.datalayer.core.VerticaDataLayer logError
SEVERE: JDBC connection failed: [Vertica]VJDBC ERROR: Cannot set a NOT NULL column (RELATION) to a NULL value in INSERT/UPDATE statement
May 17, 2023 2:02:43 AM com.interset.analytics.datalayer.core.VerticaDataLayer logError
SEVERE: JDBC connection failed: [Vertica]VJDBC ERROR: Cannot set a NOT NULL column (RELATION) to a NULL value in INSERT/UPDATE statement
Exception in thread "main" java.sql.SQLDataException: [Vertica]VJDBC ERROR: Cannot set a NOT NULL column (RELATION) to a NULL value in INSERT/UPDATE statement

Please, if anyone can help

+1

SruthiA
Participating Frequently
Forum|Forum|3 years ago
May 17, 2023

it loos like you are trying to set null value to column which is defined as not null.. if you want insert to succeed please alter the table definition.

Like

dgiorgobiani
Author
New Participant
Forum|Forum|3 years ago
May 18, 2023

@SruthiA thanks for your reply, can you show how to do it?

Like

+2

Bryan_H
Participating Frequently
Forum|Forum|3 years ago
May 19, 2023

You can remove NOT NULL constraint as follows:
ALTER TABLE table ALTER COLUMN column DROP NOT NULL;
You might also consult ArcSight support to be sure this won't affect anything else with their product.