RE: Data lake missing Wellsky data from yesterday 5/9/24

From
Laszlo Kovacs <laszlo.kovacs@thekey.com>
To
Edward Malinowski <ed.malinowski@thekey.com>, Monica Johnston <johnstonm@thekey.com>
CC
Amy Freeman <afreeman@thekey.com>, Donny Deshotels <donny.deshotels@thekey.com>, Geraldine Nath <geraldine.nath@thekey.com>, Natalie Cahoone <natalie.cahoone@thekey.com>, Paul Kahn <paul.kahn@thekey.com>, Elizabeth Clark <eclark@thekey.com>, Alyson Rohane <alyson.rohane@thekey.com>, Timothy Thomas <tt@thekey.com>, Azhar Pathan <apathan@thekey.com>
Date
2024-05-13 10:26:07
Folder
INBOX
--0000000000002cb44806185781b8 Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable Monica =E2=80=93 Good there was some progress. Hopefully they will get the = kinks worked out in short order. Ed =E2=80=93 Appreciate the support as always. Thanks, *From:* Edward Malinowski *Sent:* Monday, May 13, 2024 10:22 AM *To:* Monica Johnston *Cc:* Laszlo Kovacs ; Amy Freeman ; Donny Deshotels ; Geraldine Nath ; natalie.cahoone@thekey.com; Paul Kahn ; Elizabeth Clark ; Alyson Rohane ; Timothy Thomas ; Azhar Pathan *Subject:* Re: Data lake missing Wellsky data from yesterday 5/9/24 Amy is off this week, so please CC me on comms with Wellsky and I will escalate. On Mon, May 13, 2024 at 11:19=E2=80=AFAM Monica Johnston wrote: Lazlo, We did get the Canadian data over the weekend but we did not receive it on time this morning due to an issue with their control table that triggers our data integration. We have the up to date data now and are in the middle of running dependent processes. I am adding Amy on here since Ed has designated her to coordinate issue communication and escalations with Wellsky. However I did already alert them to the problem this morning. They said it was resolved over the weekend so I hope this was just a minor timing issue. Thanks, Monica On Mon, May 13, 2024 at 6:58=E2=80=AFAM Laszlo Kovacs wrote: Hi Monica, Following up on this. Was Wellsky able to make any progress over the weekend? I=E2=80=99m sure you=E2=80=99re aware of the prep that=E2=80=99s g= one into this conversion by the Finance teams as well as messaging to impacted CAD customers. We need to push our absolute hardest to have Wellskey get this remedied asap or there will need to be a ton of re-work and an impact on customer experience. Thanks, *From:* Monica Johnston *Sent:* Friday, May 10, 2024 6:10 PM *To:* Dart Team ; Data Engineering ; Donny Deshotels *Subject:* Re: Data lake missing Wellsky data from yesterday 5/9/24 *Update as of 4 pm Pacific:* Wellsky is still working on the issue. There is no ETA at this time. *Billing: *Since we will not have Canadian data available in the data lake today, we are sending the US data to Netsuite now. Thanks, Monica On Fri, May 10, 2024 at 12:19=E2=80=AFPM Monica Johnston wrote: *Update as of noon Pacific:* - Analytics Portal reports have been refreshed with up to date US data - We have been notified by Wellsky that it will take them an additional 2 hours to provide the Canadian data. On Fri, May 10, 2024 at 9:31=E2=80=AFAM Monica Johnston wrote: This morning we did not receive any of the Canadian data from Wellsky. This also caused an issue with our ability to load the US data into our reporting tables in the data lake. *What is the Impact?* *Analytics Portal / Tableau Reports: *SoC, billed hours, revenue and other metrics relying on Clearcare data are missing yesterday's totals. - ETA to have reports refreshed for US is 1 hour - ETA for Canadian data is 4 hours *Billing: *Files sent to Netsuite this 

Thread (1)