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

Comments

  • SruthiASruthiA Administrator

    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.

  • edited May 2023

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

  • Bryan_HBryan_H Vertica Employee Administrator

    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

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Emoji
Image
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file