Problems upgrading Identity Portal 1.6.1 to 1.6.2
search cancel

Problems upgrading Identity Portal 1.6.1 to 1.6.2


Article ID: 6759


Updated On:


CA Identity Manager CA Identity Governance CA Identity Portal CA Risk Analytics CA Secure Cloud SaaS - Arcot A-OK (WebFort) CLOUDMINDER ADVANCED AUTHENTICATION CA Secure Cloud SaaS - Advanced Authentication CA Secure Cloud SaaS - Identity Management CA Secure Cloud SaaS - Single Sign On


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



Release: CAIDMB99000-12.6.8-Identity Manager-B to B


Improper settings in the "classpath:sigma-persistence-mssql.xml"


When I installed the Portal on our QA, it set the value of the "sigma.persistance.xml.location" in the JBoss system properties to "classpath:sigma-persistence-mssql.xml" That makes sense, since we are using MS SQL doe our database. 


However, that was NOT the value in our Dev. It was just "classpath:sigma-persistence.xml" (I think I'd put that in there manually when first trying out the upgrade). So, I changed value to the less specific file and that seems to work - I was able to use Identity Portal as expected. So the nonMSSQL file works better while the specific file does not.