We are attempting to upgrade our Identity Portal from 1.6.1 to 1.6.2. We follow some of the steps in the 12.6.8 upgrade guide to 'migrate' the database over to 1.6.2. This worked in my Dev environment. When I attempted the same process in my QA environment, it failed spectacularly. The sigma.war file fails to deploy. I've tried several different variations with the environment, with no success. As far as I know, the big difference between our Dev and QA systems is that our QA is set up with High Availability (unicast, not multicast).
The error in the logs when trying to deploy the Ear file is:
17:06:10,095 INFO [stdout] (ServerService Thread Pool -- 3) [SIGMA APPENDER - FROM WEB] 2017-05-05 17:06:10,095 - WARN org.hibernate.engine.jdbc.spi.SqlExceptionHelper - SQL Error: 544, SQLState: S0001
17:06:10,095 INFO [stdout] (ServerService Thread Pool -- 3) [SIGMA APPENDER - FROM WEB] 2017-05-05 17:06:10,095 - ERROR org.hibernate.engine.jdbc.spi.SqlExceptionHelper - Cannot insert explicit value for identity column in table 'Configuration' when IDENTITY_INSERT is set to OFF.
17:06:10,095 INFO [stdout] (ServerService Thread Pool -- 3) [SIGMA APPENDER - FROM WEB] 2017-05-05 17:06:10,095 - INFO org.hibernate.engine.jdbc.batch.internal.AbstractBatchImpl - HHH000010: On release of batch it still contained JDBC statements
17:06:10,095 WARN [com.arjuna.ats.arjuna] (ServerService Thread Pool -- 3) ARJUNA012125: TwoPhaseCoordinator.beforeCompletion - failed for SynchronizationImple< 0:ffff0a29fc5a:53e1e0b7:590d1343:15, org.hibernate.resource.transaction.backend.jta.internal.synchronization.RegisteredSynchronization@76d4f569 >: javax.persistence.PersistenceException: org.hibernate.exception.SQLGrammarException: could not execute statement