RE: Call Consolidation Problems

Tom Bilan ( Tom@tdi.net )
Mon, 27 Apr 1998 10:59:47 -0400

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
>=20
> I get this error after running call consolidation for about 12 hours
> straight in Emerald.=A0=A0 A box pops up saying (Error deleting old
> records table) with an OK button.=20
> =A0
> The database has 300mb of space with 130mb free.=A0 After trying this =
a
> coupld of times it had 0mb free.=A0 I then ran the checkdb.sql script
> against the database and it put me back to 128mb free.=A0=20
> =A0
> Any idea what would cause this?=A0 I ran checkdb.sql before I did the
> call consolidation, also. Another bit of information is that I've
> never ran call consolidation before.=A0 I did manually delete all =
call
> records for 1997 and all statustype =3D 1 records.=A0 So I'm trying =
to
> consolidate around 4 months of activity for 700 users.
> =A0
> Any help would be appreciated.
> =A0
> James Sandusky
> ViaGrafix