Microsoft Amalga UIS 2009 is Microsoft Amalga Unified Intelligence System (UIS), Calculator/data processing module, for

FDA device recall Z-1191-2012 · posted 2012-03-08 · Terminated

Recall details

Recalling firm

Microsoft Corporation Health Solutions Group

Reason for recall

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.

Action taken

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.

Root cause

Software design

Status

Terminated

Product code

JQP

Quantity affected

28 units

Distribution

Worldwide Distribution -- USA (nationwide) including the states of AR, CA, KY, HI, FL, MA, MD, MN, NC, NJ, NY, WA, WI and countries China, Switzerland, and United Kingdom.

Date initiated

2012-01-11

Date posted

2012-03-08

Date terminated

2012-12-12

Location

Redmond, WA