Re: Call Consolidation Problems

James Sandusky ( jsmail@viagrafix.com )
Mon, 27 Apr 1998 10:06:55 -0500

My tempdb is set to 10mb currently. I'll increase it to 50mb.

-----Original Message-----
From: Tom Bilan <Tom@tdi.net>
To: 'emerald@emerald.iea.com' <emerald@emerald.iea.com>
Date: Monday, April 27, 1998 9:55 AM
Subject: RE: Call Consolidation Problems

Also, what is the size of your tempdb. You may be running out of
temporary space. I bumped my from 2mb to 50mb.

Also

Open SEM (SQL Enterprise Manager) and do server->error log. You may get
more detailed information there.

Tom

> -----Original Message-----
> From: jsmail@viagrafix.com [SMTP:jsmail@viagrafix.com]
> Sent: Monday, April 27, 1998 10:43 AM
> To: emerald@emerald.iea.com
> Subject: Call Consolidation Problems
>
> I get this error after running call consolidation for about 12 hours
> straight in Emerald. A box pops up saying (Error deleting old
> records table) with an OK button.
>
> The database has 300mb of space with 130mb free. After trying this a
> coupld of times it had 0mb free. I then ran the checkdb.sql script
> against the database and it put me back to 128mb free.
>
> Any idea what would cause this? I ran checkdb.sql before I did the
> call consolidation, also. Another bit of information is that I've
> never ran call consolidation before. I did manually delete all call
> records for 1997 and all statustype = 1 records. So I'm trying to
> consolidate around 4 months of activity for 700 users.
>
> Any help would be appreciated.
>
> James Sandusky
> ViaGrafix

----------------------------------------------------------
Emerald Mailing List listserver@emerald.iea.com