Gemini Community Support Site

This Gemini community support site can be used to find solutions to product issues. You can log in using Open Id, Google Profile and even Facebook. Feel free to ask a question or browse FAQs and documentation. Product tour videos are also available along with how-to videos demonstrating key Gemini capabilities.




Cannot delete system log

web-app

If I go to Administration|System Log and click the Delete button, I get this error, yet everything else is working fine. The system log is then just appended with a new error saying the same thing:

Cannot find the object "errorlog" because it does not exist or you do not have permissions.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Data.SqlClient.SqlException: Cannot find the object "errorlog" because it does not exist or you do not have permissions.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:

[SqlException (0x80131904): Cannot find the object "errorlog" because it does not exist or you do not have permissions.]
   CounterSoft.Gemini.DataProvider.ExceptionProvider.x74d5712e6641180f() +68
   CounterSoft.Gemini.Business.ExceptionManager.DeleteErrors() +13
   CounterSoft.Gemini.ErrorLog.btnDelete_Click(Object sender, EventArgs e) +9
   System.Web.UI.WebControls.Button.OnClick(EventArgs e) +105
   System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +107
   System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
   System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
   System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
   System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint

Any ideas? v2.1.1.

jsweby
· 1
jsweby
Replies (6)
helpful
0
not helpful

If you can view the errors but not delete the log then it seems that your SQL user does not have delete permissions on the errorlog table.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Makes sense but why would this table have been set up any differently to the others?


jsweby
· 1
jsweby
helpful
0
not helpful

That is a question to your SQL admin. We do not assing any SQL permission during setup.


Mark Wing
· 9108
Mark Wing
helpful
0
not helpful

Damn, that'll be me  :)


jsweby
· 1
jsweby
helpful
0
not helpful

This is happening for me as well. I have verified that the server account has permissions to delete on the table errorlog. I have verified that I am using the right user account by disabling connect permissions for that account and seeing that the site no longer loads. I have also given the account global permissions and that fails as well. My only other step is trying to make that account part of dbowner which I dont really want to do.

ETA:If i make the user account part of the dbowner role delete works. However this isnt desirable.

 

 


ecathell
· 1
ecathell
helpful
0
not helpful

Hi,

I had the same problem.

[quote user="ecathell"]ETA:If i make the user account part of the dbowner role delete works. However this isnt desirable.[/quote]

Gemini executes the stored procedure 'gemini
deleteerrors' if you click to delete the error log. This stored procedure uses the 'TRUNCATE TABLE' statement to recreate the table. Indeed, this statement is much faster than 'DELETE FROM' but needs much more permissions.

According to the SQL Server Books Online:

TRUNCATE TABLE permissions default to the table owner, members of the sysadmin fixed server role, and the dbowner and dbddladmin fixed database roles, and are not transferable.

It's not an option to assign db_owner or any of the other database or server roles to the gemini web user.

I'd recommand Countersoft to use DELETE FROM instead of TRUNCATE TABLE.

--
Kind regards,
Mathias


tolot27
· 1
tolot27