Assorted Frustrations

Keep forgetting how to add these so making a quick post on it.  Also remember to add it to another other folders that your 3rd party applications might need. Ex: IIS APPPOOL\{your app pool} IIS APPPOOL\DefaultAppPool http://stackoverflow.com/questions/7334216/iis7-permissions-overview-applicationpoolidentity http://serverfault.com/questions/81165/how-to-assign-permissions-to-applicationpoolidentity-account

When publishing site to live, trying to go to site gives a Server Error – Runtime Error.  Looking in the Application logs on the server  gave " The directory App_WebReferences/ is not allowed because the application is precompiled."   This was causing a bit of stress to a programmer in a our company since he tried to publish a change during business ours.   Solution http://stackoverflow.com/questions/9892646/how-publish-my-web-site When publishing the options that work are to have “Delete all existing files prior to publish”, and “Precompile during publishing” checked.  And “Exclude files from the App_Data” unchecked.

In our site there is a Shared (aka static) class that clears and then modifies a commonly used Table in a SQL Server Database.  The issue was that we would occasionally throughout the day get errors saying that "such and such record" could not inserted because it already exists.  We put in logging in between the statements to try and debug the thing since we could not seem to duplicate the error locally.  We noticed that in one example a single user had somehow two processes that were in lock-step through the function.  Both would clear the table, then both would attempt to insert the same data to it.  When the second process would attempt to insert it would blow up. Basically the resource is shared and needs to be locked so it is not modified by multiple users at the same time. http://stackoverflow.com/questions/34510/what-is-a-race-condition This article was very useful in creating the transaction that resolved my issue.  Ideally I would have pre...

Here is the issue. You have a form and someone double clicks the Submit button, and curiously enough you have two forms that were submitted!  My first thought was to disable the button on click with javascript, and then when the page loaded again the button would be enabled, but that was a no go.  Asp.Net does not fire events for disabled buttons. Went looking around and found a page that suggests using a variable to check to see if it was submitted or not in javascript.  As far as I can tell this is the best way of preventing this issue.  If they have javascript disabled however then it might be a problem though, but I am not even going to worry about those < 1% individuals. I changed their javascript function to not use the .Net markup inside the javascript to get the clientID.  I prefer making the ClientIDMode="Static" and having just pure javascript in the function.  var isSubmitted = false;     function preventMultipleSubmissions() ...

http://www.dnnsoftware.com/forums/forumid/198/threadid/527555/scope/posts/threadpage/2 Found out our app pool is recycling every minute or so due to unrealistically low virtual memory settings, and that was causing problems.  That Site Crawler seems to be used for when you use the site search functionality.  However I have disabled that Site Crawler in HOST->Scheduler which we do not use, and that got rid of the error.

So you can remotely connect to the server and see the restored database but when you click to expand it and view the tables it throws an error.   An error like not available in security context or such other such helpful information.  The problem in my case is that the user existed, and it had all the proper security.  I ran the change users proc on the user...or so I thought.  Actually on the upper left somehow the database selected was master. Good thing for co workers that can point out my mistake.  So, my fault I guess, although these orphaned users are strange... EXEC sp_change_users_login 'Auto_Fix', ' user ' http://dbadiaries.com/using-sp_change_users_login-to-fix-sql-server-orphaned-users

I had a call to a ExecuteNonQuery that was giving me the error "Parameter count does not match Parameter Value" count.  In my case this error is an incorrect error.  No matter how many times I compared the parameters from the ones in the procedure the number was always the same. In this case the procedure needed a DateTime parameter, but I was incorrectly trying to give it a string.  Then it would throw that error. Once I put the correct DateTime parameter type it worked properly.