Luke Fontaine (luke@shield-legal.com)
2024-01-30 13:11:19

Hey @Quint Underwood I know you're working on the lambdas right now, but wanted to give you an updated, when I ran dailyfinancials-rebuild-p-CalculatePerformancePy31-HMx37JchlIZ8 this morning I kept receiving an error code when it would try to process the initials for one of our media buyers; Michael McKinney 'MM'

☝️:skin_tone_4: Ryan
Quint Underwood (quint.johnson@gmail.com)
2024-01-30 18:20:51

Hey @Luke Fontaine pulling up the logs rn

Quint Underwood (quint.johnson@gmail.com)
2024-01-30 18:46:17

I see the error, uncertain what's causing it just based on the logs... I double checked the code changes I made that added MM and PK media buyers so I suspect it's tripping over data wrangling somewhere in the code. Have you seen the same or similar errors recently?

Quint Underwood (quint.johnson@gmail.com)
2024-01-30 18:48:53

I'll add this to my task list and lyk when I get it fixed

Ryan (ryan@themedialab.agency)
2024-01-31 10:07:31

Thanks Quint, if it happens gain today we’ll note.

Luke Fontaine (luke@shield-legal.com)
2024-01-31 10:11:17

Just ran the lambda and it came back success today

👍 Quint Underwood
Ryan (ryan@themedialab.agency)
2024-01-31 10:11:38

Great.

Luke Fontaine (luke@shield-legal.com)
2024-02-06 08:31:40

@Ryan @Quint Underwood I think there's an issue with the generatefinancial log lambda. It shows that all rows have ran, but looking at the counts from the dashboard are far less than the auto notifications for the slack channel for that campaign

Quint Underwood (quint.johnson@gmail.com)
2024-02-06 09:52:01

*Thread Reply:* @Luke Fontaine I'm free of meetings by ~noon PT, can take a look then. Lmk if there's any other behavior/details that look off or might be useful for debugging

Ryan (ryan@themedialab.agency)
2024-02-06 09:56:05

*Thread Reply:* Which campaign @Luke Fontaine ?

Luke Fontaine (luke@shield-legal.com)
2024-02-06 09:58:49

*Thread Reply:* I see it on multiple ones, FireFoam, Asbestos, Intuit, CPAP. They're pretty big differences too, dash currently shows 30 for intuit while the channel has around 90+

Ryan (ryan@themedialab.agency)
2024-02-06 10:27:19

*Thread Reply:* @Luke Fontaine @Quint Underwood, since LawRuler was down, the Status Report & Call Report did not get uploaded and processed by the financial log lambda:

Even yesterdays 3PM PT did not process.

image.png
Quint Underwood (quint.johnson@gmail.com)
2024-02-06 09:53:24

And update on lambda status updating feature: I'm planning to push code this afternoon/this evening when I have a little time to monitor. Will lyk before I push anything

Luke Fontaine (luke@shield-legal.com)
2024-02-23 09:49:06

@Ryan @Quint Underwood urgent item, I'm running the generatefinance lambda to pull the remaining leads over, and continue to receive a failed message with the following error

Screenshot 2024-02-23 at 7.48.13 AM.png
Ryan (ryan@themedialab.agency)
2024-02-23 10:06:16

@Luke Fontaine, let me take a look, it appears to be a LeadID issue

Luke Fontaine (luke@shield-legal.com)
2024-02-23 10:06:45

@Ryan I'm trying another one, currently at 6 minute run time so that's a good sign

Luke Fontaine (luke@shield-legal.com)
2024-02-23 10:07:44

@Ryan finally got a succeeded message

Luke Fontaine (luke@shield-legal.com)
2024-02-23 10:07:50

continuing with financials

Ryan (ryan@themedialab.agency)
2024-02-23 10:08:06

Great, must have been an LP glitch

Luke Fontaine (luke@shield-legal.com)
2024-02-26 09:45:01

@Ryan @Quint Underwood I'm receiving another error from the generatefinancial log lambda, it's not a listing error, I'm not sure what this one means

Screenshot 2024-02-26 at 7.44.53 AM.png
Ryan (ryan@themedialab.agency)
2024-02-26 10:16:07

Let me check now

Luke Fontaine (luke@shield-legal.com)
2024-02-26 10:21:39

thank you

Ryan (ryan@themedialab.agency)
2024-02-26 10:29:35

@Quint Underwood, I cannot figure it out, but will look more soon @Luke Fontaine, have not heard from Quint yet.

Luke Fontaine (luke@shield-legal.com)
2024-02-26 10:33:55

@Ryan in one of the channels @Quint Underwood mentioned they're in a conference in Spain so it might be a while until they're able to check in. In the meantime morning financials will have to wait since I'm not able to pull over all of the leads from yesterday, unless if there's another way you know how

Luke Fontaine (luke@shield-legal.com)
2024-02-26 11:49:20

@Quint Underwood Also receiving an error when running calculateperformance lambda

Screenshot 2024-02-26 at 9.49.12 AM.png
Quint Underwood (quint.johnson@gmail.com)
2024-02-26 12:24:08

@Ryan @Luke Fontaine I'm on, investigating issues rn

Luke Fontaine (luke@shield-legal.com)
2024-03-08 10:04:59

@Quint Underwood @Ryan I may need your help with the new Generatefinancial log. I've ran it a couple times this morning and continue to receive a failed message. The first couple of times was a list of our range message, I've removed the case desc that were giving issues, after a couple of those, I received another failed in the test button, but when I clicked the cloudwatch log only one entry popped up and there was no error, I ran it again, failed code in the test section, the cloudwatch log appeared normal, I didn't see any errors in it. I'm running it one more time

Luke Fontaine (luke@shield-legal.com)
2024-03-08 10:12:49

This is what I'm currently getting as a result

Screenshot 2024-03-08 at 11.12.36 AM.png
Ryan (ryan@themedialab.agency)
2024-03-08 10:29:00

@Luke Fontaine @Quint Underwood, let me try.

Ryan (ryan@themedialab.agency)
2024-03-08 10:30:06

@Luke Fontaine, is this the Lambda you are running, named: TIP-Py311-GenerateFinancialLogPy311-9YN38SeLubUn

Luke Fontaine (luke@shield-legal.com)
2024-03-08 10:30:28

@Ryan Yes that's correct

Luke Fontaine (luke@shield-legal.com)
2024-03-08 10:52:06

any luck?

Ryan (ryan@themedialab.agency)
2024-03-08 10:57:09

@Luke Fontaine, it ran with success.

Ryan (ryan@themedialab.agency)
2024-03-08 10:57:10

You are good

Luke Fontaine (luke@shield-legal.com)
2024-03-08 10:57:48

Ok I'll jump back into financials

Luke Fontaine (luke@shield-legal.com)
2024-03-08 10:58:02

Do you know what was causing the fail message I was receiving?

Ryan (ryan@themedialab.agency)
2024-03-08 11:01:07

Not sure, @Quint Underwood if you can look into what happened that would be helfpul.

image.png
Quint Underwood (quint.johnson@gmail.com)
2024-03-08 13:33:01

Hey @Luke Fontaine & @Ryan Pulling up to look right now

Ryan (ryan@themedialab.agency)
2024-03-08 13:33:21

Thanks.

Quint Underwood (quint.johnson@gmail.com)
2024-03-08 15:28:22

@Ryan @Luke Fontaine GenerateFinancialLog did run successfully as Ryan said, I think it was still running while Luke was looking at the logs (and/or the page needed to be refreshed to get newer log entries)

Luke Fontaine (luke@shield-legal.com)
2024-03-08 15:30:42

I’ll try it again Monday, sounds like a weird fluke

👍 Quint Underwood
Luke Fontaine (luke@shield-legal.com)
2024-04-10 10:06:44

@Ryan @Quint Underwood I've ran the finance lambda multiple times this morning and keep getting a fail, it's run 3229/3363 rows, but I see rows of errors but no error code as to what it's causing it; like the list out of index that happens from time to time

Ryan (ryan@themedialab.agency)
2024-04-10 10:10:09

@Luke Fontaine, let me check

Luke Fontaine (luke@shield-legal.com)
2024-04-10 10:15:51

Just received a success messsage

Ryan (ryan@themedialab.agency)
2024-04-10 10:22:04

@Luke Fontaine, it was running 2 at a time, so that means the LP APi probably time out or something to that effect

Ryan (ryan@themedialab.agency)
2024-04-10 10:22:40

I think the 8:02 was still running when the 8:09 started

Quint Underwood (quint.johnson@gmail.com)
2024-04-10 16:04:28

Hey @Ryan & @Luke Fontaine looks like you guys have everything figured out?

Ryan (ryan@themedialab.agency)
2024-04-10 17:02:17

@Quint Underwood, yes, false alarm I think.

Ryan (ryan@themedialab.agency)
2024-04-10 17:02:24

Or Leadspedia API timed it out

Quint Underwood (quint.johnson@gmail.com)
2024-04-10 17:33:01

👍

Luke Fontaine (luke@shield-legal.com)
2024-05-30 10:14:14

@Ryan @Quint Underwood is there development happening on the calc performance lambda? I have been receiving this message this morning of an error regarding non-int case type

Screenshot 2024-05-30 at 8.14.06 AM.png
Ryan (ryan@themedialab.agency)
2024-05-30 10:20:33

Luke, I would not think so. Let me see if I can decihper anything. @Quint Underwood, let me know if you have a moment to check

Ryan (ryan@themedialab.agency)
2024-05-30 10:23:13

@Luke Fontaine, running Calc_Perf a 2nd time to see if maybe Leadspedia hiccup but it's the divide by zero issue again

Luke Fontaine (luke@shield-legal.com)
2024-05-30 10:24:00

I ran it twice this morning and yeah it was the same issue both times as well

Ryan (ryan@themedialab.agency)
2024-05-30 10:45:13

@Luke Fontaine @Quint Underwood, I am adding a lead for JV, spend and 0 leads could be the issue, so I saved one CP lead as JV and see if that works, re-running it now.

Ryan (ryan@themedialab.agency)
2024-05-30 10:52:18

@Luke Fontaine, it's run to 8 minutes, so it's promising. Standby.

Ryan (ryan@themedialab.agency)
2024-05-30 10:53:05

@Luke Fontaine, that worked! Calc_Perf finished with success. The log file said JV had zero leads, then we got the spend, not sure why it failed but it's obviously a "unhandled exception by Devin's code".

🙌:skin_tone_4: Luke Fontaine
Luke Fontaine (luke@shield-legal.com)
2024-05-30 10:56:05

Awesome!! Thank you, I’ll go finish numbers

Quint Underwood (quint.johnson@gmail.com)
2024-05-31 02:14:45

Glad you guys got this figured out earlier today--are you able to decipher either 1) the situation(s) in which this set of errors presents itself, or 2) the fixes you've made to the input data that enables calcPerf to work correctly?

Ryan (ryan@themedialab.agency)
2024-05-31 02:23:21

I think so, I just don’t know why it happened today, because money spent , but no leads is common

Luke Fontaine (luke@shield-legal.com)
2024-07-30 10:21:16

@here I keep getting an error when running cal-performance. when it has happened before it looks like it was a media buyer that had no leads, but all media buyers have a lead today

Screenshot 2024-07-30 at 8.21.07 AM.png
Ryan (ryan@themedialab.agency)
2024-07-30 10:26:25

@Luke Fontaine, let me look in daily numbers

Ryan (ryan@themedialab.agency)
2024-07-30 10:35:32

@Luke Fontaine, it should not happen. @Quint Underwood, that scenario keep happening but let me try resubmitting Caleb's numbers @Luke Fontaine. He spent on Video Gaming and New Jersey and did not get any leads, so diving those into 0 leads is the issue.

Ryan (ryan@themedialab.agency)
2024-07-30 10:35:35

I'm hoping

Ryan (ryan@themedialab.agency)
2024-07-30 10:39:39

@Luke Fontaine, I figured it out, Gaming Addiciton contracts are all paused, let me get Mark and Cameron to fix this ASAP, like 294 leads not sold

Luke Fontaine (luke@shield-legal.com)
2024-07-30 10:39:59

Ah ok