EPP + Site Publisher on Postgres 9.1 fails with "ERROR: relation "hibernate_sequence" does not exist Position: 17"
Issue
I've just installed EPP 5.2 and tried to configure it to connect to a local postgresql database. The install has failed to locate picket link database sequence in postgresql.
The server startup fails - the stack trace is attached
2012-04-07 08:11:05,387 ERROR [org.hibernate.util.JDBCExceptionReporter] (main) ERROR: relation "hibernate_sequence" does not exist
Position: 17
2012-04-07 08:11:05,388 ERROR [exo.kernel.container.ExoContainer] (main) Cannot create the portal container 'portal' . ServletContext: org.apache.catalina.core.ApplicationContextFacade@18879c56
org.picocontainer.PicoIntrospectionException: Failed when calling start on org.exoplatform.services.organization.idm.PicketLinkIDMServiceImpl@4cb48371
at org.exoplatform.container.LifecycleVisitor.traverse(LifecycleVisitor.java:136)
at org.exoplatform.container.LifecycleVisitor.start(LifecycleVisitor.java:170)
at org.exoplatform.container.ConcurrentPicoContainer.start(ConcurrentPicoContainer.java:552)
at org.exoplatform.container.ExoContainer.start(ExoContainer.java:266)
at org.exoplatform.container.PortalContainer.start(PortalContainer.java:667)
at org.exoplatform.container.ExoContainer.start(ExoContainer.java:254)
at org.exoplatform.container.RootContainer.createPortalContainer(RootContainer.java:399)
at org.exoplatform.container.RootContainer.createPortalContainers(RootContainer.java:287)
at org.exoplatform.container.web.PortalContainerCreator$2.run(PortalContainerCreator.java:74)
at org.exoplatform.container.web.PortalContainerCreator$2.run(PortalContainerCreator.java:71)
at org.exoplatform.commons.utils.SecurityHelper.doPrivilegedAction(SecurityHelper.java:289)
at org.exoplatform.container.web.PortalContainerCreator.contextInitialized(PortalContainerCreator.java:70)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3910)
.. .. ..
Caused by: java.lang.RuntimeException: org.picketlink.idm.common.exception.IdentityConfigurationException: Failed to build IdentitySessionFactory
at org.exoplatform.services.organization.idm.PicketLinkIDMServiceImpl.start(PicketLinkIDMServiceImpl.java:258)
at sun.reflect.GeneratedMethodAccessor375.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:597)
at org.exoplatform.container.LifecycleVisitor.traverse(LifecycleVisitor.java:100)
... 80 more
Caused by: org.picketlink.idm.common.exception.IdentityConfigurationException: Failed to build IdentitySessionFactory
at org.picketlink.idm.impl.configuration.IdentityConfigurationImpl.buildIdentitySessionFactory(IdentityConfigurationImpl.java:151)
at org.exoplatform.services.organization.idm.PicketLinkIDMServiceImpl.start(PicketLinkIDMServiceImpl.java:254)
... 84 more
Caused by: org.picketlink.idm.common.exception.IdentityException: Failed to populate relationship types
at org.picketlink.idm.impl.store.hibernate.HibernateIdentityStoreImpl.bootstrap(HibernateIdentityStoreImpl.java:239)
at org.picketlink.idm.impl.configuration.IdentityConfigurationImpl.createRealmMap(IdentityConfigurationImpl.java:192)
at org.picketlink.idm.impl.configuration.IdentityConfigurationImpl.buildIdentitySessionFactory(IdentityConfigurationImpl.java:147)
... 85 more
Caused by: org.hibernate.exception.SQLGrammarException: could not get next sequence value
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:90)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:66)
at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:119)
at org.hibernate.event.def.AbstractSaveEventListener.saveWithGeneratedId(AbstractSaveEventListener.java:121)
at org.hibernate.event.def.DefaultPersistEventListener.entityIsTransient(DefaultPersistEventListener.java:154)
at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:110)
at org.hibernate.event.def.DefaultPersistEventListener.onPersist(DefaultPersistEventListener.java:61)
at org.hibernate.impl.SessionImpl.firePersist(SessionImpl.java:648)
at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:622)
at org.hibernate.impl.SessionImpl.persist(SessionImpl.java:626)
at org.picketlink.idm.impl.store.hibernate.HibernateIdentityStoreImpl.populateRelationshipTypes(HibernateIdentityStoreImpl.java:2947)
at org.picketlink.idm.impl.store.hibernate.HibernateIdentityStoreImpl.bootstrap(HibernateIdentityStoreImpl.java:230)
... 87 more
Environment
- JBoss Enterprise Portal Platform (EPP) 5.2.0
- Postgres Driver: postgresql-9.1-901.jdbc4.jar
- PostgreSQL 9.0.7 & 9.1.3
- Site Publisher (SP) + ecm demo
Subscriber exclusive content
A Red Hat subscription provides unlimited access to our knowledgebase of over 48,000 articles and solutions.
Welcome! Check out the Getting Started with Red Hat page for quick tours and guides for common tasks.
