Hello, Is the 'pgcrypto' extension enabled in the database? What is your PostgreSQL version? You can check it by invoking '[dspace]/bin/dspace database info'. In your console output, there should be a line that reads:
*PostgreSQL 'pgcrypto' extension installed/up-to-date? true (version=1.3)* poniedziałek, 13 marca 2023 o 15:18:44 UTC+1 Akanksha Agrawal napisał(a): > Dear sir, > > I am installing dspace 7.2 in new server with PostgreSQL as backend > database. Previous dspace version is 5.2 with oracle as backend database. > Installation of Dspace 7.2 completed successfully. > After oracle to PostgreSQL data migration it > * [dspace]/bin/dspace database migrate* > returns > > > * Database URL: jdbc:postgresql://localhost:5432/dspaceMigrating > database to latest version... (Check dspace logs for details)Done.* > > *After that on starting tomcat getting the error* > Caused by: org.springframework.beans.factory.BeanCreationException: Error > creating bean with name 'sessionFactory' defined in file > [/opt/dspace/config/spring/api/core-hibernate.xml]: Invocation of init > method failed; nested exception is > org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: > missing column [uuid] in table [public.bitstream] > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1796) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:595) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:517) > at > org.springframework.beans.factory.support.AbstractBeanFactory.lambda$doGetBean$0(AbstractBeanFactory.java:323) > at > org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:222) > at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:321) > at > org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:276) > at > org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:202) > at > org.springframework.data.rest.webmvc.support.JpaHelper.setBeanFactory(JpaHelper.java:27) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeAwareMethods(AbstractAutowireCapableBeanFactory.java:1818) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1783) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:595) > ... 167 more > Caused by: > org.hibernate.tool.schema.spi.SchemaManagementException: Schema-validation: > missing column [uuid] in table [public.bitstream] > at > org.hibernate.tool.schema.internal.AbstractSchemaValidator.validateTable(AbstractSchemaValidator.java:136) > at > org.hibernate.tool.schema.internal.GroupedSchemaValidatorImpl.validateTables(GroupedSchemaValidatorImpl.java:42) > at > org.hibernate.tool.schema.internal.AbstractSchemaValidator.performValidation(AbstractSchemaValidator.java:89) > at > org.hibernate.tool.schema.internal.AbstractSchemaValidator.doValidation(AbstractSchemaValidator.java:68) > at > org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:192) > at > org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:73) > at > org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:320) > at > org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:462) > at > org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:708) > at > org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:724) > at > org.springframework.orm.hibernate5.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:616) > at > org.springframework.orm.hibernate5.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:600) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1855) > at > org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1792) > ... 178 more > > -- All messages to this mailing list should adhere to the Code of Conduct: https://www.lyrasis.org/about/Pages/Code-of-Conduct.aspx --- You received this message because you are subscribed to the Google Groups "DSpace Technical Support" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To view this discussion on the web visit https://groups.google.com/d/msgid/dspace-tech/92cc46fe-2022-4108-92f7-a18e3d7213d0n%40googlegroups.com.
