Steps for Existing Published or Production Notebooks

For upgrade environments with existing published or production notebooks, perform the following steps after completing the OFS MMG upgrade steps:

1. Log in to the OFS MMG application.
2. Open any Data Studio page once.
3. Execute the following SQL in the Data Studio schema:

   UPDATE DS_NOTEBOOK
   SET is_editable = 0,
   is_runnable = 1
   WHERE is_editable = 0
   AND is_runnable = 0
   AND NOT EXISTS (
   SELECT 1
   FROM DS_NOTEBOOK_RELATIONS
   WHERE DS_NOTEBOOK_RELATIONS.notebook_id = DS_NOTEBOOK.id
   AND DS_NOTEBOOK_RELATIONS.relation = 'versioned_by'
   );

   This step updates the existing read-only notebooks to an executable state after the upgrade. Snapshot or versioned notebooks are excluded from this update.

   Note:

   Perform this step only after you access Data Studio for the first time after performing the upgrade steps.

Post-Upgrade Utility

In upgrade environments containing existing published or production notebooks, you must run the post-upgrade utility after completing the MMG upgrade.

Place post_upgrade_fix_812_to_813.sh in MMG_HOME/bin and execute the following commands from that location:

chmod +x post_upgrade_fix_812_to_813.sh
./post_upgrade_fix_812_to_813.sh

This utility performs the required post-upgrade update for existing notebooks.

Note:

Ensure that the OFS MMG services are up and accessible before running the utility.