RE: [Emerald] Calls Consolidation Process

Robert H. Clugston ( (no email) )
Mon, 29 Mar 1999 13:40:47 -0800

Dale,
I didn't understand what you meant about the key constraints on the
Callhistory table?
Also, here are the errors I got when I ran checkdb.sql.

DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking identity information: current identity value '1', current column
value '1'.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking identity information: current identity value '59', current column
value '59'.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking identity information: current identity value '1', current column
value '1'.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking identity information: current identity value '1', current column
value '1'.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking identity information: current identity value '1', current column
value '1'.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking identity information: current identity value '2', current column
value '2'.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking identity information: current identity value '2', current column
value '2'.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking identity information: current identity value '23', current column
value '23'.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking identity information: current identity value '7', current column
value '7'.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking identity information: current identity value '3', current column
value '3'.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking identity information: current identity value '5640', current column
value '5640'.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking identity information: current identity value '4066', current column
value '4066'.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking identity information: current identity value '1', current column
value '1'.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking identity information: current identity value '559', current column
value '559'.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 2501, Level 16, State 2
Table named OperatorAccess not found; check Sysobjects
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking identity information: current identity value '43', current column
value '43'.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking identity information: current identity value '11', current column
value '11'.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Msg 7997, Level 16, State 1
'RadValues' does not contain an identity column.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking identity information: current identity value '4', current column
value '4'.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking identity information: current identity value '8', current column
value '8'.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking identity information: current identity value '5', current column
value '5'.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking identity information: current identity value '3', current column
value '3'.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
Checking identity information: current identity value '753', current column
value '753'.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.

-----Original Message-----
From: emerald-request@iea-software.com
[mailto:emerald-request@iea-software.com] On Behalf Of Dale E. Reed Jr.
Sent: Friday, March 26, 1999 7:24 PM
To: emerald@iea-software.com
Subject: Re: [Emerald] Calls Consolidation Process

"Robert H. Clugston" wrote:
>
> List,
> I'm trying to run a consolidation on 24,000 calls and I keep
getting:
>
> SQL Error Adding CallHistory Item
>
> It appears to be progressing although its been running for 4 hours
and its
> only completed about 35 users. Any ideas?

First, run the instindx.sql script on your database from Emerald
2.5 to make sure you have all the indexes for the calls table.
Secondly, run the latest checkdb.sql script, to make sure the
stats on your indexes are up to date.

The key on the CallHistory table is too restrictive, if you are doing
any usage billing. You can use Enterprise manager to remove the key
and it should allow the records to be inserted correctly. All you
need on the CallHistory table is a duplicates allowed index on the
AccountID (which you should already have).

--

Dale E. Reed Jr. Emerald and RadiusNT__________________________________________IEA Software, Inc. www.iea-software.com

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

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