Unable to send email job from marketing efforts – process keep getting stuck at End Initialize BBDM Lists and it creates server performance

Unable to send email job from marketing efforts – process keep getting stuck at End Initialize BBDM Lists and creating server performance on both BBIS and CRM.
The client was able to send the same email to internal 10 recipients.
We asked the client to recreate marketing effort and they did, but the new marketing effort has the same issue.

The client is also experiencing the performance issue as soon as they start this job.
For example: Getting this error when trying to access CRM or BBIS:

The section could not be loaded. Unable to connect to database 'SITE ID'. The error was: Timeout expired. The timeout period elapsed prior to obtaining a connection from the pool. This may have occurred because all pooled connections were in use and max pool size was reached. Verify the following information: 1. The item in the web.config <connectionStrings> section named 'SITE ID' is a valid connectionstring. 2. The account that the web service is running under is a member of the BBAPPFXSERVICEROLE database role in the database specified in the connection string. 3. The SQLServer service is running on the server indicated in the connection string. 4. The max pool size is set correctly in the connection string for this server. The current setting is max pool size=250
Download and install the latest patch which contains all fixes from previous patches. If you are running an older version, download and install the latest version and then the patch

Environment

 Blackbaud CRM
 4.0
 4.0
 4.10.180.1615

Was this article helpful?


Thanks for your feedback! Did this solve your issue?

Comments (optional):


Thanks for your feedback!
We're glad it was helpful but sorry it didn’t solve your issue. If you need assistance, click Chat with Support below.
We’re sorry to hear that. Please tell us why.

 I don't like how this works.

 The answer is confusing.

 The answer didn't match what I was searching for.

Additional Comments (optional):


Thanks for your feedback! If you need assistance, click Chat with Support below.
Thanks for your feedback. Help us make our products even better by sharing details in our Idea Banks or our online Community.
Thanks for letting us know. We'll work on clarifying the information in the article. If you need assistance, click Chat with Support below.
Thanks for letting us know. We'll work on updating the search engine to return more relevant results.