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.
Source facts
Action
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.
Initiated
2012-01-11
Root cause
Software design
Terminated
2012-12-12
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.
Recall number
Z-1191-2012
Recall status
Terminated
CDRH record ID
107082
FDA classified
2012-03-08
Recall event number
61021
Source facts and excerpts are reproduced for research. Dates retain their source meanings. “First observed” describes collection, not FDA publication or product launch.
Recall classification is supplied only when the recall number matches an enforcement record. Recall class and device class are different fields. Several recall records may belong to one recall event.