Posts: 1
Threads: 1
Joined: Jun 2017
Reputation:
0
I have upgraded to ASG-RemopteDesktop 2017 and I get this error when starting the app:
"An error occured on executing an sql statement. LogsRemoveByDaysAndCount"
This pops up two times and then it works.
But no other user than me can log in using integrated login. (I 've got 6 user license)
- Arvid
Posts: 10,628
Threads: 91
Joined: Aug 2006
Reputation:
181
You may have to many logs and you run into a timeout trying to delete some of them (by rule "Delete logs older than")
You can easily delete all old logs in the database directly by the command "TRUNCATE table Logs" (open MS SQL Server Management Studio - select your database and run a new query window) - or if you can login you may try to delete some of your log file data manually
Regards/Gruss
Oliver
Posts: 31
Threads: 8
Joined: Oct 2016
Reputation:
0
@arvkris: did truncate help?
We have the same error - and a little preasure because the migration should happen at Saturday.
Greetings,
Sandra
Posts: 31
Threads: 8
Joined: Oct 2016
Reputation:
0
When i try to login over Citrix with a userid, i also cant CONNECT to the database. With button Edit and then Test Connection, i get the message that the Connection established successfully.
Maybe this is in context to it ?
Posts: 10,628
Threads: 91
Joined: Aug 2006
Reputation:
181
Yes the problem is that sql server delete row by row and write for each row a transaction log - if the table is too huge this will cost a lot of time - TRUNCATE is done in a few milliseconds because no log is written and it is not possible to rollback
Regards/Gruss
Oliver
Posts: 10,628
Threads: 91
Joined: Aug 2006
Reputation:
181
No login has nothing to do with size of logs table
How do you set permissions on the database? If you enable a user with "db_datareader / db_datawriter" you may can open a connection - but if you don't have "Execute and Connect" enabled you won't be able to work with the database
Regards/Gruss
Oliver