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 tProgram 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 tProgram 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