time-out > DotNetNuke Module Product Forums > Data Springs Inc.

Unanswered Active Topics

Forums Search

Subject: time-out

Email me when someone replies to this thread.

You are not authorized to post a reply.

Author

Messages

Ed Unrau
Posts:75

river guide

07/01/2009 4:13 PM
After I clicked finish, it said import scheduled and nothing happened for a bit, then a little while later, I guess when the import was scheduled for, I get this error when browsing to any page other than the homepage of the site: 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 and now when I try to go to the site at all I just get a page load error It was a very large number of users importing so I know now to have scheduled it to do a few at a time but first how do I fix this and fast??

Ed Unrau
Posts:75

river guide

07/01/2009 4:30 PM
I updated my maxRequestLength and my requestLengthDiskThreshold to 18192 as instructed on this page http://www.dotnetnuke.com/Community/Forums/tabid/795/forumid/107/postid/269383/scope/posts/Default.aspx and now I can at least get to my homepage again but it still gives the timeout when trying to browse anywhere else + I cant log into the site cuz it times out. I read somewhere that you need to disable the scheduler from the database in order to fix this? how do I do that?

David To
Posts:2102

river guide

07/01/2009 4:58 PM
HI Ed, you go to HOST / SCHEDULE find the InteractiveUserImport scheduler, edit it and disable it. Also, check how often and it runs as well. Make sure to set a reasonable time, such as 1 day run and 60 minute retry frequency or something to this effect. -- David

Ed Unrau
Posts:75

river guide

07/02/2009 7:15 AM
k well the problem seemed to fix itself yesterday after I posted my last post the site went back to normal, but it didnt import any users, I think it might have done a few but thats it. So I went ahead and deleted the userimport item from the schedule and ran the module again, this time checking the option to limit the amount imported per scheduled instance to 100 instead of over 3000... but now it's not creating an item in the schedule anymore.. so I'm guessing I shouldnt have done that? pls advise thx

David To
Posts:2102

river guide

07/02/2009 8:32 AM
HI,Ed, so you deleted the user import item from the HOST / SCHEDULE? If so, then the import you that define in IUI page cannot be processed. You can manually add it back by going going there, adding a new schedule, using these names: Full Class Name and Assembly: DataSprings.DNN.Modules.UserImport.UserImportProcess, DataSprings.DNN.Modules.UserImport Object Dependencies: DataSprings_UserImport For everything else, you can choose what you want. -- David

Ed Unrau
Posts:75

river guide

07/02/2009 8:56 AM
I did that and the site instantly timed out again.. how do I make sure it's only doing the 100 per scheduled instance and not the way I ran the module the first time?

David To
Posts:2102

river guide

07/02/2009 9:00 AM
Okay, let's clear the SQL table of any past entries. Go to HOST / SQL and type in: truncate table datasprings_userimport be sure to check the box "Execute as script" and then hit the link "execute". -- David

Ed Unrau
Posts:75

river guide

07/06/2009 10:10 AM
Ok. I plan on doing this and trying the import again later tonight in case it crashes again. With 3000+ users, what do you recommend for the number of users to import at once and the schedule time lapse & retry settings and such?

David To
Posts:2102

river guide

07/06/2009 2:13 PM
Hi, I would suggest importing 250 users per scheduler instance and have the scheduler to run every 60 minutes with a retry frequency of 15 minutes. -- David

You are not authorized to post a reply.