• State Not Answered
  • Locked Locked
  • Replies 0 replies
  • Subscribers 93 subscribers
  • Views 1200 views
  • Users 0 members are here
Options
Related
This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Getting error in processes when multiple sql processing jobs are getting executed

ruchita.mantri
over 5 years ago

Hi,

I am getting below error when 200-300 sql processing jobs are getting executed in parallel. 

[810143] Database error 0: Timeout attempting to open the connection. The time period elapsed prior to attempting to open the connection has been exceeded. This may have occurred because of too many simultaneous non-pooled connection attempts.
[System.TimeoutException] Timeout attempting to open the connection. The time period elapsed prior to attempting to open the connection has been exceeded. This may have occurred because of too many simultaneous non-pooled connection attempts.

What can be the cause and how to resolve this?