Which version of CAS are you running? This was an issue which got resolved
in 3.4.2.
On Mon, Apr 19, 2010 at 7:34 AM, Jeff Chapin <jeff.cha...@uni.edu> wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> I am getting the following error -- I assume it is because I have
> something configured wrong, as the database schema was setup by CAS:
>
> Exception in thread "pool-2-thread-174783"
> 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_DATE) Values(?, ?, ?, ?, ?, ?, ?)]; ORA-01400: cannot insert NULL
> into ("CAS_CONFIG_HATHOR"."COM_AUDIT_TRAIL"."AUD_USER")
> ; nested exception is java.sql.SQLException: ORA-01400: cannot insert
> NULL into ("CAS_CONFIG_HATHOR"."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:127)
> 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_HATHOR"."COM_AUDIT_TRAIL"."AUD_USER")
>
> at
> oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:112)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:331)
> at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:288)
> at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:743)
> at
>
> oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:216)
> at
>
> oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:955)
> at
>
> oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1168)
> at
>
> oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3285)
> at
>
> oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3368)
> at
>
> com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate(NewProxyPreparedStatement.java:105)
> at
>
> org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:798)
> at
> org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
>
>
> Any ideas how to fix this ?
> - --
> Jeff Chapin,
> Assistant Systems/Applications Administrator
> ITS-IS, University of Northern Iowa
> Phone: 319-273-3162 Email: jeff.cha...@uni.edu
> -----BEGIN PGP SIGNATURE-----
> Version: GnuPG v1.4.9 (GNU/Linux)
> Comment: Using GnuPG with Fedora - http://enigmail.mozdev.org/
>
> iEYEARECAAYFAkvMag8ACgkQQiaEUfQoY7TaGgCeMT17NBiiiNzy92mh4idv4Jei
> CDIAmwZY6lFAUJCAIg89+YSYiApYdqpq
> =sP4v
> -----END PGP SIGNATURE-----
>
> --
> You are currently subscribed to cas-user@lists.jasig.org as:
> pbe...@gmail.com
> To unsubscribe, change settings or access archives, see
> http://www.ja-sig.org/wiki/display/JSG/cas-user
>
--
You are currently subscribed to cas-user@lists.jasig.org as:
arch...@mail-archive.com
To unsubscribe, change settings or access archives, see
http://www.ja-sig.org/wiki/display/JSG/cas-user
