AsyncService - Config database error - Invalid value for Max Pool Size

(0) Share

Report

Posted on by MLarsen

508

Hello,

I have a CRM server where this error messages is displayed every 10min or so. Starting to wonder if it has something to do with a problem I am having with workflow stuck in status 'waiting for resources'...

--------------------------------------------------------

Host SERVER.MSCRMAsyncService$maintenance.2ee29efb-d4d1-437d-a9e2-3b2d83de87e3: a config database error occured. Exception: System.ArgumentException: Invalid value for key 'Max Pool Size'.
at System.Data.SqlClient.SqlConnectionStringBuilder.set_MaxPoolSize(Int32 value)
at Microsoft.Crm.MultiOrgConnectionSupportBehavior.HandlePoolSizes(SqlConnectionStringBuilder builder)
at Microsoft.Crm.MultiOrgConnectionSupportBehavior.HandleInitialCatalog(SqlConnectionStringBuilder builder, Guid organizationId)
at Microsoft.Crm.CrmSqlConnectionManager.CreateConnection(Boolean enableMars)
at Microsoft.Crm.CrmDbConnection.GetCreateConnection()
at Microsoft.Crm.CrmDbConnection.GetCreateAndOpenConnection()
at Microsoft.Crm.CrmDbConnection.Open()
at Microsoft.Crm.Asynchronous.JobDataAccess.ExecuteSqlOrganizationScopeAndProcessRecords(IDbCommand command, Guid organizationId, RecordProcessor recordProcessor)
at Microsoft.Crm.Asynchronous.JobDataAccess.RetrieveSqlServerName(Guid orgId)
at Microsoft.Crm.Asynchronous.JobDataAccess.UpdateJobTargetServer(AsyncJob job)
at Microsoft.Crm.Asynchronous.JobDataAccess.GetNextJob(IList`1 orgsAvailableForMaintenance, DateTime startCycleTime, Int32 maxJobsToReturn)

*This post is locked for comments

I have the same question (0)

All responses (11)

Answers (0)

Suggested answer

Shidin Haridas 3,497 on at

Like (0)

Report

Can you try restarting the Async service? & do an IIS Reset as well.

Was this reply helpful? Yes No
MLarsen 508 on at

Like (0)

Report

Hello Shidin.

I have tried to restart the AsyncService and also did a restart of the whole server, did not help. The error message is still turning up in the event log.

Was this reply helpful? Yes No
Daniel Wikell 2,360 on at

Like (0)

Report

Hi

Can you locate the config value in question and see what it is currently set to? If you post the location and your current value here we can always compare it to another CRM installation to see what a healthy one should look like.

Was this reply helpful? Yes No
Suggested answer

Ben Thompson 6,350 on at

Like (0)

Report

Check the connection string that the Async service on that server uses to connect to the SQL server database. I suspect there is a typo within the connection string. For reference the value for Max Pool Size should be greater than 0 and higher than the Min Pool Size value (if set)

Given that the error message is only appearing every 10 minutes I suspect the Async service on that server isn't actually doing anything at all so you could re-configure or remove and reinstall it if you can't find the connection string.

Was this reply helpful? Yes No
MLarsen 508 on at

Like (0)

Report

You mean 'Max Pool Size' ? Can't say I know where to find that.

Was this reply helpful? Yes No
MLarsen 508 on at

Like (0)

Report

Where can I locate this connection string exactly? :) I found the DeploymentProperties table on the SQL but there is no value named 'Max Pool Size' or anything like that.

Was this reply helpful? Yes No
Daniel Wikell 2,360 on at

Like (0)

Report

Since in your error message it complains about a "config database error" I would suspect the setting you are looking for is located somewhere inside the MSCRM_CONFIG database as a data row.

Was this reply helpful? Yes No
MLarsen 508 on at

Like (0)

Report

The only thing I can find regarding 'Max Pool Size' is SharedDBConnectionPoolMaxPoolSize column under the table DeploymentProperties on MSCRM_CONFIG database:

But this value is also like this on another server I have, and I guess the value -1 is unlimited.

Was this reply helpful? Yes No
Daniel Wikell 2,360 on at

Like (0)

Report

Alright so then it's probably not it.

Digging further in your stacktrace, the last method before the exception occurrs is "System.Data.SqlClient.SqlConnectionStringBuilder.set_MaxPoolSize".

This does indicate that the problem lies in the connection string that the async service uses to connect TO the config database, and not a value in the config database itself, which I notice now is actually what Ben Thompson said in the first place.

The config file for the async service is likely located next to the executable for the service which is usually located at "C:\Program Files\Microsoft Dynamics CRM\Server\bin\".

Check "CrmAsyncService.exe.config" file there and see if you can find any connection string there that either looks iffy or is missing a Max Pool Size property.

Was this reply helpful? Yes No
MLarsen 508 on at

Like (0)

Report

Hello and thank you for your answer. I have already looked there :) There is nothing in that config file that has to do with connection to the database and max pool size as I can see. There is only publicKeyTokens and version numers in that config file.

Was this reply helpful? Yes No