The Vertica Forum recently got a makeover! Let us know what you think by filling out this short, anonymous survey.
Please take this survey to help us learn more about how you use third party tools. Your input is greatly appreciated!
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.