arcsight cdf intelligence analytic error

dgiorgobiani

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

SruthiA

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.

dgiorgobiani

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

Bryan_H

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.

dgiorgobiani

Bryan_H Thanks a lot, i am now out of office and will be back next week and will try.

dgiorgobiani

Thanks a lot, afet i opened case issue was fix. have a nice day