Warning: could not send message for past 4 hours

Mail Delivery Subsystem ( MAILER-DAEMON@mail.barak.net.il )
Fri, 18 Sep 1998 21:16:13 +0200 (IST)

This is a MIME-encapsulated message



The original message was received at Fri, 18 Sep 1998 17:09:30 +0200 (IST)
from walnut.iea-software.com []

----- The following addresses had transient non-fatal errors -----

----- Transcript of session follows -----
<Emerald-list@mail.extent.com>... Deferred: Connection timed out with main.nmt.co.il.
Warning: message still undelivered after 4 hours
Will keep trying until message is 3 weeks old

Content-Type: message/delivery-status

Reporting-MTA: dns; mail.barak.net.il
Arrival-Date: Fri, 18 Sep 1998 17:09:30 +0200 (IST)

Final-Recipient: RFC822; Emerald-list@mail.extent.com
Action: delayed
Status: 4.4.1
Remote-MTA: DNS; main.nmt.co.il
Last-Attempt-Date: Fri, 18 Sep 1998 21:16:13 +0200 (IST)
Will-Retry-Until: Fri, 9 Oct 1998 17:09:30 +0200 (IST)

Content-Type: message/rfc822

Return-Path: <emerald-return@iea-software.com>
Received: from walnut.iea-software.com (walnut.iea-software.com [])
by mail.barak.net.il (8.9.1/8.9.1) with ESMTP id RAA15542
for <Emerald-list@mail.extent.com> Fri, 18 Sep 1998 17:09:30 +0200 (IST)
Received: from walnut.iea-software.com (walnut.iea-software.com []) by walnut.iea-software.com (NTMail 4.00.0020/NT6651.00.c89adb95) with ESMTP id za000903 for <emerald@iea-software.com> Fri, 18 Sep 1998 07:39:33 +0100
Received: from [] by walnut.iea-software.com (NTMail 4.00.0020/NT6651.00.c89adb95) with ESMTP id fwiaaaaa for <emerald@iea-software.com> Fri, 18 Sep 1998 07:39:29 +0100
Received: from speedy-ii ( by alpha.airnet.net (Worldmail 1.3.167); 18 Sep 1998 09:44:29 -0500
Message-ID: <35FED03000010906@alpha.airnet.net> (added by alpha.airnet.net)
X-Sender: mwhisen@mail.airnet.net
X-Mailer: QUALCOMM Windows Eudora Pro Version 4.0.2
Date: Fri, 18 Sep 1998 09:32:46 -0500
To: emerald@iea-software.com
From: Michael Whisenant <mwhisen@airnet.net>
Subject: SQL Error
Mime-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
X-ListMember: Emerald-list@mail.extent.com [emerald@iea-software.com]

I am having a new problem that is preventing me from performing normal
operations. This problem started on Monday, while out of town and I must
now get it fixed as tomorrow is the MAJOR billing day of the month.

Everytime I try to print out all the invoices that have not been sent I
get a generic SQL Server Error. I notice that the screen that preloads the
Crystal Reports is loaded and about half the normal time before the actual
invoices appear is when the error pops up.

I have examined the SQL Error logs in the Enterprise manager and get the
following errors:
Error 1105:, Severity 17, State 1
Can't allocate space for object '-964' in database 'tempdb' because the
'system' 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.

Now by tempdb is in ram, I examine the database and it is 32mb in size
with 31.24 free, I have truncated the database, and still this happens. I
can not increase the size because it is in ram, and will not allow me to
modify the size. Further I do not think it should be necessary to do so
with all the free space.

I have to be able to print out the batches of invoices as today and
tomorrow I have over 4500 invoices to print. If I have to select each one
1 at a time that will take forever.
Michael J. Whisenant
Vice-President, Operations
AIRnet Internet Services, Inc.
ph: (256) 704-4692 fax: (256) 704-2329