[Emerald] checkdb SQL Server timeout

Josh Hillman ( (no email) )
Thu, 8 Apr 1999 14:21:35 -0400

I just transferred my Emerald 2.1.11 database to my testing machine with no
errors (to upgrade to 2.5) and after doing so, I ran Emerald Admin 2.5.260,
then ran the checkdb.sql script that I found at:
ftp://ftp.iea-software.com/emerald/Updates/checkdb.sql
1/12/99 1938 bytes
Note, that this is newer/larger than the checkdb.sql file found at:
ftp://ftp.iea-software.com/emerald/beta/checkdb.sql
5/9/97 1380 bytes

Below are the results of running the (newer) checkdb.sql script from within
Emerald Admin. Any idea why there's a connection timeout message? I have
no idea "when" it timed out or from what part of the script.

Josh

SQL Server connection timed out.
Transaction has been aborted.
DBCC NewAlloc

---------------

DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
DBCC execution completed. If DBCC printed error messages, see your System
Administrator.
DBCC CheckIdent(ChargeTypes)

---------------

Updating CALLS
Updating CONFIGS
Updating CONFIGVALUES
Updating DOMAINS
Updating EXTERNALSYSTEMS
Updating LISCENSES
Updating LOGS
Updating MODEMSPEEDS
Updating NAMETRANS
Updating NETSOFTWARES
Updating OPERATORS
Updating RADLOGMSGS
Updating RADROAMS
Updating RADROAMSERVERS
Updating RADVENDORS
Updating RATES
Updating REPORTS
Updating SCRIPTS
Updating SERVERS
Updating SYSTEMTYPES
Updating TRAFFIC
Updating GROUPS
Updating RADATTRIBUTES
Updating RADLOGS
Updating SCRIPTMAPS
Updating SERVERPORTS
Updating ACCOUNTTYPES
Updating CHARGETYPES
Updating CLASSES
Updating DISCOUNTS
Updating INVOICETYPES
Updating MAILITEMS
Updating OPERATORACCESS
Updating PAYMETHODS
Updating PAYPERIODS
Updating RADVALUES
Updating REGIONS
Updating CLASSDATES
Updating MASTERACCOUNTS
Updating RADATCONFIGS
Updating CHARGES
Updating CREDITS
Updating GROUPACCESS
Updating INVOICES
Updating MAIL
Updating PAYMENTS
Updating SUBACCOUNTS
Updating CALLHISTORY
Updating EXTERNALTRANS
Updating INCIDENTS
Updating INVOICEITEMS
Updating RADCONFIGS
Updating TIMELIMITS
Updating TIMEUSAGES
Updating ACTIONS

************* NO MORE TABLES *************

Statistics have been updated for all tables.