Wrong Created and Expiry date in ASPStateTempSessions table for SQL Server Session mode

Question

User-1177472553 posted

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?

Answer 1

User-29804325 posted

Hi,

.its working fine except for the date's getting displayed in Created and Expiry columns of ASPStateTempSessions table

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:

<sessionState
   mode=”SQLServer”
   stateConnectionString=”tcpip=127.0.0.1:42424″
   sqlConnectionString=”data source=127.0.0.1; integrated security=true”
   cookieless=”false”
   timeout=”20″
/>

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.

Answer 2

User-1177472553 posted

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.

 

Answer 3

User-1636149233 posted

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.

Answer 4

User1875871952 posted

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