Various Errors - Need help
Moderator: SourceGear
Various Errors - Need help
Attach is the log file. Also the screen shot.
Sometimes i can't even login as admin. However after a while, it was OK. I must have missed out something. I have attempted to clear cache & restart server. The problem still persist. Other users face the same problem.
I have posted it at http://support.sourcegear.com/viewtopic.php?t=3839 but decided to create a new entry here.
Sometimes i can't even login as admin. However after a while, it was OK. I must have missed out something. I have attempted to clear cache & restart server. The problem still persist. Other users face the same problem.
I have posted it at http://support.sourcegear.com/viewtopic.php?t=3839 but decided to create a new entry here.
- Attachments
-
- No permission
- No permission.jpg (37.14 KiB) Viewed 14465 times
-
- vault_log.txt
- Log File
- (247.74 KiB) Downloaded 924 times
-
- Invalid Cast screen shot
- Invalid cast.jpg (37.54 KiB) Viewed 14469 times
I would also suggest shrinking the Vault database log file. It could be contributing to some of the problems you are seeing. It certainly won't hurt . . .
If the database log file isn't a problem, there could be an issue with IIS settings or a firewall or router closing the connection.
Can you do the same operations on the Vault Server machine itself, using a client on the Vault server machine and connecting with "localhost" for the Vault server name?
If the database log file isn't a problem, there could be an issue with IIS settings or a firewall or router closing the connection.
Can you do the same operations on the Vault Server machine itself, using a client on the Vault server machine and connecting with "localhost" for the Vault server name?
Linda Bauer
SourceGear
Technical Support Manager
SourceGear
Technical Support Manager
I will try my best to figure out exactly how to shrink the log file. There is no firewall & all users are connected through LAN.
On IIS Setting, found this post: http://support.sourcegear.com/viewtopic.php?t=1014
I noted that the "Recycle worker process (in minutes):" option is unchecked under VaultAppPool but remain checked in DefaultAppPool. For Idle timeout option under Performance tab, both are unchecked. For 2 days the server log file began to capture error message at around 10 am. Would that be a coincident?
On IIS Setting, found this post: http://support.sourcegear.com/viewtopic.php?t=1014
I noted that the "Recycle worker process (in minutes):" option is unchecked under VaultAppPool but remain checked in DefaultAppPool. For Idle timeout option under Performance tab, both are unchecked. For 2 days the server log file began to capture error message at around 10 am. Would that be a coincident?
Here's the instructions I usually recommend for shrinking the log file:
- 1. Make a complete BACKUP of the database. (This is a MUST DO step!! You need to be able to recover if something goes wrong. If you have one, then continue.)
2. Execute 'BACKUP LOG sgvault WITH TRUNCATE_ONLY'
3. Execute this entire section:4. Make a complete BACKUP of the database with the truncated log. (This is a needed so that if you have to restore, you don’t have to restore the huge log again. Huge logs will not restore in SQL 2000 sometimes.)Code: Select all
USE sgvault GO DBCC SHRINKFILE (sgvault_log) GO
The problem already resolved. Please see http://support.sourcegear.com/viewtopic.php?p=38273