T43-2024 Notification regarding BIOVIA Foundation 2020 SP1 IDR2

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 2020 SP1 IDR2 which includes the following enhancements and fixed defects:

Scope

This release is applicable to BIOVIA Foundation 2020 SP1.

Issue

This interim document release includes scripts that address two issues

• SEC-7731: Metrology events cannot be updated for an instrument if the instrument has been moved from one equipment type to another equipment type
• SEC-7463: A Preventative Maintenance (PM) metrology event was executed on an instrument, the PM event is no longer accessible, and the customer wants the PM next due date removed.

Resolution for SEC-7731

An instrument’s metrology next due dates are not reset when the instrument is moved to a different equipment type. Those events no longer apply because they relate to the previous equipment type.

The following steps remove the instrument’s next due dates related to the previous equipment type.

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 list all instruments that have metrology next due dates from a different equipment type:
   
   SELECT * FROM res_equipment_event event INNER JOIN res_equipment_event_type eventType ON eventType.id = event.event_type_id INNER JOIN res_equipment equipment ON equipment.id = event.equipment_id WHERE equipment.equipment_type_id != eventType.equipment_type_id;
    
3. Run the following command to remove the obsolete metrology next due dates:
   DELETE FROM res_equipment_event WHERE id IN (SELECT event.id FROM res_equipment_event event INNER JOIN res_equipment_event_type eventType ON eventType.id = event.event_type_id INNER JOIN res_equipment equipment ON equipment.id = event.equipment_id WHERE equipment.equipment_type_id != eventType.equipment_type_id);
   commit;

NOTE: The metrology events are cached by the server. It may take a few minutes after the

scripts are run for the server to catch up with the changes.

Resolution for SEC-7463

The below steps will remove the soonest preventative maintenance expiration date from an equipment instance. The process can be used when the customer no longer wants a preventative maintenance expiration date for that equipment instance.

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 remove the unwanted preventative maintenance expiration date, substituting the equipment instance barcode for 123456:
   UPDATE RES_EQUIPMENT_STATUS status
   SET status.soonest_pm_exp = NULL
   WHERE status.id in (SELECT equipment.equipment_status_id FROM RES_EQUIPMENT equipment WHERE equipment.barcode = '123456');
   commit;          

NOTE: The metrology events are cached by the server. It may take a few minutes after the scripts are run for the server to catch up with the changes.

BIOVIA Foundation 2020 SP1 IDR4 was released on 13 April 2023. To get access to this release, please contact BIOVIA Support.

How to contact BIOVIA Support

If you have any questions, please contact BIOVIA Support.