Device Recall Microsoft Amalga UIS 2009 의 리콜

Recall

61021

Class 2

Z-1191-2012

2012-01-11

2012-03-08

Terminated

United States

2012-12-12

USFDA

https://www.accessdata.fda.gov/scripts/cdrh/cfdocs/cfres/res.cfm?id=107082

The problem occurs when a user filters the data in amalga datagrid to exclude specific values. if the field specified in the filter criteria contains null values, the filtering will exclude those records as well.

Microsoft Corporation Health Solutions Group sent a "Urgent Field Safety Notice" email dated January 19, 2012, to all affected customers. Notification of customers in China is still pending due to the Chinese New Year Holiday. Customers were instructed to : 1. If the user notices varying row counts or inconsistent values in a given column and they are using the exclude filter, they may have to look for alternative ways to filter the data that do not use the above mentioned filter conditions. 2. To avoid the indicated issue in your implementation there are two steps to be taken: a. Ensure that all parsers are inserting empty strings () rather than NULL when ingesting data into the system and b. Identify all Baseview definitions (i.e. the sql view that a baseview is accessing) that include an outer join and update those definitions to include the ISNULL replacement function [e.g. ISNULL( column_name, )] on any columns which may return NULL due to a non-matching row in the outer join tab As of January 23, 2012 The firm's members of Services Team have spoken by phone with representative of every customer. Customers should call 425-882-8080 for any questions about this recall.