Error instalation from dsapce 4.0 to 6.0

23 views
Skip to first unread message

christian criollo

unread,
Mar 8, 2017, 11:29:24 AM3/8/17
to DSpace Technical Support

Hi all

I have many problems to install dspace 6.0 I have followed all step to upgrade when restart tomcat server the aplication not working I check the tomcat logs and I found this:

2017-03-08 11:06:23,014 INFO  org.dspace.storage.rdbms.DatabaseUtils @ Loading Flyway DB migrations from: filesystem:/home/dspace/bibdigital/etc/oracle, classpath:org.dspace.storage.rdbms.sqlmigration.oracle, classpath:org.dspace.storage.rdbms.migration
2017-03-08 11:06:23,237 INFO  org.flywaydb.core.internal.util.VersionPrinter @ Flyway 4.0.3 by Boxfuse
2017-03-08 11:06:23,284 INFO  org.flywaydb.core.internal.dbsupport.DbSupportFactory @ Database: jdbc:oracle:thin:@192.168.220.120:1521:wicesin (Oracle 11.2)
2017-03-08 11:06:23,399 INFO  org.dspace.storage.rdbms.DatabaseUtils @ Pending DSpace database schema migrations:
2017-03-08 11:06:23,399 INFO  org.dspace.storage.rdbms.DatabaseUtils @     5.6.2016.08.23 DS-3097 SQL PENDING
2017-03-08 11:06:23,399 INFO  org.dspace.storage.rdbms.DatabaseUtils @     6.0.2015.03.06 DS 2701 Dso Uuid Migration JDBC PENDING
2017-03-08 11:06:23,399 INFO  org.dspace.storage.rdbms.DatabaseUtils @     6.0.2015.03.07 DS-2701 Hibernate migration SQL PENDING
2017-03-08 11:06:23,399 INFO  org.dspace.storage.rdbms.DatabaseUtils @     6.0.2015.08.31 DS 2701 Hibernate Workflow Migration JDBC PENDING
2017-03-08 11:06:23,400 INFO  org.dspace.storage.rdbms.DatabaseUtils @     6.0.2016.01.03 DS-3024 SQL PENDING
2017-03-08 11:06:23,400 INFO  org.dspace.storage.rdbms.DatabaseUtils @     6.0.2016.01.26 DS 2188 Remove DBMS Browse Tables JDBC PENDING
2017-03-08 11:06:23,400 INFO  org.dspace.storage.rdbms.DatabaseUtils @     6.0.2016.02.25 DS-3004-slow-searching-as-admin SQL PENDING
2017-03-08 11:06:23,400 INFO  org.dspace.storage.rdbms.DatabaseUtils @     6.0.2016.04.01 DS-1955 Increase embargo reason SQL PENDING
2017-03-08 11:06:23,400 INFO  org.dspace.storage.rdbms.DatabaseUtils @     6.0.2016.04.04 DS-3086-OAI-Performance-fix SQL PENDING
2017-03-08 11:06:23,400 INFO  org.dspace.storage.rdbms.DatabaseUtils @     6.0.2016.04.14 DS-3125-fix-bundle-bitstream-delete-rights SQL PENDING
2017-03-08 11:06:23,400 INFO  org.dspace.storage.rdbms.DatabaseUtils @     6.0.2016.05.10 DS-3168-fix-requestitem item id column SQL PENDING
2017-03-08 11:06:23,400 INFO  org.dspace.storage.rdbms.DatabaseUtils @     6.0.2016.07.21 DS-2775 SQL PENDING
2017-03-08 11:06:23,401 INFO  org.dspace.storage.rdbms.DatabaseUtils @     6.0.2016.07.26 DS-3277 fix handle assignment SQL PENDING
2017-03-08 11:06:23,401 INFO  org.dspace.storage.rdbms.DatabaseUtils @     6.0.2016.08.23 DS-3097 SQL PENDING
2017-03-08 11:06:23,448 INFO  org.flywaydb.core.internal.command.DbValidate @ Successfully validated 30 migrations (execution time 00:00.028s)
2017-03-08 11:06:23,476 INFO  org.flywaydb.core.internal.command.DbMigrate @ Current version of schema "BIBDIGITALMIGR": 5.0.2014.09.26
2017-03-08 11:06:23,478 FATAL org.dspace.core.Context @ Cannot initialize database via Flyway!
java.sql.SQLException: Flyway migration error occurred
    at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:666)
    at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:574)
    at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:550)
    at org.dspace.core.Context.<clinit>(Context.java:94)
    at org.dspace.app.util.AbstractDSpaceWebapp.register(AbstractDSpaceWebapp.java:74)
    at org.dspace.app.util.DSpaceWebappListener.contextInitialized(DSpaceWebappListener.java:31)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4961)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5455)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:634)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1230)
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1876)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:744)
Caused by: org.flywaydb.core.api.FlywayException: Schema "BIBDIGITALMIGR" contains a failed migration to version 5.0.2014.09.26 !
    at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:218)
    at org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigrate.java:173)
    at org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(TransactionTemplate.java:72)
    at org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:173)
    at org.flywaydb.core.Flyway$1.execute(Flyway.java:959)
    at org.flywaydb.core.Flyway$1.execute(Flyway.java:917)
    at org.flywaydb.core.Flyway.execute(Flyway.java:1373)
    at org.flywaydb.core.Flyway.migrate(Flyway.java:917)
    at org.dspace.storage.rdbms.DatabaseUtils.updateDatabase(DatabaseUtils.java:655)
    ... 18 more



The source of the configuration was net.sf.ehcache.config.generator.ConfigurationSource$DefaultConfigurationSource@49243997.
The diskStore path for this CacheManager will be set to /home/jakarta/tomcat/temp/ehcache_auto_created_1488989160828.
To avoid this warning consider using the CacheManager factory methods to create a singleton CacheManager or specifying a separate ehcache configuration (ehcache.xml) for each CacheManager instance.
2017-03-08 11:06:00,831 INFO  org.hibernate.cache.spi.UpdateTimestampsCache @ HHH000250: Starting update timestamps cache at region: org.hibernate.cache.spi.UpdateTimestampsCache
2017-03-08 11:06:00,835 WARN  org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory @ HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.spi.UpdateTimestampsCache]; using defaults.
2017-03-08 11:06:00,885 INFO  org.hibernate.cache.internal.StandardQueryCache @ HHH000248: Starting query cache at region: org.hibernate.cache.internal.StandardQueryCache
2017-03-08 11:06:00,886 WARN  org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory @ HHH020003: Could not find a specific ehcache configuration for cache named [org.hibernate.cache.internal.StandardQueryCache]; using defaults.
2017-03-08 11:06:00,940 INFO  org.hibernate.validator.internal.util.Version @ HV000001: Hibernate Validator 5.1.2.Final
2017-03-08 11:06:01,649 WARN  org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory @ HHH020003: Could not find a specific ehcache configuration for cache named [org.dspace.content.MetadataSchema]; using defaults.
2017-03-08 11:06:01,668 WARN  org.hibernate.cache.ehcache.AbstractEhcacheRegionFactory @ HHH020003: Could not find a specific ehcache configuration for cache named [org.dspace.content.MetadataField]; using defaults.
2017-03-08 11:06:01,843 INFO  org.hibernate.tool.hbm2ddl.SchemaValidator @ HHH000229: Running schema validator
2017-03-08 11:06:01,844 INFO  org.hibernate.tool.hbm2ddl.SchemaValidator @ HHH000102: Fetching database metadata
2017-03-08 11:06:01,849 ERROR org.hibernate.tool.hbm2ddl.SchemaValidator @ HHH000319: Could not get database metadata
java.sql.SQLSyntaxErrorException: ORA-00942: la tabla o vista no existe

    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:445)
    at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396)
    at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:879)
    at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:450)
    at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:192)
    at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:531)
    at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:193)
    at oracle.jdbc.driver.T4CStatement.executeForDescribe(T4CStatement.java:873)
    at oracle.jdbc.driver.OracleStatement.executeMaybeDescribe(OracleStatement.java:1167)
    at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1289)
    at oracle.jdbc.driver.OracleStatement.executeQuery(OracleStatement.java:1491)
    at oracle.jdbc.driver.OracleStatementWrapper.executeQuery(OracleStatementWrapper.java:406)
    at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)
    at org.apache.commons.dbcp2.DelegatingStatement.executeQuery(DelegatingStatement.java:207)
    at org.hibernate.tool.hbm2ddl.DatabaseMetadata.initSequences(DatabaseMetadata.java:177)
    at org.hibernate.tool.hbm2ddl.DatabaseMetadata.<init>(DatabaseMetadata.java:91)
    at org.hibernate.tool.hbm2ddl.SchemaValidator.validate(SchemaValidator.java:168)
    at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:512)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1799)
    at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1870)
    at org.springframework.orm.hibernate4.LocalSessionFactoryBuilder.buildSessionFactory(LocalSessionFactoryBuilder.java:252)
    at org.springframework.orm.hibernate4.LocalSessionFactoryBean.buildSessionFactory(LocalSessionFactoryBean.java:377)
    at org.springframework.orm.hibernate4.LocalSessionFactoryBean.afterPropertiesSet(LocalSessionFactoryBean.java:362)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.invokeInitMethods(AbstractAutowireCapableBeanFactory.java:1573)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.initializeBean(AbstractAutowireCapableBeanFactory.java:1511)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:521)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:191)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.findAutowireCandidates(DefaultListableBeanFactory.java:921)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.doResolveDependency(DefaultListableBeanFactory.java:864)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.resolveDependency(DefaultListableBeanFactory.java:779)
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor$AutowiredFieldElement.inject(AutowiredAnnotationBeanPostProcessor.java:503)
    at org.springframework.beans.factory.annotation.InjectionMetadata.inject(InjectionMetadata.java:88)
    at org.springframework.beans.factory.annotation.AutowiredAnnotationBeanPostProcessor.postProcessPropertyValues(AutowiredAnnotationBeanPostProcessor.java:295)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1148)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:519)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:458)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:293)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:223)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:290)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)
    at org.springframework.context.support.AbstractApplicationContext.getBean(AbstractApplicationContext.java:1127)
    at org.dspace.servicemanager.spring.SpringServiceManager.getServiceByName(SpringServiceManager.java:103)
    at org.dspace.servicemanager.DSpaceServiceManager.getServiceByName(DSpaceServiceManager.java:284)
    at org.dspace.utils.DSpace.getSingletonService(DSpace.java:87)
    at org.dspace.core.Context.init(Context.java:145)
    at org.dspace.core.Context.<init>(Context.java:115)
    at org.dspace.app.util.AbstractDSpaceWebapp.register(AbstractDSpaceWebapp.java:74)
    at org.dspace.app.util.DSpaceWebappListener.contextInitialized(DSpaceWebappListener.java:31)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4961)
    at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5455)
    at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:901)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:877)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:634)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1230)
    at org.apache.catalina.startup.HostConfig$DeployDirectory.run(HostConfig.java:1876)
    at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:471)
    at java.util.concurrent.FutureTask.run(FutureTask.java:262)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
    at java.lang.Thread.run(Thread.java:744)
2017-03-08 11:06:01,850 ERROR org.hibernate.tool.hbm2ddl.SchemaValidator @ HHH000300: Could not complete schema validation
java.sql.SQLSyntaxErrorException: ORA-00942: la tabla o vista no existe


thank you for the help
Reply all
Reply to author
Forward
0 new messages