Web Wiz Forums - Error in log file

Print Page | Close Window

Error in log file

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=29507
Printed Date: 01 April 2026 at 7:26am
Software Version: Web Wiz Forums 12.08 - https://www.webwizforums.com

Topic: Error in log file

Posted By: Ritchie
Subject: Error in log file
Date Posted: 06 July 2011 at 4:07am

In the log file periodically get an error message:

2011-07-06 05:19:10 - 217.69.134.176 - Гость - 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__79FBAC7C'. Cannot insert duplicate key in object 'tblSession'.
2011-07-06 05:20:26 - 217.69.134.176 - Гость - 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__79FBAC7C'. Cannot insert duplicate key in object 'tblSession'.

-------------
Чем дальше в лес, тем толще партизаны

Replies:

Posted By: WebWiz-Bruce
Date Posted: 06 July 2011 at 7:35am

What version are you using?

-------------
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: Ritchie
Date Posted: 06 July 2011 at 8:29am

Version 10.01

-------------
Чем дальше в лес, тем толще партизаны

Posted By: WebWiz-Bruce
Date Posted: 06 July 2011 at 11:20am

Will look in to this issue and see if anything can be done for the next release to fix it.

-------------
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: 07 July 2011 at 12:55pm

SAME HERE!!!
Interesting - since the upgrade to what we're using (it's 9.xx) I've seen the same thing! (we are not yet on 10)
I don't get much in the line of what I REALLY want logged, but the files used to be 2 or 3 K and are now 20K to 50K - some over 100K - since the last upgrade and the move of the log files to outside the public www area.
Prior to the latest upgrade, all were normal. Now EVERY single log file is totally filled with this:

2011-06-29 00:10:44 - 216.197.243.130 - Teamamc - ERROR - File: functions_session_data.asp - Error Details: err_SQLServer_saveSessionItem()_update_session_data - Microsoft VBScript runtime error - Object required
2011-06-29 00:32:57 - 173.192.238.34 - 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__3B75D760'. Cannot insert duplicate key in object 'dbo.tblSession'. The duplicate key value is (c5254z3z-43f6-c4fb9z1e-3774271a-a9ed2f16).
2011-06-29 00:59:35 - 65.52.110.67 - 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__3B75D760'. Cannot insert duplicate key in object 'dbo.tblSession'. The duplicate key value is (bf7561b5-bc5f-365cb1z3-28c5491f-9bce411b).
2011-06-29 01:03:07 - 174.36.241.156 - 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__3B75D760'. Cannot insert duplicate key in object 'dbo.tblSession'. The duplicate key value is (16d83d13-8c2a-162f1de1-78a814fd-ea21acf9).
2011-06-29 01:03:07 - 174.36.241.156 - 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__3B75D760'. Cannot insert duplicate key in object 'dbo.tblSession'. The duplicate key value is (b1z78a29-3ee9-bze65azf-225f62zb-1458eazf).
2011-06-29 01:03:07 - 174.36.241.156 - 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__3B75D760'. Cannot insert duplicate key in object 'dbo.tblSession'. The duplicate key value is (87d1f11a-529z-3833df1b-2f5be2zd-z67c7dfe).

-------------
BillD
http://theamcpages.com
http://theamcforum.com

Posted By: WebWiz-Bruce
Date Posted: 07 July 2011 at 2:48pm

The issue should be extremely rare in 9.70 upward, but it may still happen occasionally.

-------------
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: 07 July 2011 at 2:56pm

every single day for several months now.................. maybe only .01% of wwf users see it, but in our case, it's daily. The logs from last year to now all have this beginning to end.

Curious - is it a non-issue, or does it mean there's a configuration problem, etc.
Did one of us mess up in some setting?
?
It's Web Wiz hosted......... so I know the server(s) is/are MORE than capable. It's not like a cheap host with lame slow servers or connectivity issues.

-------------
BillD
http://theamcpages.com
http://theamcforum.com

Posted By: WebWiz-Bruce
Date Posted: 07 July 2011 at 3:06pm

I can see from the format of the session ID in the error message '87d1f11a-529z-3833df1b-2f5be2zd-z67c7dfe' that this is the old session ID format where this issue was common due to ASP's inability to produce truly random codes even when they are made of of 32 characters and numbers.

The new format is different. If you upgrade your forum to either the latest 9.x or 10.x versions this issue is much less likely to happen and should not happen at all as it does not rely on ASP producing a 32 character long alphanumeric ID.

-------------
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: 07 July 2011 at 3:12pm

Thank you - your knowledge of ASP and web servers and SQL is amazing.
I knew it wasn't a totally bad thing as things have been working pretty well. Few errors seen by members - but as an IT/network person, I get curious......

-------------
BillD
http://theamcpages.com
http://theamcforum.com