Update of JOC Cockpit to release 2.7.3 fails for Oracle DBMS

Current Situation

• When updating JOC Cockpit to release 2.7.3 using the Oracle DBMS, the following error is raised:

  Wed 21:29:20.627 [INFO ] (SOSHibernateFileProcessor.java:64) - [process][/opt/sos-berlin.com/js7/joc/db/oracle][error]:
  Wed 21:29:20.627 [INFO ] (SOSHibernateFileProcessor.java:67) - [process]     1) /opt/sos-berlin.com/js7/joc/db/oracle/inventory_alter.sql: com.sos.commons.hibernate.exception.SOSHibernateSQLExecutorException: 1758 ORA-01758: table must be empty to add mandatory (NOT NULL) column
  ORA-06512: at line 5
   [DECLARE column_exist number;
  BEGIN
  SELECT COUNT(*) INTO column_exist FROM USER_TAB_COLS WHERE column_name = 'CONTROLLER_ID' AND table_name = 'INV_SUBAGENT_CLUSTERS';
  IF (column_exist = 0) THEN
  EXECUTE IMMEDIATE 'ALTER TABLE INV_SUBAGENT_CLUSTERS ADD "CONTROLLER_ID" NVARCHAR2(100) DEFAULT '''' NOT NULL';
  EXECUTE IMMEDIATE 'UPDATE INV_SUBAGENT_CLUSTERS sc SET sc."CONTROLLER_ID" = (SELECT ai."CONTROLLER_ID" FROM INV_AGENT_INSTANCES ai WHERE ai."AGENT_ID"=sc."AGENT_ID")';
  END IF;
  END;]
  

Maintainer Notes

• A Patch is available for Unix/Windows:
  •  https://download.sos-berlin.com/patches/2.7.3-patch/js7_joc.2.7.3-PATCH.SETUP-1.SET-234.zip [sha256 [sig [tsr
    or
    https://download.sos-berlin.com/patches/2.7.3-patch/js7_joc.2.7.3-PATCH.SETUP-1.SET-234.tar.gz [sha256 [sig [tsr

• Extract above archive after the JOC update into $JOC_HOME/db/oracle
• Call $JOC_HOME/install/joc_install_tables.(sh|cmd) on the command line prompt