Calls problem

Josh Hillman ( (no email) )
Sat, 12 Apr 1997 13:18:19 -0400

Any idea how to deal with this statement from ISQL/w??

select calldate, nasport from calls
where calldate > "Apr 1 1997"

(lots of calls records for ports 20101 - the next line)

Apr 11 1997 1:06AM 20105
Msg 605, Level 21, State 1
Attempt to fetch logical page 4053 in database 'Emerald' belongs to object
'0', not to object 'Calls'.
The SQL Server is terminating this process.

This is what I get after restoring the latest backup of the Emerald db from
a diskdump that runs everynight at 3am.

Incidentally, this seems to coincide with the port problem in the Calls
table that I had mentioned in my previous message (pasted below). I
restored the db from the dump at 4/11/97 3am AFTER writing the message

> This is the second time this has happened and I still have no idea what
> causes it or how to fix it. My Calls table (SQL) is missing records for
> ports 6 through 43 and is missing most of 44 as well. They were all
> yesterday but they're all gone now. These ports are no longer being
> updated in the Calls table, though the CallsOnline view displays all 48
> ports.
> ??????
> Ascend Max 4004 5.0Ai4
> SQL Server 6.5
> Emerald 2.1.11
> Radius .60 (service)

Which db do I use??? It seems that both are screwed up somehow.


Josh Hillman