Great Ideas. Always Flowing.

We are not happy until you are happy. Client satisfaction guaranteed. Whatever your needs and requirements, we have the skills and resources for the job!

Quick login...

Or... now make it easy with Facebook Integration
Connect via Facebook

Top Sellers

Dynamic Registration 4.0

Frustrated over the lack of customization for your user's registration fields? Dynamically setup your DNN Portal with custom registration fields, layout, questions, and other core integration options......

Ultra Video Gallery 4

Ultra Video Gallery is a brother product of Ultra Media Gallery, UVG allows you to upload videos in various format and automatically encode them to flv or H264 format, you also can add videos from internet or record live videos from your webcam.

XMod Pro 2.7 - Forms and Views for Databases

Build high performance, completely customizable data-entry forms and views driven by your DNN and external databases. New built-in tools make it a snap to quickly create data entry forms, data views, and even database tables. Plus, add your own HTML, CSS, Javascript, SQL commands, stored procedures,

Smith Shopping Cart v3.88

The most advanced DotNetNuke shopping cart on the planet. Easy to use e-Commerce, Secure Shopping Cart Software and SEO friendly. B2C / B2B Ecommerce Sites.

Event Calendar and Registration 4.0

One stop solution for events calendar and events registration! FREE DOWNLOAD is available now!

DNN Modules

Forums > Product Discussion - DotNetNuke Modules > Interactive User Import
time-out
Last Post 07-06-2009 12:13 PM by David To. 8 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
Ed UnrauUser is Offline
river guide
river guide
Posts:76
Avatar

--
07-01-2009 02: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 UnrauUser is Offline
    river guide
    river guide
    Posts:76
    Avatar

    --
    07-01-2009 02:30 PM
    I updated my maxRequestLength and my requestLengthDiskThreshold to 18192 as instructed on this page http://www.dotnetnuke.com/Community...fault.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 ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    07-01-2009 02: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 UnrauUser is Offline
    river guide
    river guide
    Posts:76
    Avatar

    --
    07-02-2009 05: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 ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    07-02-2009 06: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 UnrauUser is Offline
    river guide
    river guide
    Posts:76
    Avatar

    --
    07-02-2009 06: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 ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    07-02-2009 07: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 UnrauUser is Offline
    river guide
    river guide
    Posts:76
    Avatar

    --
    07-06-2009 08: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 ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    07-06-2009 12: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.

    Forums > Product Discussion - DotNetNuke Modules > Interactive User Import
     
     

    Join our mailing list...

    Get current news and events the easy way
    Subscribe Me

    Recent Blogs...

     
    Copyright 2005 - 2011 by Data Springs, Inc.
     
  • film izle
  • 720 izle
  • film
  • sinema izle
  • film makinesi
  • T�rk�e dublaj film
  • film izle
  • film izle
  • baglan film izle
  • sinema izle
  • 1080 film izle
  • film mercegi