Data Access Error when going to the OC Inventory and Groups are not displayed after upgrade to UIM 20.3.3

book

Article ID: 222762

calendar_today

Updated On:

Products

DX Infrastructure Management

Issue/Introduction

Data Access Error when going to the OC Inventory and Groups are not displayed after upgrade to UIM 20.3.3

and policy_mangmanet queue is yellow and not attached.


2021-07-15 19:25:05,923 WARN  org.springframework.context.support.AbstractApplicationContext:refresh:550 [Catalina-utility-1]   - Exception encountered during context initialization - cancelling refresh attempt: org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'mcsEventListener': Unsatisfied dependency expressed through field 'mcsEventService'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'mcsEventService': Unsatisfied dependency expressed through field 'policyService'; nested exception is org.springframework.beans.factory.UnsatisfiedDependencyException: Error creating bean with name 'policyService': Unsatisfied dependency expressed through field 'policyRepository'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'policyRepository': Cannot create inner bean '(inner bean)#3ecec146' of type [org.springframework.orm.jpa.SharedEntityManagerCreator] while setting bean property 'entityManager'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name '(inner bean)#3ecec146': Cannot resolve reference to bean 'entityManagerFactory' while setting constructor argument; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'entityManagerFactory' defined in class path resource [com/ca/uim/policy/management/config/DatabaseConfig.class]: Bean instantiation via factory method failed; nested exception is org.springframework.beans.BeanInstantiationException: Failed to instantiate [javax.persistence.EntityManagerFactory]: Factory method 'entityManagerFactory' threw exception; nested exception is javax.persistence.PersistenceException: [PersistenceUnit: default] Unable to build Hibernate SessionFactory; nested exception is org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: missing sequence [UIMNORAADM.hibernate_sequence]

Cause

missing sequence UIMNORAADM.hibernate_sequence possibly due to corruption during the upgrade.

Environment

Release : 20.3

Component : UIM - INSTALL

Resolution

The issue has been resolved after we manually run sql to create the sequence on the DB

CREATE SEQUENCE UIMNORAADM.hibernate_sequence
 START WITH     1
 INCREMENT BY   1
 NOCACHE
 NOCYCLE;