Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Apr 25th, 2012  |  syntax: None  |  size: 3.17 KB  |  hits: 9  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. NFO: Executed newly added indexed script: 02_alma9-0/003_alma9-0-5/050_enableLifeCycleFks.sql (542 ms)
  2. Exception in thread "main" org.dbmaintain.util.DbMaintainException:
  3. Error while executing script 02_alma9-0/003_alma9-0-5/060_addUpdateInfoToPeriod.sql: Could not perform database statement: alter table Period add(    
  4.         update_date timestamp,
  5.     update_userid varchar2(32)
  6. )
  7.  
  8. Caused by: ORA-00942: table or view does not exist
  9. Error code: 942, sql state: 42000
  10.  
  11. A rollback was performed but there could still be changes that were committed in the database (for example a creation of a table).
  12. There are 2 options:
  13. 1: Fix the script, manually perform the changes of the script and call the markErrorScriptPerformed task.
  14. 2: Fix the script, revert committed changes of the script (if any) and call the markErrorScriptReverted task.
  15.  
  16. You can then continue the update by re-running the updateDatabase task. The error script will only be executed again when option 2 was chosen.
  17.  
  18. Full contents of failed script 02_alma9-0/003_alma9-0-5/060_addUpdateInfoToPeriod.sql:
  19. ----------------------------------------------------
  20. alter table Period add(    
  21.         update_date timestamp,
  22.     update_userid varchar2(32)
  23. );
  24.  
  25. ----------------------------------------------------
  26.  
  27.         at org.dbmaintain.DefaultDbMaintainer.executeScript(DefaultDbMaintainer.java:428)
  28.         at org.dbmaintain.DefaultDbMaintainer.executeScriptUpdates(DefaultDbMaintainer.java:375)
  29.         at org.dbmaintain.DefaultDbMaintainer.updateDatabase(DefaultDbMaintainer.java:239)
  30.         at org.dbmaintain.launch.commandline.CommandLine.executeOperation(CommandLine.java:192)
  31.         at org.dbmaintain.launch.commandline.CommandLine.main(CommandLine.java:99)
  32. Caused by: java.sql.SQLException: ORA-00942: table or view does not exist
  33.  
  34.         at oracle.jdbc.driver.SQLStateMapping.newSQLException(SQLStateMapping.java:74)
  35.         at oracle.jdbc.driver.DatabaseError.newSQLException(DatabaseError.java:131)
  36.         at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:204)
  37.         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:455)
  38.         at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:413)
  39.         at oracle.jdbc.driver.T4C8Oall.receive(T4C8Oall.java:1034)
  40.         at oracle.jdbc.driver.T4CStatement.doOall8(T4CStatement.java:183)
  41.         at oracle.jdbc.driver.T4CStatement.executeForRows(T4CStatement.java:942)
  42.         at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1222)
  43.         at oracle.jdbc.driver.OracleStatement.executeInternal(OracleStatement.java:1770)
  44.         at oracle.jdbc.driver.OracleStatement.execute(OracleStatement.java:1739)
  45.         at oracle.jdbc.driver.OracleStatementWrapper.execute(OracleStatementWrapper.java:299)
  46.         at org.dbmaintain.database.impl.DefaultSQLHandler.execute(DefaultSQLHandler.java:87)
  47.         at org.dbmaintain.script.runner.impl.JdbcScriptRunner.parseAndExecuteScript(JdbcScriptRunner.java:95)
  48.         at org.dbmaintain.script.runner.impl.JdbcScriptRunner.execute(JdbcScriptRunner.java:81)
  49.         at org.dbmaintain.DefaultDbMaintainer.executeScript(DefaultDbMaintainer.java:421)
  50.         ... 4 more
create a new version of this paste RAW Paste Data