Oracle - ORA-00972: identifier is too long

Current Situation

• Oracle versions < 12.2 do support identifiers with 30 characters only. When using identifiers with more characters then the following error occurs during installation of JOC Cockpit:

  ..joc/db/oracle/inventory_schedule2workflows_procedure.sql: com.sos.commons.hibernate.exception.SOSHibernateSQLExecutorException: 972 ORA-00972: identifier is too long
  [CREATE OR REPLACE VIEW INV_RELEASED_SCHEDULE2WORKFLOWS AS
  SELECT
  JSON_VALUE("JSON_CONTENT",'$.workflowName') AS "WORKFLOW_NAME",
  ...

• This error occurs due to the object’s name INV_RELEASED_SCHEDULE2WORKFLOWS which is longer than 30 characters.
• Oracle versions > 12.1 support identifiers with up to 128 bytes. Depending on the character encoding of the database a maximum of 42 characters can be used for identifiers.

Desired Behaviour

• The view INV_RELEASED_SCHEDULE2WORKFLOWS should be renamed in INV_REL_SCHEDULE2WORKFLOWS.

Workaround

• Apply the following patch for JOC Cockpit 2.3.0:
  • https://download.sos-berlin.com/patches/2.3.0-patch/patch-20220426-JOC-1288-2.3.0.zip
• How to apply the patch:
  • Stop JOC-Cockpit.
  • Extract the downloaded file to any location.
    • patch-20220426-JOC-1288-2.3.0.jar
      • to apply the patch see JS7 - Patches for JOC Cockpit
    • db
      • copy the db folder to the <JOC-Cockpit install>/db directory
      • execute <JOC-Cockpit install>/install/joc_install_tables.cmd|.sh
  • Start JOC-Cockpit.