Hi!. I get this error while running database migrate....
Migration schema 1,6,2 to 6.0 database
Somenone gets by ?
Thanks
-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------
SQL State : 42000
Error Code : 904
Message : ORA-00904: "ITEM_ID": identificador inválido
Location :
org/dspace/storage/rdbms/sqlmigration/oracle/V5.0_2014.09.26__DS-15
82_Metadata_For_All_Objects.sql
(d:\dspace\dspace\file:\D:\dspace\dspace\lib\dsp
ace-api-6.0.jar!\org\dspace\storage\rdbms\sqlmigration\oracle\V5.0_2014.09.26__D
S-1582_Metadata_For_All_Objects.sql)
Line : 23
Statement : alter table metadatavalue rename column item_id to resource_id
at
org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java
:117)
at
org.flywaydb.core.internal.resolver.sql.SqlMigrationExecutor.execute(
SqlMigrationExecutor.java:71)
at
org.flywaydb.core.internal.command.DbMigrate.doMigrate(DbMigrate.java
:352)
at
org.flywaydb.core.internal.command.DbMigrate.access$1100(DbMigrate.ja
va:47)
at
org.flywaydb.core.internal.command.DbMigrate$4.doInTransaction(DbMigr
ate.java:308)
at
org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(Tran
sactionTemplate.java:72)
at
org.flywaydb.core.internal.command.DbMigrate.applyMigration(DbMigrate
.java:305)
at
org.flywaydb.core.internal.command.DbMigrate.access$1000(DbMigrate.ja
va:47)
at
org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:230)
at
org.flywaydb.core.internal.command.DbMigrate$2.doInTransaction(DbMigr
ate.java:173)
at
org.flywaydb.core.internal.util.jdbc.TransactionTemplate.execute(Tran
sactionTemplate.java:72)
at
org.flywaydb.core.internal.command.DbMigrate.migrate(DbMigrate.java:1
73)
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.j
ava:655)
... 8 more
Caused by: java.sql.SQLSyntaxErrorException: ORA-00904: "ITEM_ID":
identificador
inválido
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:450)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:399)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:1059)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:522)
at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:257)
at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:587)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:210)
at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:30)
at
oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:931)
at
oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStateme
nt.java:1150)
at
oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.ja
va:1792)
at
oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1745)
at
oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrap
per.java:334)
at
org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatem
ent.java:291)
at
org.apache.commons.dbcp2.DelegatingStatement.execute(DelegatingStatem
ent.java:291)
at
org.flywaydb.core.internal.dbsupport.JdbcTemplate.executeStatement(Jd
bcTemplate.java:238)
at
org.flywaydb.core.internal.dbsupport.SqlScript.execute(SqlScript.java
:114)
--
You received this message because you are subscribed to the Google Groups
"DSpace Community" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at https://groups.google.com/group/dspace-community.
For more options, visit https://groups.google.com/d/optout.
