Uploaded image for project: 'OpenIDM'
  1. OpenIDM
  2. OPENIDM-1462

Activity database upgrade script does not work with Oracle DB as repository.

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Minor
    • Resolution: Won't Fix
    • Affects Version/s: OpenIDM 3.0.0
    • Fix Version/s: OpenIDM 3.1.0
    • Component/s: Module - Workflow
    • Labels:
    • Environment:
      OpenIDM 2433, Oracle XE 11.2, ojdbc6 11.2.0.3, Activity upgrade from 5.11 to 5.12
    • Sprint:
      Sprint 26

      Description

      The activity database upgrade scripts from version 5.11 to 5.12 does not work properly when using Oracle DB as repository and causes OpenIDM to fail to use oracle db as repository.

      Talked to Orsi about this issues and she said there's nothing she can do about it, so purpose of this jira is more like tracking one.

      To reproduce:
      1) Have installed openidm repository schema with activity 5.11 database schema.
      2) Setup openidm with activity 5.12 to use the oracle db with old schema as repository.
      3) during bootstraping repository following error appears:

       
      Sep 2, 2013 3:55:52 PM org.activiti.engine.impl.db.DbSqlSession dbSchemaUpgrade
      INFO: upgrading activiti engine schema from 5.11 to 5.12
      Sep 2, 2013 3:55:52 PM org.activiti.engine.impl.db.DbSqlSession dbSchemaUpgrade
      INFO: upgrading activiti history schema from 5.11 to 5.12
      Sep 2, 2013 3:55:52 PM org.activiti.engine.impl.db.DbSqlSession executeSchemaResource
      INFO: performing upgrade on history with resource org/activiti/db/upgrade/activiti.oracle.upgradestep.511.to.512.history.sql
      Sep 2, 2013 3:55:52 PM org.forgerock.openidm.repo.jdbc.impl.pool.DatabaseShutdownHook onConnectionException
      WARNING: Database down at 2013-09-02T15:55:52.789+02:00
      Sep 2, 2013 3:55:52 PM com.jolbox.bonecp.MemorizeTransactionProxy invoke
      SEVERE: Connection failed. Attempting to recover transaction on Thread #13
      Sep 2, 2013 3:55:52 PM org.forgerock.openidm.repo.jdbc.impl.pool.DatabaseShutdownHook onAcquireFail
      WARNING: Failure to acquire connection at 2013-09-02T15:55:52.858+02:00. Retry attempts remaining : 10
      Sep 2, 2013 3:55:52 PM com.jolbox.bonecp.hooks.AbstractConnectionHook onAcquireFail
      SEVERE: Failed to replay transaction Sleeping for 7000ms and trying again. Attempts left: 10. Exception: java.sql.SQLException: ORA-01430: column being added already exists in table
      
      Sep 2, 2013 3:56:00 PM org.forgerock.openidm.repo.jdbc.impl.pool.DatabaseShutdownHook onAcquireFail
      WARNING: Failure to acquire connection at 2013-09-02T15:56:00.027+02:00. Retry attempts remaining : 9
      

      Workaround:
      Delete the tables related to activity (ACT_*) and startup openidm. The openidm will automatically create a new tables. However, there's one caveat, if you do this, make sure that all data from those tables are backed up because otherwise you're obviously gonna lose them.

      And there's also one question remaining. Does the backed up data will fit into the new activity schema?

      Also I will need to check with other databases - mysql, mssql to see if the same problem appears there.

        Attachments

          Activity

            People

            Assignee:
            omebold omebold
            Reporter:
            Ladislav.Folta Ladislav Folta
            QA Assignee:
            Ladislav Folta Ladislav Folta
            Votes:
            0 Vote for this issue
            Watchers:
            2 Start watching this issue

              Dates

              Created:
              Updated:
              Resolved: