arcsight cdf intelligence analytic error
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
0
Comments
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.
@SruthiA thanks for your reply, can you show how to do it?
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.
Bryan_H Thanks a lot, i am now out of office and will be back next week and will try.
Thanks a lot, afet i opened case issue was fix. have a nice day