No active view filters are available and cannot create new filters.

After installing Sentinel and logging into SCC we do not see any available filters for creating Active Views. Attempting to add new active views returns the error;

Error occurred while trying to save filter;

error 20000 esecurity.base.exceptions.PersistenceException: Execute INSERT INTO CONFIGS.......

Would you like to try again or discard your changes?

(Screen-shot below)


Further investigation shows that the install logs for inserting the seed data failed. The specific files were in the $ESEC_HOME/install_log/db/ directory. Specifically the files were the seed_config_.log.

The errors in the seed data were java errors java.sql.SQLException on the CLOB data type. (See Additional Notes)

In this case, the customer was using a 9.2 client for the remote install of the database on a 10g Oracle DB. Once we switched to a 10.x client the install was able to complete successfully and install the CLOB seed data.

The general idea is that if the customer is creating the ESEC database on a 10g system, they should use the 10.x client. If they are using a 9i system, they should be using the 9.x client.