Re: Missing Client profiles in the Data Lake 1/16/24

From
Monica Johnston <johnstonm@thekey.com>
To
TheKey IT Support <itsupport@thekey.com>, Dart Team <dart-team@thekey.com>, Data Engineering <dataengineering@thekey.com>
Date
ue, 16 Jan 2024 18
Folder
INBOX
*Last update:* The updated Netsuite file is being processed. I have marked
the issue on the IT Status <https://thekeystatus.trust.pagerduty.com/> page
as resolved.

Thanks,
Monica

BCC: Executive team, Regional Directors, Tableau Desktop Users, Payroll
Notifications, Billing Alerts, Sales Leadership

On Tue, Jan 16, 2024 at 1:35 PM Monica Johnston <johnstonm@thekey.com>
wrote:

> *Update 12:30 PM Pacific*
>>
>>    - The Tableau / Analytics Portal reports have been refreshed
>>    - The new files for Netsuite billing is still WIP
>>    - Wellsky has confirmed that they have fixed the issue on their side
>>    and this should not be a problem tomorrow
>>
>> Thanks,
>> Monica
>>
>> BCC: Executive team, Regional Directors, Tableau Desktop Users, Payroll
> Notifications, Billing Alerts, Marketing team
>
>>
>> On Tue, Jan 16, 2024 at 11:21 AM Monica Johnston <johnstonm@thekey.com>
>> wrote:
>>
>>> *Update 10 AM Pacific*
>>>
>>> As a temporary workaround, we have reverted our data lake views to use
>>> yesterday's data. This means we will still be missing any new clients
>>> created yesterday but the profile information for older clients will all be
>>> available.
>>>
>>> *Next Steps:*
>>>
>>>    - Tableau / Analytics Portal reports are being refreshed
>>>    - New files will be sent to Netsuite for billing
>>>
>>> Wellsky is looking into the problem but they have not shared an ETA for
>>> the permanent fix.
>>>
>>> Thanks,
>>> Monica
>>>
>>> On Tue, Jan 16, 2024 at 10:04 AM Monica Johnston <johnstonm@thekey.com>
>>> wrote:
>>>
>>>> This morning we did not receive all of the profile data from Wellsky .
>>>> This means we are missing some active client information (not just new
>>>> profiles).
>>>>
>>>> *What is the Impact?*
>>>>
>>>> *Analytics Portal / Tableau Reports: *Active Client Census metrics on
>>>> reports will be incorrect. Detailed operational reports may have client
>>>> ids/names missing.
>>>>
>>>> *Billing: *Overtime Exception reports missing client information.
>>>> Files sent to Netsuite this morning are missing data.
>>>>
>>>> *Payroll:* This should not affect payroll.
>>>>
>>>> I will send out an update when I have more information. Please reach
>>>> out to me directly if you have any questions.
>>>>
>>>> Thanks!
>>>> Monica
>>>>
>>>> BCC: Executive team, Regional Directors, Tableau Desktop Users, Payroll
>>>> Notifications, Billing Alerts
>>>>
>>>> --
>>>> Monica Johnston
>>>> Manager of Data Services
>>>>
>>>> johnstonm@thekey.com
>>>> <https://brand.thekey.com/esg/johnstonm@thekey.com>
>>>> (602) 501-7890
>>>> TheKey.com <https://www.thekey.com/>
>>>> [image: TheKey] <https://homecareassistance.com/>
>>>>
>>>

Thread (2)