Exception - Cannot create the portal container 'portal' on first start of EPP 5 with Oracle

Solution Verified - Updated -

Issue

We configured EPP 5 with an Oracle data source.  Starting the server for the first time fails with the following exception, which is ultimately caused by a missing db sequence:

ERROR [RootContainer] Cannot create the portal container 'portal' . ServletContext: org.apache.catalina.core.ApplicationContextFacade@879
d38
org.picocontainer.PicoIntrospectionException: Failed when calling start on org.exoplatform.services.organization.idm.PicketLinkIDMServiceImpl@50bc82
        at org.picocontainer.defaults.LifecycleVisitor.traverse(LifecycleVisitor.java:81)
        ... 85 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:238)
        at org.picketlink.idm.impl.configuration.IdentityConfigurationImpl.createRealmMap(IdentityConfigurationImpl.java:192)
        at org.picketlink.idm.impl.configuration.IdentityConfigurationImpl.buildIdentitySessionFactory(IdentityConfigurationImpl.java:147)
        ... 86 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.picketlink.idm.impl.store.hibernate.HibernateIdentityStoreImpl.populateRelationshipTypes(HibernateIdentityStoreImpl.java:2721)
        at org.picketlink.idm.impl.store.hibernate.HibernateIdentityStoreImpl.bootstrap(HibernateIdentityStoreImpl.java:229)
        ... 88 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-02289: sequence does not exist

        at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:91)
        at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:133)
        at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:206)
        at org.hibernate.id.SequenceGenerator.generate(SequenceGenerator.java:98)
        ... 97 more

Environment

  • JBoss Enterprise Portal Platform (EPP)
    • 5.0
    • 5.1
    • 5.2

Subscriber exclusive content

A Red Hat subscription provides unlimited access to our knowledgebase, tools, and much more.

Current Customers and Partners

Log in for full access

Log In

New to Red Hat?

Learn more about Red Hat subscriptions

Using a Red Hat product through a public cloud?

How to access this content