Hey @Dave,

Just want to ask some basic questions here to cover our basis, but when you go to the DataSource(DS) details page, did you confirm(and double check) all the IP Addresses are allowed/trusted to access the database?

Cheers,

Hi Germany, ty for your response, yes all this has been double-checked and DB has no Ip restrictions. And it works 5-10% of the time now with no error, so for sure not a credential /IP issue as this would never work,

From all the research i made into those errors, it seems to be on skuid’s side.

Migrating to public thread for visibility and update.

After looking at our logs, we have a few ideas on what is going on, but to be sure, we need to verify the pool size and connection timeout to make sure it’s set properly for the amount of data he’s are querying.

Two things could be happening:

1. The pool size may be too small for the amount of data being queried.


2. Because of the amount of data being queried, the DB is timing out and not staying active, terminating the connection.

Thank you Jeremy,

Actually, your questions made me go over all with the Dev again, and it seems it was a proxy issue. Once we disabled it, everything went back to normal

We had set that proxy because of the limited # of simultaneous connections we could have, so we will work on fixing that.

Thank you for throwing us in the right direction!

That’s awesome, and I’m glad you were able to fix it!