T45-2024 Notification regarding BIOVIA Foundation 2021 SP1 IDR1

Program

BIOVIA Foundation

Operating System

All supported operating systems

Description

We are providing this Technical Note to inform you about the controlled availability (CA) release of BIOVIA Foundation 2021 SP1 IDR1 which includes the following enhancements and fixed defects:

Scope

This release is applicable to BIOVIA Foundation 2021 SP1.

Issue

Activities with names 95 or more characters long cannot be cloned or reopened for edit. Activities in the approved lifecycle state are read-only and therefore no corrective steps can be performed through the UI.

NOTE: Activity names must be 90 or fewer characters for the create child activity action to succeed. In this case, clone an existing child activity instead of creating a new one from the parent activity or rename the parent activity to be 90 or fewer characters in length.

Resolution

The below steps will resolve the issues reported in DAT-23799. Approved activities with names longer than 95 characters will be truncated to 95 characters. This will allow the re-open for edit and clone actions to complete successfully.

1. Using Oracle SQL Developer or SQLPlus, open a connection to the Hub Oracle schema with schema owner permissions.
2. Run the following command to identify impacted Activities :
   select id, name, life_cycle_version, life_cycle_state from REQ_ACTIVITY where length(name) > 95 and life_cycle_state = 'approved'  order by name, life_cycle_version;
3. Run the following command to create audit revisions:
   INSERT INTO cor_audit_revision (id, description, timestamp, modified_classes)
   VALUES (HIBERNATE_SEQUENCE.NEXTVAL, 'Shorten the name of approved Activities where name is 95+ characters', CURRENT_TIMESTAMP, ',Activity');
4. Run the following command to create history for affected Activities, populating the highlighted <:id> field with the appropriate ID from the query in step 2:
   insert into AUD_REQ_ACTIVITY (ID, REV, REVTYPE, VERSION, ACTIVITY_TYPE, CATEGORY, DEFINED_SKILL_REQUIRED, DELETED, DEPARTMENT, DESCRIPTION, DOCUMENTATION_URL, EXTERNAL_ID, IMAGE_URI, LAST_UPDATED, LIFE_CYCLE, LIFE_CYCLE_STATE, LIFE_CYCLE_VERSION, LIFE_CYCLE_ROOT_ID, MANAGER_ASSIGNMENT_REQUIRED, NAME, LIFE_CYCLE_POLICY, SEQUENCE_POSITION, PROJECT_ID, METHOD_ID, METHOD_TYPE, EQUIPMENT, SAMPLE_SIZE, SAMPLE_SIZE_UNIT_ID, CREATOR_ID, OWNER_ID, IS_NON_DESTRUCTIVE_TEST, DISABLE_TASK_UI_EDIT, PARENT_ID, EFFECTIVE_DATE, DOCUMENT_ID, DOCUMENT_VERSION)
   SELECT ID,(SELECT MAX(id) FROM cor_audit_revision WHERE description='Shorten the name of approved Activities where name is 95+ characters'), 1,VERSION + 1, ACTIVITY_TYPE, CATEGORY, DEFINED_SKILL_REQUIRED, DELETED, DEPARTMENT, DESCRIPTION, DOCUMENTATION_URL, EXTERNAL_ID, IMAGE_URI, LAST_UPDATED, LIFE_CYCLE, LIFE_CYCLE_STATE, LIFE_CYCLE_VERSION, LIFE_CYCLE_ROOT_ID, MANAGER_ASSIGNMENT_REQUIRED, substr(NAME, 0, 95), LIFE_CYCLE_POLICY, SEQUENCE_POSITION, PROJECT_ID, METHOD_ID, METHOD_TYPE, EQUIPMENT, SAMPLE_SIZE, SAMPLE_SIZE_UNIT_ID, CREATOR_ID, OWNER_ID, IS_NON_DESTRUCTIVE_TEST, DISABLE_TASK_UI_EDIT, PARENT_ID, EFFECTIVE_DATE, DOCUMENT_ID, DOCUMENT_VERSION
   FROM REQ_ACTIVITY where ID = '<:id>';
5. Run the following command to correct the Child Activity:
   UPDATE req_activity
   SET name=substr(name, 0, 95), version=version+1
   WHERE ID = '<:id>';
   commit;

Notes: Since the change is made outside of normal use of the system, the ‘Modified By’ column will be empty in the Audit History.

BIOVIA Foundation 2021 SP1 IDR1 was released on 02 August 2022. To get access to this release, please contact BIOVIA Support.

How to contact BIOVIA Support

If you have any questions, please contact BIOVIA Support.