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

  • 3070348
  • 19-Dec-2007
  • 26-Apr-2012


Sentinel 6.0 install
Sentinel Control Center, (SCC)
Oracle 10g
Solaris 10


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.

Additional Information

Screen-shot of error:
Error from seed_config log:

12/18/2007 14:56:42 Failed to save object due to exception: Config: Data='' DateModified='1198018602062' Unit='categories' UserId='_SYSTEM' DateCreated='1198018602062' Application='_SYSTEM'; esecurity.base.exceptions.PersistenceException: Execute INSERT INTO CONFIGS ( CONFIGS.VALUE,CONFIGS.DATA,CONFIGS.DATE_MODIFIED,CONFIGS.UNIT,CONFIGS.CREATED_BY,CONFIGS.USR_ID,CONFIGS.DATE_CREATED,CONFIGS.APPLICATION,CONFIGS.MODIFIED_BY ) VALUES ( ?,?,?,?,?,?,?,?,? ) Params [[ 1:'null', 2: 'clob', 3:'1198018602062 (Tue Dec 18 14:56:42 PST 2007)', 4: 'categories', 5: 'null', 6:'_SYSTEM', 7: '1198018602062 (Tue Dec 18 14:56:42 PST 2007)', 8: '_SYSTEM', 9:'null']]
at esecurity.base.query.db.BaseJDBCQuery.executeDMLBatch(
at esecurity.base.query.db.JDBCInsertQuery.execute(
at esecurity.base.datamodel.LocalDataObjectManager.saveBatch(
at esecurity.base.datamodel.LocalDataObjectManager.saveDataObjects(
at esecurity.base.datamodel.LocalDataObjectManager.saveDataObjects(
at esecurity.base.datamodel.LocalDataObjectManager.saveDataObject(
at esecurity.base.util.DataObjectArchiver.loadArchiveToDatabase(
at esecurity.base.util.DataObjectArchiver.loadArchiveToDatabase(
at esecurity.db.install.DefaultInstaller.loadSeedDataHelper(
at esecurity.db.install.DefaultInstaller.loadSeedData(
at esecurity.db.install.DefaultInstaller.runInstall(
at esecurity.db.install.DefaultInstaller.config(
at com.esecurity.install.ConfigureOracleEsecDatabaseAction.execute(
at Source)
Caused by: java.lang.RuntimeException: java.lang.reflect.InvocationTargetException
at esecurity.base.db.platform.OraclePlatform.setClobToPS(
at esecurity.base.query.db.BaseJDBCQuery.setToPs(
at esecurity.base.query.db.BaseJDBCQuery.bindStatement(
at esecurity.base.query.db.BaseJDBCQuery.executeStatement(
at esecurity.base.query.db.BaseJDBCQuery.executeDMLBatch(
... 15 more
Caused by: java.lang.reflect.InvocationTargetException
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
at java.lang.reflect.Method.invoke(
at esecurity.base.db.platform.OraclePlatform.setClobToPS(
... 19 more
Caused by: java.sql.SQLException: Invalid argument(s) in call
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.jdbc.dbaccess.DBError.throwSqlException(
at oracle.sql.CLOB.createTemporary(
... 24 more

12/18/2007 14:56:42 Saved 0 objects.