Anyone else see slow queries with SuiteAnalytics Connect at the moment?
👍 1
m
mwalsh00
10/04/2023, 1:37 AM
I have some SuiteAnalytics Connect queries that typically ran in 3-4 mins suddenly now hitting the 5 min limit and timing out. Volume of data the query is handling hasn’t changed. Its almost like the queries are less performant than they were a week or two ago..
w
Watz
10/04/2023, 8:03 AM
I've created a support case, but I have just gotten through the hoops with support to create a defect.
m
mwalsh00
10/04/2023, 12:21 PM
Same, mine is “Case #5402370: SuiteAnalytics Connect (JDBC) queries timing out” if you wanted to reference and try to have them linked together
w
Watz
10/04/2023, 1:39 PM
I got mine assigned to defect #738859, might be specific for our account.
m
mwalsh00
10/04/2023, 2:15 PM
Interesting twist: we have widely varying performance based on the environment we are using to run the query:
1. Our production Boomi intergration environment (Server in cloud) was timing out (5 mins) at of 8am ET
2. Queries run locally in a SQL workbench (DBeaver) were timing out
3. But a Boomi environment on a local VM (same laptop running DBeaver 🤷‍♂️ ) was running in under 1 minute.
I’ll keep you posted, if you dont mind keeping me posted on yours, please
👍 1
w
Watz
10/04/2023, 9:42 PM
Both of our instances stopped responding through JDBC at 10pm gmt+2 today. We use Fivetran to sync data to Snowflake
Watz
10/04/2023, 11:06 PM
I can't even connect to Netsuite using JDBC at the moment with DBeaver.
m
mwalsh00
10/11/2023, 7:18 PM
Our issue was completely unrelated to Netsuite…degradation of a server in our integration environment