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

• • Reply
  msdnphani

  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

  Thanks
  Siva Phani
  Mark the post as Answer if it helps.
• • Reply
  Zizhuoye Che...

  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,

  msdnphani

  .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.

  Please mark the replies as answers if they help or unmark if not.
  If you have any feedback about my replies, please contact msdnmg@microsoft.com
  Microsoft One Code Framework
• • Reply
  msdnphani

  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.

   

  Thanks
  Siva Phani
  Mark the post as Answer if it helps.
• • Reply
  inedev

  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

• • Reply
  GDKN

  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