[jboss-user] [JBoss Portal] - ERROR [SchemaExport] schema export unsuccessful

[anders3]

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)


View the original post : http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4041257#4041257

Reply to the post : http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4041257