Hi Team, having an issue where I'm getting 400 err...
# gooddata-cloudc
CaS
05/28/2025, 3:09 PMHi Team, having an issue where I'm getting 400 errors on viz. will thread details
CaS
05/28/2025, 3:10 PM Copy code
6012.4341aee….js:2 Tiger backend threw an error:
{status: 400, detail: 'An error has occurred while calculating the result', resultId: '7a76778a19a6443198c61a78f338875badf45b57', reason: "No connection to 'REDACTED' available.", traceId: '77b45e61c07e22e74446f6956adc21bc'}
detail
:
"An error has occurred while calculating the result"
reason
:
"No connection to 'REDACTED' available."
resultId
:
"7a76778a19a6443198c61a78f338875badf45b57"
status
:
400
traceId
:
"77b45e61c07e22e74446f6956adc21bc"
[[Prototype]]
:
ObjectCaS
05/28/2025, 3:12 PMI am seeing it connect in our snowflake instance and run queries
CaS
05/28/2025, 4:31 PMI am also seeing this query from GD over and over as opposed to any data queries
m
Moises Morales
05/28/2025, 4:46 PMHi, I’ve reviewed the logs, and it appears that the connection to your data source (whose name begins with "O") is being limited or throttled on your end. After clearing its cache from the organization settings, previously computed insights are now failing to recompute because the connection is being refused.
With this said, could you check if any monitors have exceeded their credit limits, which would automatically suspend queries and cause connection issues? You should also be able to check the queued queries or warehouse queuing delays, which could indicate bottlenecks in your current compute configuration.
Please also be aware of the following documentation where we have some tips for improving database performance: https://www.gooddata.com/docs/cloud/connect-data/performance/
c
CaS
05/28/2025, 4:48 PMhmm, I am not seeing anything queued or running at the moment
CaS
05/28/2025, 4:56 PMi just changed to a new warehouse and now getting this error {status: 400, detail: 'General error', traceId: 'a9f92a9fed2e3944d229d30da2888b8e'}
CaS
05/28/2025, 4:58 PMactually its working now with a new warehouse
CaS
05/28/2025, 4:59 PMyes its fixed now, i changed to a brand new warehouse. to clarify we have no limits or credit thresholds on that old warehouse
✅ 1
m
Moises Morales
05/28/2025, 5:00 PMJust for reference purposes, the connection on the new warehouse was failing due to the following error:
No active warehouse selected in the current session. Select an active warehouse with the 'use warehouse' commandc
CaS
05/28/2025, 5:01 PMyep probably needed to initialize
👍 1
CaS
05/28/2025, 5:01 PMbut its a very strange thing that the old one stopped working like that
CaS
05/28/2025, 5:01 PMhave you seen that before?
m
Moises Morales
05/28/2025, 5:01 PMRegarding the old warehouse, I was able to get it to load while on edit mode and can see a few issues with it, let me send you a screenshot via DM
c
CaS
05/28/2025, 5:02 PMthank you
m
Moises Morales
06/03/2025, 6:20 PMAs discussed internally, the issue appears to stem from the JDBC driver version currently used to connect to Snowflake. We're actively working on a fix and will provide an update as soon as possible. Thank you for your patience.
b
Branislav Slávik
06/04/2025, 9:06 AMHello @CaS,
This is Branislav from the L2 Technical Support team.
I was informed, that the new driver, recommended by Snowflake to resolve the issue(s), is currently being tested. Provided that there are no unexpected issues found, our developers will proceed with merging the change and then it will most probably be delivered as a hotfix.
Unfortunately, there is no specific ETA at the moment, but our developers are working hard so that it will be delivered as soon as possible. I will inform you as soon as there are more details available.
We are sorry for the inconvenience caused and would like to thank you for your patience and understanding.
Branislav Slávik
06/04/2025, 4:40 PMHello @CaS,
I would like to inform you that the latest driver recommended by Snowflake was deployed and the issue should be fixed now.
With that in mind, could you please verify and let us know if everything is working as expected?
c
CaS
06/06/2025, 2:19 PMWe are still having the same issue as of this morning
b
Branislav Slávik
06/06/2025, 4:09 PMThank you for letting us know and sharing the information with us.
I would like to let you know that our developers are looking into the issue further.
They discovered a "connection leak" that resulted in depletion of available connection in the pool. The fix is ready and should be released / deployed either today or on Monday next week.
With that in mind, please continue with the monitoring and I will check back with you on Wednesday if there is no update from your side until then.
c
CaS
06/07/2025, 12:34 PMThank you
2 Views