Forums » Interstage BPM Knowledgebase Articles

• C.Y. Chen

  

  • 33 posts
   

  March 11, 2013 3:22:16 PM PDT

  Title: DB Upgrade Error Message To Be Ignored

   

  Fact: Interstage BPM (Business Process Manager) Version 11.3 Build IF1130049

   

  Fact: Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit 
  Production

   

  Fact: RedHat Enterprise Linux Version 6.1 (for Intel64)

   

  Fact: Version table schemaId equals to 250 prior to DB Upgrade

   

  Fact: Version table schemaBuild equals to 216 prior to DB Upgrade

  
  Symptom:
  Running remote DB upgrade, step 2 for data migration involving Java execution environment, failed with the following error message in dbupgrade.log,
  typically found in {BPM home}/server/deployment/dbupgrade/logs:

  [Mar 09 2013 - 23:25:48] INFO: === Starting Data Migration ===
  [Mar 09 2013 - 23:25:48.554] INFO : DbMigrate main method starts
  [Mar 09 2013 - 23:25:49.555] INFO : Loading all data to initialize the data base
  object handling...
  [Mar 09 2013 - 23:25:49.557] INFO : Done.
  [Mar 09 2013 - 23:25:49.610] INFO : dbUpgradeType is DBMIGRATE
  [Mar 09 2013 - 23:25:49.610] INFO : Executing precondition to check if Schema
  Migration is successful started.
  [Mar 09 2013 - 23:25:49.873] ERROR : Precondition check failed. Database
  upgrade is not possible as the existing DB is of higher or same Interstage BPM
  version
  [Mar 09 2013 - 23:25:49] ERROR: Failed to perform selected operation for
  Database Upgrade.

   

  Symptom:
  Running step 3 of remote DB upgrade failed with the following error message in dbupgrade.log, typically found in dbupgrade_local/logs:

  old 2: svDBUser VARCHAR2(30) := '&1';
  new 2: svDBUser VARCHAR2(30) := 'ibpmuser';
  old 6: product VARCHAR2(64) := '&4';
  new 6: product VARCHAR2(64) := '11.3';
  old 7: target_build VARCHAR2(64) := '&2';
  new 7: target_build VARCHAR2(64) := 'IF1130049';
  old 8: dbSchemaId NUMBER := &3;
  new 8: dbSchemaId NUMBER := 250;
  DECLARE
  *
  ERROR at line 1:
  ORA-20151: Database upgrade is not required as it has higher version schema
  ORA-06512: at line 1399

  
  Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit
  Production
  [Mar 09 2013 - 23:41:04] ERROR: Failed to perform selected operation for
  Database Upgrade.

  
  Fix:
  For remote DB upgrade, there are three steps involved as described in Interstage BPM installation guide.

   

  If prior to DB upgrade your Version table already contains schemaId equals to '250' and schemaBuild equals to '216',
  then the DB upgrade to v11.3 build IF1130049 will results in error.

   

  Check dbupgrade.log after completing each step of DB upgrade.

  Specifically, for the dbupgrade of step 2 and 3, if the error messages are pertaining to 

  "Database upgrade is not required as it has higher version schema" or "Database
  upgrade is not possible as the existing DB is of higher or same Interstage BPM
  version", then you can safely ignored the error.  However, step 1 of DB schema migration has to be successful.

   

   

   

   

  
  This post was edited by C.Y. Chen at March 11, 2013 3:25:26 PM PDT