Symantec Identity Management

Expand all | Collapse all

Identity Portal installation failed

  • 1.  Identity Portal installation failed

    Posted 11-28-2018 06:14 AM

    Hi All,

     

    I am trying to install Identity Portal, I have run through all prerequisite steps without any failure

    IP installation fails at the end, I have tried to install it manually after that but still same set of errors

    Following are some environment information:

    1)Windows server 2012R2

    2)DVD500000000000164.iso-IP windows 14.1

    3)MS SQL Server - Microsoft SQL Server Express (64-bit)-11.0.2100.60

    4)SQLJDBC4.jar

    5)Wildfly8.2.1-App server

    6)JDK-1.8.0_171

    As per support matrix MSSQL 2012 SP2 is supported , I have SQL server 2012 RTM(11.0.2100) installed , Is the issue because of sqlserver version difference. database connection part in installation went well, there were no errors while connecting to database

    Microsoft SQL2012 SP2
    • Not supported when CA Identity Portal is running on WebLogic
    • Use with sqljdbc4.jar jdbc driver

    Below are the errors from server.log

    2018-11-28 02:44:20,524 ERROR [org.springframework.web.context.ContextLoader] (MSC service thread 1-1) Context initialization failed: java.lang.RuntimeException: Upgrade failed - stop the application
    at com.idmlogic.sigma.manager.impl.StartupManagerBean.upgrade(StartupManagerBean.java:205) [sigma.bl-0.0.2-SNAPSHOT.jar:]
    at com.idmlogic.sigma.manager.impl.StartupManagerBean.startup(StartupManagerBean.java:93) [sigma.bl-0.0.2-SNAPSHOT.jar:]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_171]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_171]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_171]
    at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_171]
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:115) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at com.sun.proxy.$Proxy527.startup(Unknown Source)
    at com.idmlogic.sigma.web.util.SigmaLoadListener.onApplicationEvent(SigmaLoadListener.java:23) [classes:]
    at com.idmlogic.sigma.web.util.SigmaLoadListener.onApplicationEvent(SigmaLoadListener.java:10) [classes:]
    at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:166) [spring-context-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:138) [spring-context-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:382) [spring-context-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:336) [spring-context-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:859) [spring-context-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:544) [spring-context-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444) [spring-web-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326) [spring-web-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107) [spring-web-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at io.undertow.servlet.core.ApplicationListeners.contextInitialized(ApplicationListeners.java:173) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
    at io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:194) [undertow-servlet-1.1.8.Final.jar:1.1.8.Final]
    at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:87)
    at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.start(UndertowDeploymentService.java:72)
    at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1948)
    at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1881)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_171]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [rt.jar:1.8.0_171]
    at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_171]
    Caused by: javax.persistence.OptimisticLockException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.wrapStaleStateException(AbstractEntityManagerImpl.java:1729) [hibernate-entitymanager-5.0.3.Final.jar:5.0.3.Final]
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1634) [hibernate-entitymanager-5.0.3.Final.jar:5.0.3.Final]
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602) [hibernate-entitymanager-5.0.3.Final.jar:5.0.3.Final]
    at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:445) [hibernate-entitymanager-5.0.3.Final.jar:5.0.3.Final]
    at com.idmlogic.sigma.dao.impl.BaseDaoImpl.getAllFromCache(BaseDaoImpl.java:330) [sigma.bl-0.0.2-SNAPSHOT.jar:]
    at com.idmlogic.sigma.dao.impl.BaseDaoImpl.getAll(BaseDaoImpl.java:188) [sigma.bl-0.0.2-SNAPSHOT.jar:]
    at com.idmlogic.sigma.dao.impl.ConfigurationDaoImpl.getAll(ConfigurationDaoImpl.java:8) [sigma.bl-0.0.2-SNAPSHOT.jar:]
    at sun.reflect.GeneratedMethodAccessor306.invoke(Unknown Source) [:1.8.0_171]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_171]
    at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_171]
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) [spring-tx-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281) [spring-tx-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) [spring-tx-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at com.sun.proxy.$Proxy378.getAll(Unknown Source)
    at com.idmlogic.sigma.manager.impl.ConfigurationManagerBean.getAll(ConfigurationManagerBean.java:79) [sigma.bl-0.0.2-SNAPSHOT.jar:]
    at com.idmlogic.sigma.manager.impl.ConfigurationManagerBean.get(ConfigurationManagerBean.java:94) [sigma.bl-0.0.2-SNAPSHOT.jar:]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_171]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_171]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_171]
    at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_171]
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:115) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at com.sun.proxy.$Proxy381.get(Unknown Source)
    at com.idmlogic.sigma.manager.impl.AttachmentManagerBean.updateMaxUploadSize(AttachmentManagerBean.java:92) [sigma.bl-0.0.2-SNAPSHOT.jar:]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_171]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_171]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_171]
    at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_171]
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:115) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at com.sun.proxy.$Proxy387.updateMaxUploadSize(Unknown Source)
    at com.idmlogic.sigma.manager.impl.ConfigurationManagerBean.updateConfiguration(ConfigurationManagerBean.java:143) [sigma.bl-0.0.2-SNAPSHOT.jar:]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_171]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_171]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_171]
    at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_171]
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:115) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at com.sun.proxy.$Proxy381.updateConfiguration(Unknown Source)
    at com.idmlogic.sigma.manager.impl.UpgradeManagerBean.createLandingPageModule(UpgradeManagerBean.java:3554) [sigma.bl-0.0.2-SNAPSHOT.jar:]
    at com.idmlogic.sigma.manager.impl.UpgradeManagerBean.upgradeVersionV14(UpgradeManagerBean.java:1275) [sigma.bl-0.0.2-SNAPSHOT.jar:]
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_171]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_171]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_171]
    at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_171]
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99) [spring-tx-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281) [spring-tx-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96) [spring-tx-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:115) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208) [spring-aop-4.2.9.RELEASE.jar:4.2.9.RELEASE]
    at com.sun.proxy.$Proxy441.upgradeVersionV14(Unknown Source)
    at com.idmlogic.sigma.manager.impl.StartupManagerBean.upgrade(StartupManagerBean.java:188) [sigma.bl-0.0.2-SNAPSHOT.jar:]
    ... 34 more
    Caused by: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
    at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:67) [hibernate-core-5.0.3.Final.jar:5.0.3.Final]
    at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:54) [hibernate-core-5.0.3.Final.jar:5.0.3.Final]
    at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:46) [hibernate-core-5.0.3.Final.jar:5.0.3.Final]
    at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3069) [hibernate-core-5.0.3.Final.jar:5.0.3.Final]
    at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2948) [hibernate-core-5.0.3.Final.jar:5.0.3.Final]
    at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3328) [hibernate-core-5.0.3.Final.jar:5.0.3.Final]
    at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:145) [hibernate-core-5.0.3.Final.jar:5.0.3.Final]
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:451) [hibernate-core-5.0.3.Final.jar:5.0.3.Final]
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:336) [hibernate-core-5.0.3.Final.jar:5.0.3.Final]
    at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:335) [hibernate-core-5.0.3.Final.jar:5.0.3.Final]
    at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:50) [hibernate-core-5.0.3.Final.jar:5.0.3.Final]
    at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1193) [hibernate-core-5.0.3.Final.jar:5.0.3.Final]
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1261) [hibernate-core-5.0.3.Final.jar:5.0.3.Final]
    at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87) [hibernate-core-5.0.3.Final.jar:5.0.3.Final]
    at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:567) [hibernate-entitymanager-5.0.3.Final.jar:5.0.3.Final]
    at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:436) [hibernate-entitymanager-5.0.3.Final.jar:5.0.3.Final]
    ... 112 more

    2018-11-28 02:44:20,555 ERROR [org.jboss.msc.service.fail] (MSC service thread 1-1) MSC000001: Failed to start service jboss.undertow.deployment.default-server.default-host./sigma: org.jboss.msc.service.StartException in service jboss.undertow.deployment.default-server.default-host./sigma: Failed to start service
    at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1904) [jboss-msc-1.2.2.Final.jar:1.2.2.Final]
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [rt.jar:1.8.0_171]
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [rt.jar:1.8.0_171]
    at java.lang.Thread.run(Thread.java:748) [rt.jar:1.8.0_171]
    Caused by: java.lang.RuntimeException: java.lang.RuntimeException: Upgrade failed - stop the application
    at io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:223)
    at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:87)
    at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.start(UndertowDeploymentService.java:72)
    at org.jboss.msc.service.ServiceControllerImpl$StartTask.startService(ServiceControllerImpl.java:1948) [jboss-msc-1.2.2.Final.jar:1.2.2.Final]
    at org.jboss.msc.service.ServiceControllerImpl$StartTask.run(ServiceControllerImpl.java:1881) [jboss-msc-1.2.2.Final.jar:1.2.2.Final]
    ... 3 more
    Caused by: java.lang.RuntimeException: Upgrade failed - stop the application
    at com.idmlogic.sigma.manager.impl.StartupManagerBean.upgrade(StartupManagerBean.java:205)
    at com.idmlogic.sigma.manager.impl.StartupManagerBean.startup(StartupManagerBean.java:93)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_171]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_171]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_171]
    at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_171]
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:115)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
    at com.sun.proxy.$Proxy527.startup(Unknown Source)
    at com.idmlogic.sigma.web.util.SigmaLoadListener.onApplicationEvent(SigmaLoadListener.java:23)
    at com.idmlogic.sigma.web.util.SigmaLoadListener.onApplicationEvent(SigmaLoadListener.java:10)
    at org.springframework.context.event.SimpleApplicationEventMulticaster.invokeListener(SimpleApplicationEventMulticaster.java:166)
    at org.springframework.context.event.SimpleApplicationEventMulticaster.multicastEvent(SimpleApplicationEventMulticaster.java:138)
    at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:382)
    at org.springframework.context.support.AbstractApplicationContext.publishEvent(AbstractApplicationContext.java:336)
    at org.springframework.context.support.AbstractApplicationContext.finishRefresh(AbstractApplicationContext.java:859)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:544)
    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:444)
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:326)
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:107)
    at io.undertow.servlet.core.ApplicationListeners.contextInitialized(ApplicationListeners.java:173)
    at io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:194)
    ... 7 more
    Caused by: javax.persistence.OptimisticLockException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.wrapStaleStateException(AbstractEntityManagerImpl.java:1729)
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1634)
    at org.hibernate.jpa.spi.AbstractEntityManagerImpl.convert(AbstractEntityManagerImpl.java:1602)
    at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:445)
    at com.idmlogic.sigma.dao.impl.BaseDaoImpl.getAllFromCache(BaseDaoImpl.java:330)
    at com.idmlogic.sigma.dao.impl.BaseDaoImpl.getAll(BaseDaoImpl.java:188)
    at com.idmlogic.sigma.dao.impl.ConfigurationDaoImpl.getAll(ConfigurationDaoImpl.java:8)
    at sun.reflect.GeneratedMethodAccessor306.invoke(Unknown Source) [:1.8.0_171]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_171]
    at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_171]
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
    at com.sun.proxy.$Proxy378.getAll(Unknown Source)
    at com.idmlogic.sigma.manager.impl.ConfigurationManagerBean.getAll(ConfigurationManagerBean.java:79)
    at com.idmlogic.sigma.manager.impl.ConfigurationManagerBean.get(ConfigurationManagerBean.java:94)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_171]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_171]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_171]
    at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_171]
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:115)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
    at com.sun.proxy.$Proxy381.get(Unknown Source)
    at com.idmlogic.sigma.manager.impl.AttachmentManagerBean.updateMaxUploadSize(AttachmentManagerBean.java:92)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_171]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_171]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_171]
    at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_171]
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:115)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
    at com.sun.proxy.$Proxy387.updateMaxUploadSize(Unknown Source)
    at com.idmlogic.sigma.manager.impl.ConfigurationManagerBean.updateConfiguration(ConfigurationManagerBean.java:143)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_171]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_171]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_171]
    at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_171]
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:115)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
    at com.sun.proxy.$Proxy381.updateConfiguration(Unknown Source)
    at com.idmlogic.sigma.manager.impl.UpgradeManagerBean.createLandingPageModule(UpgradeManagerBean.java:3554)
    at com.idmlogic.sigma.manager.impl.UpgradeManagerBean.upgradeVersionV14(UpgradeManagerBean.java:1275)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) [rt.jar:1.8.0_171]
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) [rt.jar:1.8.0_171]
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) [rt.jar:1.8.0_171]
    at java.lang.reflect.Method.invoke(Method.java:498) [rt.jar:1.8.0_171]
    at org.springframework.aop.support.AopUtils.invokeJoinpointUsingReflection(AopUtils.java:302)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.invokeJoinpoint(ReflectiveMethodInvocation.java:190)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:157)
    at org.springframework.transaction.interceptor.TransactionInterceptor$1.proceedWithInvocation(TransactionInterceptor.java:99)
    at org.springframework.transaction.interceptor.TransactionAspectSupport.invokeWithinTransaction(TransactionAspectSupport.java:281)
    at org.springframework.transaction.interceptor.TransactionInterceptor.invoke(TransactionInterceptor.java:96)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.interceptor.AbstractTraceInterceptor.invoke(AbstractTraceInterceptor.java:115)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.interceptor.ExposeInvocationInterceptor.invoke(ExposeInvocationInterceptor.java:92)
    at org.springframework.aop.framework.ReflectiveMethodInvocation.proceed(ReflectiveMethodInvocation.java:179)
    at org.springframework.aop.framework.JdkDynamicAopProxy.invoke(JdkDynamicAopProxy.java:208)
    at com.sun.proxy.$Proxy441.upgradeVersionV14(Unknown Source)
    at com.idmlogic.sigma.manager.impl.StartupManagerBean.upgrade(StartupManagerBean.java:188)
    ... 34 more
    Caused by: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
    at org.hibernate.jdbc.Expectations$BasicExpectation.checkBatched(Expectations.java:67)
    at org.hibernate.jdbc.Expectations$BasicExpectation.verifyOutcome(Expectations.java:54)
    at org.hibernate.engine.jdbc.batch.internal.NonBatchingBatch.addToBatch(NonBatchingBatch.java:46)
    at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3069)
    at org.hibernate.persister.entity.AbstractEntityPersister.updateOrInsert(AbstractEntityPersister.java:2948)
    at org.hibernate.persister.entity.AbstractEntityPersister.update(AbstractEntityPersister.java:3328)
    at org.hibernate.action.internal.EntityUpdateAction.execute(EntityUpdateAction.java:145)
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:451)
    at org.hibernate.engine.spi.ActionQueue.executeActions(ActionQueue.java:336)
    at org.hibernate.event.internal.AbstractFlushingEventListener.performExecutions(AbstractFlushingEventListener.java:335)
    at org.hibernate.event.internal.DefaultAutoFlushEventListener.onAutoFlush(DefaultAutoFlushEventListener.java:50)
    at org.hibernate.internal.SessionImpl.autoFlushIfRequired(SessionImpl.java:1193)
    at org.hibernate.internal.SessionImpl.list(SessionImpl.java:1261)
    at org.hibernate.internal.QueryImpl.list(QueryImpl.java:87)
    at org.hibernate.jpa.internal.QueryImpl.list(QueryImpl.java:567)
    at org.hibernate.jpa.internal.QueryImpl.getResultList(QueryImpl.java:436)
    ... 112 more

    2018-11-28 02:44:20,586 ERROR [org.jboss.as.controller.management-operation] (XNIO-5 task-8) JBAS014613: Operation ("deploy") failed - address: ([("deployment" => "sigma.war")]) - failure description: {"JBAS014671: Failed services" => {"jboss.undertow.deployment.default-server.default-host./sigma" => "org.jboss.msc.service.StartException in service jboss.undertow.deployment.default-server.default-host./sigma: Failed to start service
    Caused by: java.lang.RuntimeException: java.lang.RuntimeException: Upgrade failed - stop the application
    Caused by: java.lang.RuntimeException: Upgrade failed - stop the application
    Caused by: javax.persistence.OptimisticLockException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
    Caused by: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1"}}
    2018-11-28 02:44:20,586 ERROR [org.jboss.as.server] (XNIO-5 task-8) JBAS015870: Deploy of deployment "sigma.war" was rolled back with the following failure message:
    {"JBAS014671: Failed services" => {"jboss.undertow.deployment.default-server.default-host./sigma" => "org.jboss.msc.service.StartException in service jboss.undertow.deployment.default-server.default-host./sigma: Failed to start service
    Caused by: java.lang.RuntimeException: java.lang.RuntimeException: Upgrade failed - stop the application
    Caused by: java.lang.RuntimeException: Upgrade failed - stop the application
    Caused by: javax.persistence.OptimisticLockException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1
    Caused by: org.hibernate.StaleStateException: Batch update returned unexpected row count from update [0]; actual row count: 0; expected: 1"}}
    2018-11-28 02:44:21,712 INFO [org.jboss.as.server.deployment] (MSC service thread 1-1) JBAS015877: Stopped deployment sigma.war (runtime-name: sigma.war) in 1119ms
    2018-11-28 02:44:21,872 INFO [org.jboss.as.controller] (XNIO-5 task-8) JBAS014774: Service status report
    JBAS014777: Services which failed to start: service jboss.undertow.deployment.default-server.default-host./sigma



  • 2.  Re: Identity Portal installation failed

    Posted 11-28-2018 09:15 AM

    I tried fresh installation with ms sqlserver 2012 sp2 , a supported version as per CA support matrix doc.

    Still the same set of errors. 



  • 3.  Re: Identity Portal installation failed

    Posted 12-09-2018 07:05 AM

    If you haven't already, please open a support case so we can investigate.