1 Reply Latest reply on Apr 27, 2007 4:23 AM by Thomas Heute

    ERROR [SchemaExport] schema export unsuccessful

    Anders Andersen Newbie

      Migration from 2.6-BETA1
      When I start 2.6-CR1 for the first time it will create tables....
      I have some data in table jbp_group that I want to keep

      I therefore dropped all tables except jbp_group (groups)

      This makes problems

      It seems like Portal/Hibernate cannot accept that some tables are there and others not.

      So I have to drop all tables or none ?
      /Anders


      ATTACHED: LOG

      java.sql.SQLException: You cannot commit during a managed transaction!
      at org.jboss.resource.adapter.jdbc.BaseWrapperManagedConnection.jdbcCommit(BaseWrapperManagedConnection.java:543)

      .....
      18:35:45,917 WARN [JDBCExceptionReporter] SQL Error: 1146, SQLState: 42S02
      18:35:45,918 ERROR [JDBCExceptionReporter] Table 'jbossportal.jbp_object_node' doesn't exist
      18:35:46,043 WARN [ServiceController] Problem starting service portal:container=PortalObject
      org.hibernate.exception.SQLGrammarException: could not execute query
      at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
      at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      at org.hibernate.loader.Loader.doList(Loader.java:2147)
      .....
      at org.hibernate.loader.Loader.doQuery(Loader.java:662)
      at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:224)
      at org.hibernate.loader.Loader.doList(Loader.java:2144)
      ... 139 more
      18:35:46,097 WARN [ServiceController] Problem starting service portal:service=Hibernate,type=Portlet
      org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=hilda.local/46, BranchQual=, localId=46]; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImpl:XidImpl[FormatId=257, GlobalId=hilda.local/46, BranchQual=, localId=46])
      at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)
      at org.jboss.portal.jems.hibernate.SessionFactoryBinder.startService(SessionFactoryBinder.java:229)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
      at org.jboss.system.ServiceMBeanSupport.start(ServiceMBeanSupport.java:196)
      at org.jboss.portal.jems.as.system.AbstractJBossService.start(AbstractJBossService.java:73)
      at sun.reflect.GeneratedMethodAccessor19.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)