Hi there,

I am in middle of developing a website using dnn 4.9 and Oracle DP 4.9. I have been working on this for a couple of months now, but suddenly I have hit a connection pooling problem. It all started when I was trying to upload a 20 MB zip file. I first got an error message about the file size so I changed the default size limit in the web.config file from 8MB to 200MB (204800) because I have another file which is 151 MB. Due to the change in the config file I restarted IIS, but since then when I have tried to logon but have been receiving the error.

Error message - 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.

I would appreciate any help on this.

Thanks,

Rajesh

Sanjay - Yes I reset my Oracle db. I noticed from the session browser that there were about 100 inactive connections. No I am unable to view any page - get the same error. Yes I tried resetting the value back to 8 MB just to prove that that was not the isse. Oracle version is 10.2.0. There are no custom values set for intiliazation. I have had a look at the session browser and it appears that the inactive session are executing the dnn_addsearchitem procedure.

Any ideas?

Rajesh

Thanks very much Sanjay. That did the trick. The 'Enabled' value where objectdependencies are ScheduleHistory and SearchEngine was set 1. I set these to 0 and can now login fine.