[Emerald] SQL Server crash after scheduled task 'UpdateCalls_ServerID'

Axel Drogoin ( (no email) )
Wed, 3 Feb 1999 09:51:17 +0100


i installed the SQL script insttask.sql yesterday and today morning the
server crashed. After reboot the Emerald database recovered for 2 hours. I
installed the tasks in the following order:

1:00 AM Backup of the Emerald database
2:00 AM Delete start records
3:00 AM Trim logs
4:00 AM Update Calls ServerID ---> Crash
5:00 AM Update Calls AccountID

There are about 172000 entries (3 Months) in the Calls table. Is this too
much? Is the table locked for new entries during this task?
Whats the cause of this crash?

I have some other problems too:

- Can i install a task that runs monthly and automtically deletes all
entries in the calls table older than xxx months?

- Because we use this program in Germany we would like to use other currency
and date formats:
$ --> DM
If i change my regional settings to this formats i get SQL errors with
Emerald. Is this a problem with the SQL server or does Emerald not support
other currency and date formats? We currently use a US version of SQL server
6.5. Is it possible to get Emerald running when we change to a german


Axel Drogoin, Evolution Systems

Evolution Systems GmbH Mobil-Oil-Str. 42
Network Management 84539 Ampfing
mailto:ad@esib.net Tel: +49 8636 9830 33
WWW: http://www.esib.net Fax: +49 8636 9830 99

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