The Forums on slxdeveloper.com are now retired. The forum archive will remain available for the time being. Thank you for your participation on slxdeveloper.com!
|
|
Error when trying to access a group
Posted: 02 Sep 09 3:29 PM
|
First ~ we have a VERY old version of saleslogix 4.1
I am getting the following error trying to access a group:
saleslogix error: error activating group: general sql error. The log file for database 'tempdb' is full. backup the transaction log for the database to free up some space.
I have 3 other groups set up with similar queries that are working fine.
Any suggestions?
Thank you in advance! |
|
|
|
Re: Error when trying to access a group
Posted: 02 Sep 09 5:24 PM
|
My suggestion is to address the error message being returned by SQL, regardless of the other groups.
The TempDB is used internally by SQL server for many purposes. Since this group fails with that error, it just means that when SQL handles this specific query, it is performing some actions that require the use of the TempDB..
You will need to either truncate the log on the TempDB (never heard of having to manually do so), Allow it to grow, and/or make sure that you have enough disk space available on the drive where the TempDB resides.
|
|
|
|
Re: Error when trying to access a group
Posted: 21 Sep 09 10:22 AM
|
| You're probably on an old version of SQL (7.0/2000)??? I believe in the older version of SQL you can actually (pause .........) delete TempDB and it will rebuild. |
|
|
|
Re: Error when trying to access a group
Posted: 21 Sep 09 12:41 PM
|
You can delete TEMPDB after stopping SQL Server and it will rebuild it when it restarts ...
The location of TEMPDB can also be changed fairly easily - if interested, post back & I will provide details. |
|
|
|