Instructions for Transitioning to the Business Process Registry

⚠️

After following this instruction, only qbpmcockpit, qcui, and qbprui should be operational on your stand. qbpmdesigner must be turned off after migration.

⚠️

Attention: This instruction is relevant if qbpmdesigner and qbpmcockpit were installed on the stand. If qbpmdesigner was not previously installed and qbpmcockpit is being installed for the first time, skip steps 1-3 and 6-7.

⚠️

The time taken for the transition will depend on the size of the qbpmdesigner database.

⚠️

In the q_bpm_product table, IDs from 100 to 200 are reserved. Do not use this range.

Steps for Transitioning to the Business Process Registry

Determine the size of the tables to be migrated.

SELECT SUM(pg_total_relation_size('qbpmdesigner.' || table_name)) / 1024 / 1024 AS "Size of the tables in MB"
FROM information_schema.tables
WHERE table_schema = 'qbpmdesigner'
  AND table_name IN ('auto_pk_support',
                     'q_bpm_clob_data',
                     'q_bpm_product_owner',
                     'q_bpm_product',
                     'q_bpm_diagram',
                     'q_bpm_diagram_comment',
                     'q_bpm_diagram_comment_read',
                     'q_bpm_diagram_version',
                     'q_bpm_diagram_item',
                     'q_bpm_diagram_item_link',
                     'q_bpm_diagram_item_req',
                     'q_bpm_diagram_item_variable',
                     'q_bpm_diagram_labels',
                     'q_bpm_diagram_milestone',
                     'q_bpm_diagram_template',
                     'q_bpm_diagram_verification',
                     'q_bpm_diagram_version_protocol',
                     'q_bpm_diagram_version_res_def',
                     'q_bpm_favourite_diagram',
                     'q_bpm_favourite_product',
                     'q_bpm_label',
                     'q_bpm_milestone',
                     'q_bpm_milestone_version',
                     'q_bpm_milestone_version_link',
                     'qbpmdesigner_access',
                     'qbpmdesigner_access_right',
                     'qbpmdesigner_api',
                     'qbpmdesigner_api_attribute',
                     'qbpmdesigner_attribute',
                     'qbpmdesigner_event',
                     'qbpmdesigner_event_attribute',
                     'qbpmdesigner_participant',
                     'qbpmdesigner_pbc',
                     'qbpmdesigner_role',
                     'qbpmdesigner_role_access',
                     'qbpmdesigner_test_value_set',
                     'qhprj_healthproject',
                     'qhprj_healthprojectitem',
                     'qhprj_healthprojectpublish',
                     'qhprj_projectgrouptpstate',
                     'rights_cacheid');

Turn off qbpmdesigner and qbpmcockpit on the stand.
Create a dump of the tables to be migrated from qbpmdesigner.
In Kubernetes, recreate the Job database-qbpmcockpit, specifying the current image from registry-new.diasoft.ru/release/database-qbpmcockpit.
Wait for the successful completion of the Job database-qbpmcockpit run.
Update qbpmcockpit to the latest version from registry-new.diasoft.ru/release/qbpmcockpit.
Perform the migration of the tables, ensuring there are no errors during the script execution:

   TRUNCATE TABLE qbpmcockpit.auto_pk_support;
   INSERT INTO qbpmcockpit.auto_pk_support SELECT * FROM qbpmdesigner.auto_pk_support;
   INSERT INTO qbpmcockpit.q_bpm_clob_data SELECT * FROM qbpmdesigner.q_bpm_clob_data;
   INSERT INTO qbpmcockpit.q_bpm_owner SELECT * FROM qbpmdesigner.q_bpm_product_owner;
   INSERT INTO qbpmcockpit.q_bpm_product SELECT * FROM qbpmdesigner.q_bpm_product;
   INSERT INTO qbpmcockpit.q_bpm_diagram SELECT * FROM qbpmdesigner.q_bpm_diagram;
   INSERT INTO qbpmcockpit.q_bpm_diagram_comment SELECT * FROM qbpmdesigner.q_bpm_diagram_comment;
   INSERT INTO qbpmcockpit.q_bpm_diagram_comment_read SELECT * FROM qbpmdesigner.q_bpm_diagram_comment_read;
   INSERT INTO qbpmcockpit.q_bpm_diagram_version SELECT * FROM qbpmdesigner.q_bpm_diagram_version;
   INSERT INTO qbpmcockpit.q_bpm_diagram_item SELECT * FROM qbpmdesigner.q_bpm_diagram_item;
   INSERT INTO qbpmcockpit.q_bpm_diagram_item_link SELECT * FROM qbpmdesigner.q_bpm_diagram_item_link;
   INSERT INTO qbpmcockpit.q_bpm_diagram_item_req SELECT * FROM qbpmdesigner.q_bpm_diagram_item_req;
   INSERT INTO qbpmcockpit.q_bpm_diagram_item_variable SELECT * FROM qbpmdesigner.q_bpm_diagram_item_variable;
   INSERT INTO qbpmcockpit.q_bpm_diagram_labels SELECT * FROM qbpmdesigner.q_bpm_diagram_labels;
   INSERT INTO qbpmcockpit.q_bpm_diagram_milestone SELECT * FROM qbpmdesigner.q_bpm_diagram_milestone;
   INSERT INTO qbpmcockpit.q_bpm_diagram_template SELECT * FROM qbpmdesigner.q_bpm_diagram_template;
   INSERT INTO qbpmcockpit.q_bpm_diagram_verification SELECT * FROM qbpmdesigner.q_bpm_diagram_verification;
   INSERT INTO qbpmcockpit.q_bpm_diagram_version_protocol SELECT * FROM qbpmdesigner.q_bpm_diagram_version_protocol;
   INSERT INTO qbpmcockpit.q_bpm_diagram_version_res_def SELECT * FROM qbpmdesigner.q_bpm_diagram_version_res_def;
   INSERT INTO qbpmcockpit.q_bpm_favourite_diagram SELECT * FROM qbpmdesigner.q_bpm_favourite_diagram;
   INSERT INTO qbpmcockpit.q_bpm_favourite_product SELECT * FROM qbpmdesigner.q_bpm_favourite_product;
   INSERT INTO qbpmcockpit.q_bpm_label SELECT * FROM qbpmdesigner.q_bpm_label;
   INSERT INTO qbpmcockpit.q_bpm_milestone SELECT * FROM qbpmdesigner.q_bpm_milestone;
   INSERT INTO qbpmcockpit.q_bpm_milestone_version SELECT * FROM qbpmdesigner.q_bpm_milestone_version;
   INSERT INTO qbpmcockpit.q_bpm_milestone_version_link SELECT * FROM qbpmdesigner.q_bpm_milestone_version_link;
   INSERT INTO qbpmcockpit.qbpmdesigner_access SELECT * FROM qbpmdesigner.qbpmdesigner_access;
   INSERT INTO qbpmcockpit.qbpmdesigner_access_right SELECT * FROM qbpmdesigner.qbpmdesigner_access_right;
   INSERT INTO qbpmcockpit.qbpmdesigner_pbc SELECT * FROM qbpmdesigner.qbpmdesigner_pbc;
   INSERT INTO qbpmcockpit.qbpmdesigner_api SELECT * FROM qbpmdesigner.qbpmdesigner_api;
   INSERT INTO qbpmcockpit.qbpmdesigner_attribute SELECT * FROM qbpmdesigner.qbpmdesigner_attribute;
   INSERT INTO qbpmcockpit.qbpmdesigner_api_attribute SELECT * FROM qbpmdesigner.qbpmdesigner_api_attribute;
   INSERT INTO qbpmcockpit.qbpmdesigner_event SELECT * FROM qbpmdesigner.qbpmdesigner_event;
   INSERT INTO qbpmcockpit.qbpmdesigner_event_attribute SELECT * FROM qbpmdesigner.qbpmdesigner_event_attribute;
   INSERT INTO qbpmcockpit.qbpmdesigner_participant SELECT * FROM qbpmdesigner.qbpmdesigner_participant;
   INSERT INTO qbpmcockpit.qbpmdesigner_role SELECT * FROM qbpmdesigner.qbpmdesigner_role;
   INSERT INTO qbpmcockpit.qbpmdesigner_role_access SELECT * FROM qbpmdesigner.qbpmdesigner_role_access;
   INSERT INTO qbpmcockpit.qbpmdesigner_test_value_set SELECT * FROM qbpmdesigner.qbpmdesigner_test_value_set;
   INSERT INTO qbpmcockpit.qhprj_healthproject SELECT * FROM qbpmdesigner.qhprj_healthproject;
   INSERT INTO qbpmcockpit.qhprj_healthprojectitem SELECT * FROM qbpmdesigner.qhprj_healthprojectitem;
   INSERT INTO qbpmcockpit.qhprj_healthprojectpublish SELECT * FROM qbpmdesigner.qhprj_healthprojectpublish;
   INSERT INTO qbpmcockpit.qhprj_projectgrouptpstate SELECT * FROM qbpmdesigner.qhprj_projectgrouptpstate;
   INSERT INTO qbpmcockpit.rights_cacheid SELECT * FROM qbpmdesigner.rights_cacheid;

⚠️

If a very old version of qbpmdesigner was installed on the stand, some tables may not be found. In this case, skip the insert for the missing tables.

Update the version of qbpmui to the latest version from registry-new.diasoft.ru/release/qbpmui.
If the menu items "Business Process Designer" and "Business Process Monitoring" were used in your root application (the unified main menu used on your stand): Change the endpoint"service": "qbpmdesigner" and the endpoint "service": "qbpmcockpit" to "service": "qcui"

      {
        "caption": "Business Process Designer",
        "service": "qbpmdesigner",
        "component": "qbpmdesigner"
      },
      {
        "caption": "Business Process Monitoring",
        "service": "qbpmcockpit",
        "component": "qbpmcockpit"
      }

Add a section Business Process Registry.

      {
        "caption": "Business Process Registry",
        "expanded": false,
        "icon": "pi-list",
        "items": [
          {
            "caption": "Business Processes and Rules",
            "service": "qbprui",
            "component": "qbprui",
            "route": "/diagram",
            "icon": "qi-cubes-outlined"
          },
          {
            "caption": "Process Instances",
            "service": "qbprui",
            "component": "qbprui",
            "route": "/process-instance",
            "icon": "qi-layers-outlined"
          },
          {
            "caption": "Migration",
            "service": "qbprui",
            "component": "qbprui",
            "route": "/migration",
            "icon": "pi-copy-outlined"
          }
        ]
      }

Install the latest versions of qcui and qbprui.
Turn on qbpmcockpit.
Check that qbpmdesigner is turned off on your stand, and qbpmcockpit, qcui, and qbprui are turned on and operational.
Verify the functionality of the new menu items in the root application.

⚠️

If a 404 error is returned in the interface, restart mdpgateway.

Publication of the execution service User Tasks