[Emerald] Calls Consolidation Process (Different thread)

Will LaSala ( will@greennet.net )
Mon, 29 Mar 1999 17:12:03 -0500

Dale or any IEA guru,
I am also having problem with the Calls Consolidation,
however mine seem to be totally different then the current thread about it.

Here are my problems.
First I have upto 18 months of back logged calls (only cause I've never used
Emerald for billing until December)
So I first just tried to run the con with out touching anything. Of course
it failed with all kinds of odd errors.
So I looked into the table and started to clean things up (this is a test
database so if I screw up it's ok).
First I checked for any 1 records but since I run the different nightly
tasks and only record the 2 records it found none.
Second I checked for records that may not have users still associated with
them and I deleted those records (boy did that help out with speed)
Third I checked for any status = 99 records (which means that they have
currently already been processed) which I shouldn't have had any since I've
never run the con process before...but I did find one...so I deleted that
record.
Fourth I ran the calls consolidation again. This time it failed with some
different errors that I thought was odd. I ran it on the 18th back month.
(The last number in the summary). Here's what I got for errors.
First Error Message:
"SQL Server Error: 207 Invalid column name 'FreeDays'. Stat = 2 Severity =
16"
Second Error Message:
"DBLibrary Error: 10007 General SQL Server error: Check messages from the
SQL Server."
Third Error Message:
"SQL Error: Couldn't Find MBR/SA"

All odd messages!
Error 1: So I ran a trace on the connection to see if I could track down
where the missing column was but that was now help since when I was looking
it seemed as though it was checking for it in the MasterAccounts and when I
checked instab.sql file came with Emerald I couldn't find the entry in
there. So is there a phantom table that I'm missing somewhere?
Error 2: I checked the logs but found no help maybe I'm not looking in the
right logs on the server. Which logs should I be checking?
Error 3: Remember this was one of the things I checked against in the clean
up process. Here's the script I used to check for those records

select NumberOfUsersExist = Count(distinct calls.username)
from calls
where calls.acctstatustype = 2
and calls.calldate <= "10/1/97"
and calls.calldate >= "9/1/97"
and exists (select su=(sa.login)
from subaccounts sa INNER JOIN SubAccounts ON Calls.AccountID =
SubAccounts.AccountID
where sa.AccountID = calls.AccountID
and sa.login = calls.username
or sa.email = calls.username)
and status = NULL
go
select NumberOfRecordsForUserExist = Count(calls.username)
from calls
where calls.acctstatustype = 2
and calls.calldate <= "10/1/97"
and calls.calldate >= "9/1/97"
and exists (select su=(sa.login)
from subaccounts sa INNER JOIN SubAccounts ON Calls.AccountID =
SubAccounts.AccountID
where sa.AccountID = calls.AccountID
and sa.login = calls.username
or sa.email = calls.username)
go

So.....huh? Why can't it find the MBR? I checked the AccountID and it is
diffentaly the same one.

P.S. Even after these error messages Emerald changes all the accounts status
= 99 meaning that they have been completed should it do that even with these
errors?
Thanks
Will ,,,=^. .^=,,,
Webmaster
GreenNet® ==========================================
"Link Locally ~ Surf Globally©" http://www.greennet.net
Come Play On The Best Quake Server in the Northeast
Serving Eastern Massachusetts and Southern New Hampshire
TEL: 978-363-8898 FAX: 978-363-1225 email:will@greennet.net
===================================================

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