Bug reports Found a bug? Post it here please.
Version 5.x > Bug reports > Exception when logging into Kentico View modes: 
User avatar
Member
Member
rguimaraes-sgw - 7/20/2010 11:42:05 AM
   
Exception when logging into Kentico
Hi all,

I was updating my new Kentico 5.5 website, when I ran into this error:

Exception Details: System.Exception: [DataConnection.ExecuteQuery]: Query: UPDATE CMS_User SET [UserName] = @UserName, [FirstName] = @FirstName, [MiddleName] = @MiddleName, [LastName] = @LastName, [FullName] = @FullName, [Email] = @Email, [UserPassword] = @UserPassword, [PreferredCultureCode] = @PreferredCultureCode, [PreferredUICultureCode] = @PreferredUICultureCode, [UserEnabled] = @UserEnabled, [UserIsEditor] = @UserIsEditor, [UserIsGlobalAdministrator] = @UserIsGlobalAdministrator, [UserIsExternal] = @UserIsExternal, [UserPasswordFormat] = @UserPasswordFormat, [UserCreated] = @UserCreated, [LastLogon] = @LastLogon, [UserStartingAliasPath] = @UserStartingAliasPath, [UserGUID] = @UserGUID, [UserLastModified] = @UserLastModified, [UserLastLogonInfo] = @UserLastLogonInfo, [UserIsHidden] = @UserIsHidden, [UserVisibility] = @UserVisibility, [UserIsDomain] = @UserIsDomain, [UserHasAllowedCultures] = @UserHasAllowedCultures, [UserSiteManagerDisabled] = @UserSiteManagerDisabled WHERE [UserID] = @UserID: caused exception: The transaction log for database 'KenticoCMS55' is full. To find out why space in the log cannot be reused, see the log_reuse_wait_desc column in sys.databases

I now get this message everytime I log into Kentico and I can't proceed to CMS Desk. Any ideas? I was hoping to update my website today.

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 7/20/2010 12:34:05 PM
   
RE:Exception when logging into Kentico
Hi,

From the error message it seems that the transaction log on your SQL server is full - it depends on your settings and what everything are you logging. So you need to clear the transaction log in the SQL server or extend its size and also check if there is enough space on disk to write the logs.

Best regards,
Juraj Ondrus

User avatar
Member
Member
Snarrak - 1/27/2012 5:31:51 AM
   
RE:Exception when logging into Kentico
I'm using a query to clear the transaction log. But is there a way to do this automatically, or set some settings in the sitemanager?

Where can I find what is logged?

Regards,
Jorik

User avatar
Kentico Support
Kentico Support
kentico_jurajo - 1/27/2012 8:03:32 AM
   
RE:Exception when logging into Kentico
Hi,

This is more SQL server related question so you might try the Google or SQL server forums. What I faound on Google is this:

http://msdn.microsoft.com/en-us/library/ms178037.aspx
http://technet.microsoft.com/en-us/library/ms189085.aspx
http://www.simple-talk.com/sql/learn-sql-server/managing-transaction-logs-in-sql-server/

Best regards,
Juraj Ondrus