Re: [Emerald] checkdb SQL Server timeout

Alexander Blauvelt ( online@olg.com )
Thu, 8 Apr 1999 23:55:41 -0400 (EDT)

Bring up ISQL or enterprise manager, and load the script up there and run
it. The Emerald Admin will timeout before check DBCC() will finish. If
you have a lot of data, it will always take longer than emerald admin
allows it.

Alex
Online Gateway

> 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.
>
>