Tuesday, 29 April 2014

SysServerSessions and SysClientSessions are missing in the Ax 2009 database

Issues:- 1.Object Server 04: The database reported (session 2 (-AOS-)): [Microsoft][ODBC Driver Manager] Connection not open. The SQL statement was: "select  DATEPART(d,  GETUTCDATE()),         DATEPART(m,  GETUTCDATE()),    
  DATEPART(yy, GETUTCDATE()),         DATEPART(hh, GETUTCDATE()),         DATEPART(n,  GETUTCDATE()),         DATEPART(s,  GETUTCDATE())"

2.Object Server 04: Fatal SQL condition during login. Error message: "[Microsoft][SQL Native Client]Login timeout expired"

3. Object Server 04: Dialog issued for client-less session 1: Cannot select a record in Current AOS instances (SysServerSessions). ServerId: 0, .
Error accessing database connection.

Resolve:- Check your database in single user mode  make it multi user ->right click on the data base -> properties->select options->down you will find -> Restrict actions->change it multi user mode.
and
  you can resolve like
http://daxdilip.blogspot.in/2009/02/sysserversessions-and-sysclientsessions.html

No comments:

Post a Comment