[Spacewalk-list] SQLGrammarException on kickstart

[Rene Lehmann]

Hey all,

since updating Spacewalk from 1.0 to 1.1 i will get the following exception
during a kickstart:

org.hibernate.exception.SQLGrammarException: could not update:
[com.redhat.rhn.domain.kickstart.KickstartableTree#1]
		 at org.hibernate.exception.SQLStateConverter.convert
(SQLStateConverter.java:67)
		 at org.hibernate.exception.JDBCExceptionHelper.convert
(JDBCExceptionHelper.java:43)
		 at
org.hibernate.persister.entity.AbstractEntityPersister.update
(AbstractEntityPersister.java:2425)
		 at
org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert
(AbstractEntityPersister.java:2307)
		 at
org.hibernate.persister.entity.AbstractEntityPersister.update
(AbstractEntityPersister.java:2607)
		 at org.hibernate.action.EntityUpdateAction.execute
(EntityUpdateAction.java:92)
		 at org.hibernate.engine.ActionQueue.execute
(ActionQueue.java:250)
		 at org.hibernate.engine.ActionQueue.executeActions
(ActionQueue.java:234)
		 at org.hibernate.engine.ActionQueue.executeActions
(ActionQueue.java:142)
		 at
org.hibernate.event.def.AbstractFlushingEventListener.performExecutions
(AbstractFlushingEventListener.java:298)
		 at org.hibernate.event.def.DefaultFlushEventListener.onFlush
(DefaultFlushEventListener.java:27)
		 at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:1000)
		 at org.hibernate.impl.SessionImpl.managedFlush
(SessionImpl.java:338)
		 at org.hibernate.transaction.JDBCTransaction.commit
(JDBCTransaction.java:106)
		 at
com.redhat.rhn.common.hibernate.ConnectionManager.commitTransaction
(ConnectionManager.java:230)
		 at
com.redhat.rhn.common.hibernate.HibernateFactory.commitTransaction
(HibernateFactory.java:318)
		 at
com.redhat.rhn.taskomatic.task.SingleThreadedTestableTask.execute
(SingleThreadedTestableTask.java:55)
		 at org.quartz.core.JobRunShell.run(JobRunShell.java:214)
		 at org.quartz.simpl.SimpleThreadPool$WorkerThread.run
(SimpleThreadPool.java:549)
Caused by: java.sql.SQLException: ORA-04098: trigger
'SPACEWALK.RHN_KSTREE_MOD_TRIG' is invalid and failed re-validation

		 at oracle.jdbc.driver.DatabaseError.throwSqlException
(DatabaseError.java:112)
		 at oracle.jdbc.driver.T2CConnection.checkError
(T2CConnection.java:676)
		 at oracle.jdbc.driver.T2CConnection.checkError
(T2CConnection.java:602)
		 at oracle.jdbc.driver.T2CPreparedStatement.executeForDescribe
(T2CPreparedStatement.java:571)
		 at oracle.jdbc.driver.T2CPreparedStatement.executeForRows
(T2CPreparedStatement.java:764)
		 at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout
(OracleStatement.java:1190)
		 at oracle.jdbc.driver.OraclePreparedStatement.executeInternal
(OraclePreparedStatement.java:3370)
		 at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate
(OraclePreparedStatement.java:3454)
		 at
com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.executeUpdate
(NewProxyPreparedStatement.java:79)
		 at org.hibernate.jdbc.NonBatchingBatcher.addToBatch
(NonBatchingBatcher.java:23)
		 at
org.hibernate.persister.entity.AbstractEntityPersister.update
(AbstractEntityPersister.java:2403)
		 ... 16 more

Mit freundlichen Grüßen / Kind regards

Rene Lehmann
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://listman.redhat.com/archives/spacewalk-list/attachments/20100816/96569faa/attachment.htm>