PDA

View Full Version : ContentItem table



niru
05-16-2007, 03:36 PM
Hi,

How do the various tables that Pentaho internally depends upon get created., For example, the ContentItem table. I am trying to execute a report on my database SA and here is the error I get executing a JDBC statement ( which I did not write at all) - its coming from some reporting component. Is there any script available to create the mysql database. Thanks for any help!


ERROR -
59c8aa0e-03e1-11dc-a7ba-f34ff7b3990d:RUNTIME:context-28404046-1179342732
312:jasper.xaction RuntimeContext.ERROR_0012 - ActionDefinition for JasperReport
sComponent did not execute successfully
ERROR - 59c8aa0e-03e1-11dc-a7ba-f34ff7b3990d:SOLUTION-ENGINE:jasper.xaction: Sol
utionEngine.ERROR_0007 - Action sequence execution failed
Hibernate: insert into CONTENTITEM (REVISION, NAME, parent_id, PATH, TITLE, MIME
TYPE, URL, LATESTVERNUM, EXTENSION, WRITEMODE, CONTITEMID) values (?, ?, ?, ?, ?
, ?, ?, ?, ?, ?, ?)
WARN - SQL Error: 1146, SQLState: 42S02
ERROR - Table 'SA.CONTENTITEM' doesn't exist
ERROR - Could not synchronize database state with session
org.hibernate.exception.SQLGrammarException: Could not execute JDBC batch update

at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.j
ava:65)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelp
er.java:43)
at org.hibernate.jdbc.AbstractBatcher.executeBatch(AbstractBatcher.java:
202)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.j
ava:91)
at org.hibernate.jdbc.AbstractBatcher.prepareStatement(AbstractBatcher.j
ava:86)
at org.hibernate.jdbc.AbstractBatcher.prepareBatchStatement(AbstractBatc
her.java:171)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
tEntityPersister.java:2048)
at org.hibernate.persister.entity.AbstractEntityPersister.insert(Abstrac
tEntityPersister.java:2427)
at org.hibernate.action.EntityInsertAction.execute(EntityInsertAction.ja
va:51)
at org.hibernate.engine.ActionQueue.execute(ActionQueue.java:243)
at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:227)

at org.hibernate.engine.ActionQueue.executeActions(ActionQueue.java:140)

at org.hibernate.event.def.AbstractFlushingEventListener.performExecutio
ns(AbstractFlushingEventListener.java:296)
at org.hibernate.event.def.DefaultFlushEventListener.onFlush(DefaultFlus
hEventListener.java:27)
at org.hibernate.impl.SessionImpl.flush(SessionImpl.java:980)
at org.hibernate.impl.SessionImpl.managedFlush(SessionImpl.java:353)
at org.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java
:106)
at org.pentaho.repository.HibernateUtil.commitTransaction(HibernateUtil.
java:372)
at org.pentaho.repository.HibernateUtil.systemExitPoint(HibernateUtil.ja
va:612)
at org.pentaho.core.system.StandaloneApplicationContext.invokeExitPoints
(StandaloneApplicationContext.java:126)
at org.pentaho.core.system.PentahoSystem.systemExitPoint(PentahoSystem.j
ava:1287)
at org.pentaho.ui.servlet.ViewAction.doGet(ViewAction.java:211)