-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 I have recently configured CAS as per http://www.ja-sig.org/wiki/display/CASUM/Auditing+and+Statistics+Via+Inspektr and http://www.ja-sig.org/wiki/display/CASUM/Throttling+Login+Attempts
When my user logs in, I am seeing to following error in the cas.log -- but the log-in is still behaving normally. Is this an error worth following up with? According to the schema for inspektr found at http://code.google.com/p/inspektr/wiki/DatabaseTables these tables should *NOT* be accepting NULL, so I am not sure what the error is. Exception in thread "pool-2-thread-1" org.springframework.dao.DataIntegrityViolationException: PreparedStatementCallback; SQL [Insert into COM_AUDIT_TRAIL(AUD_USER, AUD_CLIENT_IP, AUD_SERVER_IP, AUD_RESOURCE, AUD_ACTION, APPLIC_CD, AUD_D ATE) Values(?, ?, ?, ?, ?, ?, ?)]; ORA-01400: cannot insert NULL into ("CAS_CONFIG_DEVEL"."COM_AUDIT_TRAIL"."AUD_USER") ; nested exception is java.sql.SQLException: ORA-01400: cannot insert NULL into ("CAS_CONFIG_DEVEL"."COM_AUDIT_TRAIL"."AUD_USER") at org.springframework.jdbc.support.SQLErrorCodeSQLExceptionTranslator.doTranslate(SQLErrorCodeSQLExceptionTranslator.java:228) at org.springframework.jdbc.support.AbstractFallbackSQLExceptionTranslator.translate(AbstractFallbackSQLExceptionTranslator.java:72) at org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:607) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:792) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:850) at org.springframework.jdbc.core.JdbcTemplate.update(JdbcTemplate.java:858) at org.springframework.jdbc.core.simple.SimpleJdbcTemplate.update(SimpleJdbcTemplate.java:237) at org.inspektr.audit.support.JdbcAuditTrailManager$LoggingTask$1.doInTransactionWithoutResult(JdbcAuditTrailManager.java:96) at org.springframework.transaction.support.TransactionCallbackWithoutResult.doInTransaction(TransactionCallbackWithoutResult.java:33) at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:128) at org.inspektr.audit.support.JdbcAuditTrailManager$LoggingTask.run(JdbcAuditTrailManager.java:89) at java.util.concurrent.ThreadPoolExecutor$Worker.runTask(ThreadPoolExecutor.java:886) at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:908) at java.lang.Thread.run(Thread.java:619) Caused by: java.sql.SQLException: ORA-01400: cannot insert NULL into ("CAS_CONFIG_DEVEL"."COM_AUDIT_TRAIL"."AUD_USER") - -- Jeff Chapin, Assistant Systems/Applications Administrator ITS-IS, University of Northern Iowa Phone: 319-273-3162 Email: [email protected] -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/ iEYEARECAAYFAkt5xL8ACgkQQiaEUfQoY7RFcACfWw/pV+xzz7C/1o0agYWBCWZZ ZUoAnAto+Eb7yNlAZdOyci66dZqCTbhf =yfee -----END PGP SIGNATURE----- -- You are currently subscribed to [email protected] as: [email protected] To unsubscribe, change settings or access archives, see http://www.ja-sig.org/wiki/display/JSG/cas-user
