DM_GWPipeline_Gateway_MashupDataAccessError (Not like other post)

Its hard to explain without giving away to much buisness info:

But the simple version is the MYSQL query I was useing was causing the MySQL connection to time-out and close becuause it was going over the 60sec limit.

Like if you are using MySQL workbench and run a complex query and it never loads because it fails, this is that.

So my query originally worked because the date range was small, it was only a span of a few months, but as time went on it was growing and growing and when this error occured it was trying to do an complex query with a large date range (multiple years).

So I had to break it up into 2 queries, 1 for the first year, and ran it once, and then set it to not auto refreash ( the data in it shouldnt change)

Then the newest data is on a new query and runs fine. And when it gets near the end of the year ill probably archieve this years data and start the query from 2023-12-01 and go from there.