Access Denied & Session Timeouts
Printed From: Web Wiz Forums
Category: Web Wiz Web App Support Forums
Forum Name: Web Wiz Forums
Forum Description: Support forum for Web Wiz Forums application.
URL: https://forums.webwiz.net/forum_posts.asp?TID=28975
Printed Date: 01 April 2026 at 4:05pm Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com
Topic: Access Denied & Session Timeouts
Posted By: MaximeRoy77
Subject: Access Denied & Session Timeouts
Date Posted: 21 November 2010 at 8:45pm
|
My logged in members are having some issues with permissions and login.
The only thing that the LOGGING FEATURE might indicate the cause is this line
2010-11-21 14:35:15 - 123.125.156.136 - Guest - ERROR - File: functions_session_data.asp - Error Details: err_SQLServer_getSessionData()_save_new_session_data - Microsoft OLE DB Provider for SQL Server - Violation of PRIMARY KEY constraint 'PK__tblSession__30CE2BBB'. Cannot insert duplicate key in object 'dbo.tblSession'.
That occurs many times a day.
SQLSession are ACTIVE.
Any clues why and if it's problematic ?
|
Replies:
Posted By: WebWiz-Bruce
Date Posted: 22 November 2010 at 5:20pm
There will be a fix for this problem in the next release.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: MaximeRoy77
Date Posted: 22 November 2010 at 5:45pm
|
In the mean time I get complaints from long time members (10 years) like this:
Forum: Internal news Topic: *** FORUM UPGRADE / OFFLINE SOON *** Posted By: The T
This forum is much worse than it used to be. Every two posts I get the stupid "you don't have permission" message.
Is frustrating.
Should I revert to NON-SessionSQL ? Standard !
PS: When the new release ?
|
Posted By: MaximeRoy77
Date Posted: 22 November 2010 at 6:01pm
|
Can i revert back to 9.53 from 9.69 ?
|
Posted By: MaximeRoy77
Date Posted: 23 November 2010 at 2:25pm
My members keep on receiving this, either on SQLSessions or Applications variables.
Tell me how can I fix it ?
Thanks
|
Posted By: MaximeRoy77
Date Posted: 23 November 2010 at 3:06pm
I am starting to think that WEBWIZ is not recommended for over 100 active users, even on SQL Server
|
Posted By: 123Simples
Date Posted: 23 November 2010 at 7:20pm
MaximeRoy77 wrote:
I am starting to think that WEBWIZ is not recommended for over 100 active users, even on SQL Server  |
That's not true. Web Wiz will run comfortably on that amount of users, and in actual fact, despite the earlier comments, I myself have not had any issues like you mention. Have you actually modified any files, or have you started with a fresh upload? I'm curious, as to why the problems have presented themselves on your forum. Can you PM me your actual forum address so I may look myself?
------------- http://www.123simples.com/" rel="nofollow - Visit 123 Simples Web Design
|
Posted By: MaximeRoy77
Date Posted: 23 November 2010 at 9:41pm
|
I'd like to believe that, but since the 9.69 upgrade , it's been quite difficult to believe again....
|
Posted By: WebWiz-Bruce
Date Posted: 24 November 2010 at 9:45am
|
Web Wiz runs fine on forums where there are 100 active users, we have many forums hosted here on our network including one for Microsoft that have over 300 to 400 active users and never have any issues like you mention. 100 active users is relatively low.
The post I made earlier relating to the error you reported in your log files has nothing to do with the session error that you are now reporting.
Session errors like you are reporting can happen:-
1. The IIS Application pool is set to multiple worker process, make sure you are using a single worker process.
2. The IIS Application Pools is recycling to often. Check that it has enough resources and recyles once a day at a quite time on your forum, like 6am in the morning.
3. Another application is interfering with Web Wiz Forums. Place web wiz forums it's own application
4. Cookies are not being written correctly. Edit the includes/setup_options_inc.asp to change the cookie path
5. The SQL Server has incorrect time settings or is in a different time zone. A fix for SQL Server being in a different time zone will be in the next release, until then check the time settings on the web and database servers are the same.
Session errors are usually a result of incorrect server or forum setup, or modifications to the code.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: StarDust
Date Posted: 24 November 2010 at 9:58am
MrTWS wrote:
MaximeRoy77 wrote:
I am starting to think that WEBWIZ is not recommended for over 100 active users, even on SQL Server  |
That's not true. Web Wiz will run comfortably on that amount of users, and in actual fact, despite the earlier comments, I myself have not had any issues like you mention. Have you actually modified any files, or have you started with a fresh upload? I'm curious, as to why the problems have presented themselves on your forum. Can you PM me your actual forum address so I may look myself?
|
I completely agree with MrTWS. WWF used to run smoothly with hundreds of active users with thousands of regular users.
But this version might not be as smooth as we are used to with WWF. I have a very little suspicion about IIS7, 64 bit systems.
I am a little irregular now-a-days but my experience with wwf 9.69 tells me there had been a major change somewhere in application variables. there, something sometime isn't going smoothly.
WebWiz-Bruce wrote:
5. The SQL Server has incorrect
time settings or is in a different time zone. A fix for SQL Server being
in a different time zone will be in the next release, until then check
the time settings on the web and database servers are the same.
Session errors are usually a result of incorrect server or forum setup, or modifications to the code. |
This could also be another issue.
But after all these banters, I assure you, no one will find a better reputation in ASP forum than WWF
------------- http://board.ebizbd.net/"> Tips, mods and skins for WWF v9.x
|
Posted By: MaximeRoy77
Date Posted: 24 November 2010 at 1:07pm
|
Thanks WebWiz-Bruce for the helpful reply. I want to trust WWF again , I've been a faithful client since version 7 but this version caused me more troubles than past upgrades. Withtout mentionning the major change in the email notifications logic that drive members nuts.
About the timeouts thing: I've set the recycle of the pool at 6:00 AM, before your post , I tested it with NO RECYCLE, all the rest is oK: 1 work. process, 1 application for the forum.
Since it's an random problem, I don't think the cookie path or a code modz that can cause it.
Question: Does the forum with 300 active users from MS runs on SessionSQL or Application variables ?
I'll keep you posted
Thanks,
Max
|
Posted By: billd3
Date Posted: 24 November 2010 at 2:23pm
MaximeRoy77 wrote:
My members keep on receiving this, either on SQLSessions or Applications variables.
Tell me how can I fix it ?
Thanks
|
I have to admit - I've seen this a few times since the upgrade to the latest! In fact, I find myself logged out now and then as well - on 3 different computers, Firefox and IE, so it's not the computer or browser. I've tried to send a PM, and hit send, the PM is lost as it says "only users with...." and I start over and it sends that time. I answer a post in the forum, the post gets lost and I get the "only users with" message, I check, I'm logged in, and I try again and it posts. This am just minutes ago, I came back from a trip to the coffee pot - side-tracked it took 20 minutes, to find I was logged out! I logged in again. When I read messages, I find that if another post comes in anywhere, the messages I've just read now show as new unread messages.
So: with PM or forum posts - at times I get the error message quoted above. The post is lost, I start over and it goes. At times I get logged out, and I have to log in again. I use the "new posts" icon and see the new posts since my last visit or login, and I go down the line and read them......... then a few minutes later, there's a new post someone makes and ALL the posts I just read suddenly show up as new/unread since last visit - bold again.
I'm not sure how many see it besides me, but I see one or all of the above daily. I do know that several folks have "complained" about the read messages suddenly appearing to them as new or unread. That issue is pretty big for us as far as folks seeing it, including myself.
All this SINCE the upgrade.
------------- BillD
http://theamcpages.com
http://theamcforum.com
|
Posted By: WebWiz-Bruce
Date Posted: 24 November 2010 at 3:52pm
|
Now it's getting confusing with people jumping in about different issues.
Session are stored in the database, read/unread posts due to the amount of data are stored in application variables.
Version 9.69 has been out for about 5 months now and is running on many large forums where sessions stored in the database are used without any of the problems both of you mention.
Those that seem to have issues like you mention all seem to have one thing in common. They have modified the forum.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: WebWiz-Bruce
Date Posted: 24 November 2010 at 4:17pm
I have been looking at your forum billd3 and it appears that your website is wanting to use more than 300MB of memory, which is causing the application pool to recycle which would reset the application variables for read/unread posts. You also mentioned before that you use the quick login rather than the full login page. The quick login does not use cookies and so when the application recycles it would mean that you would often need to log back in.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
Posted By: billd3
Date Posted: 24 November 2010 at 4:44pm
I've been using the full login for the last 2 or 3 weeks - I've not used the quick login every since you explained the differences...........
As for the "confusion" - sorry, but I just wanted to say "hey, I see that same error too - is it related?"
------------- BillD
http://theamcpages.com
http://theamcforum.com
|
Posted By: MaximeRoy77
Date Posted: 24 November 2010 at 6:40pm
|
Mr. Bruce,
so if we did not modified the code and the recycle worker process is every 24h and we still have persmissons and timeouts, it's a sign that we need to move to the SQL-Stored sessions ? And this should fix ?
|
Posted By: WebWiz-Bruce
Date Posted: 24 November 2010 at 7:06pm
|
The topic has been locked as with to many people jumping in it's hard to follow the topic.
If each person with an issue could start a new topic as each of you are talking about different issues which are around the same type of thing but not related.
------------- https://www.webwiz.net/web-wiz-forums/forum-hosting.htm" rel="nofollow - Web Wiz Forums Hosting https://www.webwiz.net/web-hosting/windows-web-hosting.htm" rel="nofollow - ASP.NET Web Hosting
|
|