Identity Portal Installation with Oracle 12c fails
search cancel

Identity Portal Installation with Oracle 12c fails


Article ID: 6865


Updated On:


CA Identity Manager CA Identity Governance CA Identity Portal


Installing Identity Portal with JBoss/Wildfly and Oracle 12c fails with the error "Unable to build Hibernate SessionFactory".  The stack trace of the error in the log shows it is caused by "org.hibernate.tool.schema.extract.spi.SchemaExtractionException: More than one table found in namespace (, )" followed by the duplicate table name.


Component: SIGMA


The user configured for the database is configured with incorrect permissions.  It has DBA permission instead of just CONNECT and RESOURCE as specified in the CA Identity Suite documentation.  Having DBA allows the user to see all tables.  This causes the query used to update the schema during installation to fail since it expects to have only one table by a specified name.


Ensure that a dedicated schema has been created for CA Identity Portal, and assign only the CONNECT and RESOURCE DB Roles to the schema user, then re-run the installation.