Symptoms
We are getting the error when we try to refresh smart object sql instance:
"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."
Diagnoses
N/A
Resolution
Please try the following to expand your connection pool:
1. Go to [Program Files]K2 blackpearlHost ServerBin
2. Create a backup of "K2HostServer.exe.config"
3. Create a directory on the C: drive such that "C:K2Config"
4. Copy a copy of the "K2HostServer.exe.config" to "C:K2Config"
5. Rename it to "web.config"
6. Run CMD Prompt in Administrator Mode:
7. Run 'cd C:WindowsMicrosoft.NETFramework64v4.0.30319' to change directory to this framework version. If you are using another version of .NET Framework, go to the folder representing the latest .NET Framework version you have in C:WindowsMicrosoft.NETFramework64.
8. Run the following to decrypt connection strings:
aspnet_regiis.exe -pdf "connectionStrings" "C:K2Config"
9. Open "web.config"
10. Search for "andltconnectionStringsandgt". You should see the connection string for HostserverDB below. It should look something like this:
andltadd name="HostserverDB" connectionString="Data Source=DLXInitial Catalog=K2integrated security=sspiPooling=True" providerName="K2BLACKPEARL" /andgt
11. Add "Max Pool Size=200" to connectionString. It should look something like this:
andltadd name="HostserverDB" connectionString="Data Source=DLXInitial Catalog=K2integrated security=sspiPooling=TrueMax Pool Size=200" providerName="K2BLACKPEARL" /andgt
12. Save the changes
13. Rename "web.config" in C:K2Config to "K2HostServer.exe.config"
14. Stop your K2 blackpearl service
15. Copy the "K2HostServer.exe.config" in C:K2Config to [Program Files]K2 blackpearlHost ServerBin. Replace the existing K2HostServer.exe.config
16. Start your K2 blackpearl service
17. Test your SmartObject using SmartObject Service Tester again
