[Emerald] Database Expansion Error

Adam Greene ( (no email) )
Wed, 31 Mar 1999 17:09:35 -0500


Dang! I sent this to the wrong list yesterday. My apologies to anyone =
subscribed to ntisp@iea-software.com for my "spam"

Here's a cleaner version of an email I posted Monday (I hope my editing =
makes it easier to reply to)=20

I am running Emerald 2.1.8, Radius 2.2, SQL 6.5 on a 233 MHz server with =
128 MB RAM. I have about 950 MBR's.

Sunday, while running a Call History Consolidation, I got the message, =
"Error deleting old records table!" The Event Viewer said:
3/28/99 1:16:02 PM MSSQLServer Error Server 17060 N/A NS Error : 1105, =
Severity: 17, State: 2
Can't allocate space for object 'Syslogs' in database 'Emerald' because =
the 'logsegment' 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.=20

Emerald would not update the database and users began calling in to say, =
"I can't log on!" so I did the following:

I expanded the size of the EmeraldLog Database Device from 50 to 70Mb. =
Then I opened the Emerald Database and clicked "Expand." I selected =
"EmeraldLog" as the Log Device, specified 20MB as the size (20Mb=3Dthe =
amount I increased the device), and clicked "Expand Now." =20

The database could then be updated, and I ran a successful =
Consolidation. =20

But things are not working quite right yet. These are the "problems": =20

1) the Emerald database used to say it had a total Data Size of 75Mb =
(the size of the Emerald device and the EmeraldLog device combined). =
Now it says it has a Data Size of 25Mb (the size of the Emerald device =
alone) and a Log Size of 70Mb. There is only 1.39Mb of Data Space =
available. Does this seem right?

2) the SQL "Automated Daily Task" returns this error:
3/29/99 10:28:33 AM SQLExecutive Warning Task Engine 208 N/A NS SQL =
Server Scheduled Task: 3, 'Emerald Daily Automated Maintenance' -- =
Status: Failed
-- Task Invoked on: 3/29/99 10:26:18 AM -- Message: Process Exit Code 1. =
... ** Execution Time: 0 hrs, 0 mins, 22 secs **[4] Delete Old Backup =
Files...0 file(s) deleted.End of maintenance for database 'Emerald' on =
Mon Mar 29 10:28:31 1999SQLMAINT.EXE Process Exit Code: 1 (Failed). =
NOTE: The task was retried the requested number of times (1) without =
succeeding. The task failed.=20

3) Seagate BackupExec returns this error when trying to backup the =
3/29/99 12:36:44 PM Backup Exec Error None 57856 N/A NS An error =
occurred while executing the following query: "DBCC NEWALLOC(Emerald)".
OS error message: "".
DBLIB error message: "General SQL Server error: Check messages from the =
SQL Server.".
Server error message: "Extent not within segment: Object 1856009643, =
indid 1 includes extents on allocation page 13312 which is not in =
segment 1.".=20

Any help would be greatly appreciated. I am afraid that Emerald is not =
being backed up properly now, and that it may crash again.... maybe =
the solution is simple.

Thanks for your help,

For more information about this list, including removal,
please see http://www.iea-software.com/maillist.html