April, 1999

Ask Christopher...     
              The Answer Man!

This month's question...

Q  While indexing in halFILE, I received a message that reads:

“Can’t allocate space for object ‘primetable’ in database ‘SGFHFWTP’ because the ‘SQFHFWTP_LOG’ segment is full. If you ran out of space in Syslogs, dump the transaction log. Otherwise, use ALTER DATABASE or sp_extendsegment to increase the size of the segment.”

What does this mean and how do I fix it?

A  Your halFILE database must be located in Microsoft's SQL Server as this is a SQL Server error message. If the error refers to your main database device (such as SGFHFWTP_DATA), you will need to extend the database to provide more space for records. More likely, however, this error refers to the transaction log for your database.

A transaction log is maintained within SQL Server and logs every transaction that is written to the database. When the SQL Server database was created, the Systems Administrator designated a maximum size for this transaction log. This error indicates that the transaction log has reached the maximum size and is therefore full.

To quickly get you on your way you should

1. Get all of your users out of halFILE so no one has the database open.
2. From halFILE’s main menu run Tools_Refresh_Transaction log.  This issues an SQL command that clears out the transaction log.

To reduce the occurance of this error, consider a couple of options.

dump tran <database name> with no_log
And remember! To prevent data loss, the Answer Man recommends that you have a good back up of your system before re-configuring any SQL Server databases or option.

Send questions to the Answer Man at topher@halfile.com

8111 LBJ Freeway, Suite 860
Dallas, TX 75251
(800) 442-9273 or (214) 691-4700