Hi .. m using SQL Server session mode.its working fine except for the date's getting displayed in Created and Expiry columns of ASPStateTempSessions table . any spefic reason for this?
sqlSession
Thanks
Siva Phani
Mark the post as Answer if it helps.
And BTW, SqlSessionStateStore use a SQL Server Agent job that periodically calls the stored procedure DeleteExpiredSessions to remove expired sessions. So you do not worry about the session expiration.
Just in case someone else stumbles upon this. I hade the same issue, I'm going to guess it's not well tought out by the creators: The procedures that write in the ASPState* tables, and the defaut falues to the fields in those tables are using getutcdate()
instead of getdate() for the current dateTime. I guess it doesn't take into account day light saving, it was one hour off for me. Went trough all the procedures and changed it and it worked.
CUSTOM SOFTWARE DEVELOPMENT
INTEGRATION.
Solutions to solve our client’s problems through a durable global infrastructure and powerful methodologies
With over 20 years of experience in the IT services and staffing industries, unparalleled sourcing methodologies and global capabilities, GDKN is uniquely equipped to provide the right software solutions
IT Services, Application development, Custom Software, Business process, Automation, Software Development, Software solution, Application Maintenance ,Enterprise application development
Participant
1425 Points
486 Posts
Wrong Created and Expiry date in ASPStateTempSessions table for SQL Server Session mode
Jun 24, 2011 01:27 PM|msdnphani|LINK
Hi .. m using SQL Server session mode.its working fine except for the date's getting displayed in Created and Expiry columns of ASPStateTempSessions table . any spefic reason for this?
sql Session
Siva Phani
Mark the post as Answer if it helps.
All-Star
18088 Points
1902 Posts
Re: Wrong Created and Expiry date in ASPStateTempSessions table for SQL Server Session mode
Jun 28, 2011 10:43 PM|Zizhuoye Chen - MSFT|LINK
Hi,
Can you please elaborate your issue? Does the Created and Expired cloumn not stored datetime correctly or can not display in page?
Web.config could be:
You can check these links for configue sql session state.
http://www.codeproject.com/KB/aspnet/ExploringSession.aspx#21
http://msdn.microsoft.com/en-us/library/ms178586.aspx
And BTW, SqlSessionStateStore use a SQL Server Agent job that periodically calls the stored procedure DeleteExpiredSessions to remove expired sessions. So you do not worry about the session expiration.
Hope this can help you.
If you have any feedback about my replies, please contact msdnmg@microsoft.com
Microsoft One Code Framework
Participant
1425 Points
486 Posts
Re: Wrong Created and Expiry date in ASPStateTempSessions table for SQL Server Session mode
Jun 29, 2011 01:58 AM|msdnphani|LINK
i am able to save data in the session object which internally saves into sql server DB .. no issue with saving and retreiving data ..
my doubt, (will rather call it as a doubt than an issue) is why the date in CreatedDate and ExpiryDate coulmn's in ASPStateTempSessions are wrong.
ex: i have stored a string in session : session["abc"]="Siva"; say at 6/29/2011 11:45:00
now this would sit in the ASPStateTempSessions table, but the createddate and expirydate are showing differently, say 6/15/2011 etc etc ..
have gone through some forums which said its an internal bug .. is this correct or do i need to change any thing at my code level ..
Note:Have tested this in my development environment.
Siva Phani
Mark the post as Answer if it helps.
None
0 Points
1 Post
Re: Wrong Created and Expiry date in ASPStateTempSessions table for SQL Server Session mode
Apr 16, 2015 05:07 AM|inedev|LINK
Just in case someone else stumbles upon this. I hade the same issue, I'm going to guess it's not well tought out by the creators: The procedures that write in the ASPState* tables, and the defaut falues to the fields in those tables are using getutcdate() instead of getdate() for the current dateTime. I guess it doesn't take into account day light saving, it was one hour off for me. Went trough all the procedures and changed it and it worked.
sql Session
None
0 Points
1 Post
Re: Wrong Created and Expiry date in ASPStateTempSessions table for SQL Server Session mode
Jun 09, 2015 05:21 PM|GDKN|LINK
Good observation... if you need further help please feel free to reach us:-
http://www.gdkn.com/ITServices
GDKN - Quality Solutions without the Premium Cost
BUSINESS PROCESS AUTOMATION
CUSTOM SOFTWARE DEVELOPMENT
INTEGRATION.
Solutions to solve our client’s problems through a durable global infrastructure and powerful methodologies
With over 20 years of experience in the IT services and staffing industries, unparalleled sourcing methodologies and global capabilities, GDKN is uniquely equipped to provide the right software solutions
IT Services, Application development, Custom Software, Business process, Automation, Software Development, Software solution, Application Maintenance ,Enterprise application development
sql Session