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

From
Edward Malinowski <ed.malinowski@thekey.com>
To
Monica Johnston <johnstonm@thekey.com>
CC
Laszlo Kovacs <laszlo.kovacs@thekey.com>, Amy Freeman <afreeman@thekey.com>, Donny Deshotels <donny.deshotels@thekey.com>, Geraldine Nath <geraldine.nath@thekey.com>, 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 11:22:22
Folder
INBOX
--000000000000cbc23a061857756e Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: quoted-printable 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 o= n > 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 midd= le > 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=99= s gone 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 asa= p >> 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 > dataengineering@thekey.com>; 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 dat= a >> - 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 morning are missing data. We will >> resend once Wellsky has provided the Canadian data. >> >> >> >> *Payroll:* This should not affect payroll. >> >> >> >> I will send out an update when I have more 

Thread (2)