PurgeUsers - SNINativeMethodWrapper.SNIPacketGetConnection error
Last Post 05-07-2010 02:04 AM by Scott Prohaska. 2 Replies.
AddThis - Bookmarking and Sharing Button
Author Messages
Scott ProhaskaUser is Offline
Posts:5
Avatar

--
05-06-2010 09:07 AM

    Getting error with Purge Users -- it used to work.  Am now getting the following error.  I am trying to purge twice the number of users as before - about 2500.  I upped the execution timeout to 450 -- still no joy.  Any ideas, suggestions, or even solutions?! 

    Thanks,

    Scott

    AssemblyVersion: 5.4.1
    PortalID: 5
    PortalName: St. Edward-Epiphany School Alumni Portal
    UserID: 1
    UserName: host
    ActiveTabID: 389
    ActiveTabName: DataSprings Admin
    RawURL: /alumni/Home/DataSpringsAdmin/tabid/389/ctl/PurgeUsers/mid/1488/Default.aspx
    AbsoluteURL: /Default.aspx
    AbsoluteURLReferrer: http://www.seeschool.com/alumni/Hom...fault.aspx
    UserAgent: Mozilla/4.0 (compatible; MSIE 8.0; Windows NT 6.0; Trident/4.0; GTB6.4; SLCC1; .NET CLR 2.0.50727; Media Center PC 5.0; .NET CLR 3.5.21022; InfoPath.2; .NET CLR 3.5.30729; OfficeLiveConnector.1.4; .NET CLR 3.0.30729; OfficeLivePatch.1.3; .NET4.0C; .NET4.0E)
    DefaultDataProvider: DotNetNuke.Data.SqlDataProvider, DotNetNuke.SqlDataProvider
    ExceptionGUID: 20b0d542-5c47-404a-a386-949d644f10a8
    InnerException: Thread was being aborted.
    FileName:
    FileLineNumber: 0
    FileColumnNumber: 0
    Method: .SNINativeMethodWrapper.SNIPacketGetConnection
    StackTrace:
    Message: System.Threading.ThreadAbortException: Thread was being aborted. at SNINativeMethodWrapper.SNIPacketGetConnection(IntPtr packet) at System.Data.SqlClient.TdsParserStateObject.ProcessSniPacket(IntPtr packet, UInt32 error) at System.Data.SqlClient.TdsParserStateObject.ReadSni(DbAsyncResult asyncResult, TdsParserStateObject stateObj) at System.Data.SqlClient.TdsParserStateObject.ReadNetworkPacket() at System.Data.SqlClient.TdsParserStateObject.ReadBuffer() at System.Data.SqlClient.TdsParserStateObject.ReadByte() at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) at System.Data.SqlClient.SqlDataReader.ConsumeMetaData() at System.Data.SqlClient.SqlDataReader.get_MetaData() at System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString) at System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, DbAsyncResult result) at System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method) at System.Data.SqlClient.SqlCommand.ExecuteScalar() at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(SqlConnection connection, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, CommandType commandType, String commandText, SqlParameter[] commandParameters) at Microsoft.ApplicationBlocks.Data.SqlHelper.ExecuteScalar(String connectionString, String spName, Object[] parameterValues) at DotNetNuke.Security.Membership.Data.SqlDataProvider.GetUserCountByPortal(Int32 portalId) in C:\CCNet_Builds\DotNetNuke_5_Maintenance\WorkingDirectory\Library\Providers\MembershipProviders\DataProvider\SqlDataProvider.vb:line 127 at DotNetNuke.Security.Membership.AspNetMembershipProvider.GetUserCountByPortal(Int32 portalId) in C:\CCNet_Builds\DotNetNuke_5_Maintenance\WorkingDirectory\Library\Providers\MembershipProviders\AspNetMembershipProvider\AspNetMembershipProvider.vb:line 932 at DotNetNuke.Entities.Users.UserController.GetUserSettings(Hashtable settings) in C:\CCNet_Builds\DotNetNuke_5_Maintenance\WorkingDirectory\Library\Entities\Users\UserController.vb:line 188 at DotNetNuke.Entities.Users.UserController.GetUserSettings(Int32 portalId) in C:\CCNet_Builds\DotNetNuke_5_Maintenance\WorkingDirectory\Library\Entities\Users\UserController.vb:line 869 at DotNetNuke.Entities.Modules.UserModuleBase.GetSetting(Int32 portalId, String settingKey) in C:\CCNet_Builds\DotNetNuke_5_Maintenance\WorkingDirectory\Library\Entities\Modules\UserModuleBase.vb:line 81 at DotNetNuke.Entities.Profile.ProfilePropertyDefinition.Initialize() in C:\CCNet_Builds\DotNetNuke_5_Maintenance\WorkingDirectory\Library\Entities\Profile\ProfilePropertyDefinition.vb:line 357 at DotNetNuke.Entities.Profile.ProfilePropertyDefinition..ctor(Int32 portalId) in C:\CCNet_Builds\DotNetNuke_5_Maintenance\WorkingDirectory\Library\Entities\Profile\ProfilePropertyDefinition.vb:line 78 at DotNetNuke.Entities.Profile.ProfilePropertyDefinition.Clone() in C:\CCNet_Builds\DotNetNuke_5_Maintenance\WorkingDirectory\Library\Entities\Profile\ProfilePropertyDefinition.vb:line 381 at DotNetNuke.Entities.Profile.ProfileController.GetPropertyDefinitionsByPortal(Int32 portalId, Boolean clone) in C:\CCNet_Builds\DotNetNuke_5_Maintenance\WorkingDirectory\Library\Entities\Profile\ProfileController.vb:line 523 at DotNetNuke.Security.Profile.DNNProfileProvider.GetUserProfile(UserInfo& user) in C:\CCNet_Builds\DotNetNuke_5_Maintenance\WorkingDirectory\Library\Providers\MembershipProviders\DNNMembershipProvider\DNNProfileProvider.vb:line 118 at DotNetNuke.Entities.Users.UserInfo.get_Profile() in C:\CCNet_Builds\DotNetNuke_5_Maintenance\WorkingDirectory\Library\Entities\Users\UserInfo.vb:line 283 at DotNetNuke.Entities.Users.UserController.FillUserInfo(Int32 portalId, IDataReader dr, Boolean closeDataReader) in C:\CCNet_Builds\DotNetNuke_5_Maintenance\WorkingDirectory\Library\Entities\Users\UserController.vb:line 565 at DotNetNuke.Entities.Users.UserController.FillUserCollection(Int32 portalId, IDataReader dr, Int32& totalRecords) in C:\CCNet_Builds\DotNetNuke_5_Maintenance\WorkingDirectory\Library\Entities\Users\UserController.vb:line 466
    Source:
    Server Name: GENERIC71

    David ToUser is Offline
    river guide
    river guide
    Posts:2719
    Avatar

    --
    05-06-2010 09:43 AM

    HI, what do you have in your web.config file?

    The original web.config that installs with DNN 4 has this section:

    httpruntime usefullyqualifiedredirecturl="true" maxrequestlength="8192" requestlengthdiskthreshold="8192 /httpruntime>

    I added the executionTimeout parameter with a "3600" value (1 hour timeout) and the purge worked great! Took about 3 minutes.

    httpruntime usefullyqualifiedredirecturl="true" maxrequestlength="1048576" requestlengthdiskthreshold="24576" executiontimeout="3600" /httpruntime
    -- David

    Scott ProhaskaUser is Offline
    Posts:5
    Avatar

    --
    05-07-2010 02:04 AM

    Upping the timeout to 1000 did the trick. 

    THanks,

    Scott



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