ORA-01400: cannot insert NULL into ... issue

[dirkdam]

Hi,

i have problems running my application on a linux environment. The jasper reports are embedded into a web application. when clicking a report however i get a stacktrace.

It seems nothing can be insert into the jasper database, I use jboss510GA and oracleXE112

below part of the stacktrace.. I saw some topic on wrong dialect or so, but i have set it to Oracle10g dialect, should be ok....

Anyone a clue? Any more info needed?

10:20:02,117 WARN  [org.hibernate.util.JDBCExceptionReporter] SQL Error: 1400, SQLState: 23000
10:20:02,117 ERROR [org.hibernate.util.JDBCExceptionReporter] ORA-01400: cannot insert NULL into ("JASPERSERVER"."JIACCESSEVENT"."ID")

10:20:02,118 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/apps/mars/jasperserver].[dwr]] Servlet.service() for servlet dwr threw exception
org.springframework.dao.DataIntegrityViolationException: could not insert: [com.jaspersoft.jasperserver.api.logging.access.domain.hibernate.RepoAccessEvent]; nested exception is org.hibernate.exception.ConstraintViolationException: could not insert: [com.jaspersoft.jasperserver.api.logging.access.domain.hibernate.RepoAccessEvent]
    at org.springframework.orm.hibernate3.SessionFactoryUtils.convertHibernateAccessException(SessionFactoryUtils.java:636)
    at org.springframework.orm.hibernate3.HibernateAccessor.convertHibernateAccessException(HibernateAccessor.java:412)

etc etc

 

Caused by: org.hibernate.exception.ConstraintViolationException: could not insert: [com.jaspersoft.jasperserver.api.logging.access.domain.hibernate.RepoAccessEvent]
    at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:94)
    at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
    at org.hibernate.id.insert.AbstractReturningDelegate.performInsert(AbstractReturningDelegate.java:64)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2176)
    at org.hibernate.persister.entity.AbstractEntityPersister.insert(AbstractEntityPersister.java:2656)

 

etc etc