Identity Portal Installation with Oracle 12c fails

Document ID : KB000006865
Last Modified Date : 14/02/2018
Show Technical Document Details
Issue:

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.

Cause:

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.

Resolution:

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.