Symptoms

We are trying to adjust the max pool settings as we are getting numerous connection timeout issues as described here: http://help.k2.com/kb000209. However, because our connection strings are encrypted, I am unsure where to place this configuration entry.
 

Diagnoses

http://help.k2.com/kb001637
 

Resolution

With the release of K2 4.6.9 the 'SourceCode.Workflow.Runtime.Management.config' has been consolidated into the 'K2HostServer.exe.Config'. To decrypt the connection strings:

1. Stop the K2 blackpearl server service

2. Backup the "K2HostServer.exe.config" file (usually located at 'C:Program Files (x86)K2 blackpearlHost ServerBin')

3. Create a directory on the C: drive such as "C:K2Config"

4. Make 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

8. Run 'aspnet_regiis.exe -pdf "connectionStrings" "C:K2Config"'

9. This command will decrypt the encrypted 'connnectionStrings' section

10. Add the "Max Pool Size=1000000" entry to the appropriate connection string this may depend on if you have 14 K2 DBs or a single consolidated DB

11. To re-encrypt this web.config file, rename it back to 'K2HostServer.exe.config'

12. Copy it back to 'C:Program Files (x86)K2 blackpearlHost ServerBin'

13. Starting the K2 blackpearl server service will re-encrypt these connection strings