FTP Sql Timeout

rated by 0 users
This post has 5 Replies | 1 Follower

Not Ranked
Posts 8
Points 130
cincy_josh Posted: Wed, Mar 23 2005 9:22 AM
Anyone seen this and have any clue on how to fix it?:
/23/2005 10:14:44 AM : Exception occurred in Server.ThreadPool_WaitCallback
    Type: SqlException
    Message: Timeout expired.  The timeout period elapsed prior to completion of the operation or the server is not responding.
     Source: .Net SqlClient Data Provider
      Stack:    at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader()
   at CommunityServer.Data.SqlCommonDataProvider.GetCategories(Int32 forumID, CategoryType catType)
   at CommunityServer.Galleries.FtpServer.Components.OobPostCategories.GetCategories(String applicationKey, Boolean useCache)
   at CommunityServer.Galleries.FtpServer.Components.Directories.GetCurrentListingItems(FtpContext context, GalleryDirectory directory)
   at CommunityServer.Galleries.FtpServer.Components.Directories.GetDirectoryListing(FtpContext context, GalleryDirectory directory)
   at CommunityServer.Galleries.FtpServer.Components.CommandProcessor.ᐁ(FtpContext )
   at CommunityServer.Galleries.FtpServer.Components.CommandProcessor.ProcessCommand(FtpContext context, String command)
   at CommunityServer.Galleries.FtpServer.Components.Server.ᐁ(Object )
  • | Post Points: 35
Top 10 Contributor
Posts 5,284
Points 49,035
CS Developers
Doh, I pasted and hit send too quick.  That URL has a new version of a sproc that fixes some inefficiencies.  Run it and you should be good to go.
  • | Post Points: 35
Not Ranked
Posts 8
Points 130
Looks to be fixed.  Thank you so much!!!
-Josh
  • | Post Points: 5
Top 500 Contributor
Posts 48
Points 675
dvanbrunt replied on Tue, Mar 28 2006 9:28 PM
I think I'm getting the same error with FTP Server 2.0

2006-03-28 21:07:06,272 [6060] ERROR [] - Exception occurred in Server.ThreadPool_WaitCallback
Exception: System.Data.SqlClient.SqlException
Message: Procedure 'aspnet_Membership_GetPasswordWithFormat' expects parameter '@UpdateLastLoginActivityDate', which was not supplied.
Source: .Net SqlClient Data Provider
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream)
   at System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
   at Microsoft.ScalableHosting.Security.SqlMembershipProvider.GetPasswordWithFormat(String username, Int32& status, String& password, Int32& passwordFormat, String& passwordSalt, Int32& failedPasswordAttemptCount, Int32& failedPasswordAnswerAttemptCount, Boolean& isApproved)
   at Microsoft.ScalableHosting.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved, String& salt, Int32& passwordFormat)
   at Microsoft.ScalableHosting.Security.SqlMembershipProvider.CheckPassword(String username, String password, Boolean updateLastLoginActivityDate, Boolean failIfNotApproved)
   at Microsoft.ScalableHosting.Security.SqlMembershipProvider.ValidateUser(String username, String password)
   at Microsoft.ScalableHosting.Security.Membership.ValidateUser(String username, String password)
   at CommunityServer.FtpServer.Components.FtpContext.ValidateUser(String password)
   at CommunityServer.FtpServer.Components.CommandProcessor.?(FtpContext , String[] )
   at CommunityServer.FtpServer.Components.CommandProcessor.?(FtpContext , String[] )
   at CommunityServer.FtpServer.Components.CommandProcessor.ProcessCommand(FtpContext context, String command)
   at CommunityServer.FtpServer.Components.Server.?(Object )


I noticed your fix was for CS 1.1 and is fairly dated so I thought I'd see if there was another fix?
Thanks,
Dan

----------- Thanks, Dan
  • | Post Points: 20
Top 10 Contributor
Posts 5,284
Points 49,035
CS Developers
You error is completely different than this one, and I'd recommend creating a new thread so we don't keep sending emails the previous participants.  If you look at the "Message:" part of the errors, they are completely separate.  It looks like you did not install the Membership tables with CS, though either way, create a new thread.
  • | Post Points: 5
Page 1 of 1 (6 items) | RSS
Powered by Community Server (Commercial Edition), by Telligent Systems

Copyright© 2008 Telligent Systems Inc. All rights reserved
CommunityServer.com  •  Telligent.com