call by call report problem.

[ipeology]

starting may 21, my standard call by call report suddenly has no data. but using excel database query i can generate call by call.

and ideas on what, where to check?

thanks.

 

[KillianK]

Why don't you duplicate the report, rename the report and see will it generate the data when you run it?

Have you checked the Historical Statistics, call by call days, make sure it is not set to "0"?

Cheers,

Killian

 

[sandyml]

Have the collection and storage parameters been changed on your Symposium? You select on a per application basis whether or not call by call data is collected, and then for the system you define how long to store it, all based on your server's storage capacity. Check the Historical Statisics (Reports & Displays - Statistics Configuration - Historical Statistics).

 

[ipeology]

collection and storage parameters on historical statistics have been checked and it has correct parameters on it.

i'll try to duplicate the report and see what happen.

cheers

 

[ipeology]

i created a duplicate call by call report and run it, still there is no data.

i am doing this on 3 different client pc's.

any more suggestions?

 

[brewerdude]

Try attaching the tables using ODBC in MS Access. They should appear as dbo_eCallbyCallStatYYYYMMDD. Depending on how many days you have the call-by-call remain, you'll see a number of tables in there. That will at least tell you if they're there or not. You can also easily check the contents of the entire table for each day.

 

[ErwinStevanus]

just a quick one : did you install the patch on the client?
Also, did you see any CBC Error messages on the alarm monitor ?

 

[ipeology]

yes, client is on SU11C.

there are CBC error messages relating to SQL Server, HDM, and OAM services. I checked and restart all this services but still my CBC Reports are Blanks.

i captured the logs and sent it to Nortel.

cheers.

 

[ErwinStevanus]

I have the same problem with the CBC.

Did you recently change the Server Configuration or run the Server Setup Configuration?

I did an ip address change in SCCS and run the Server Setup Configuration. After the reboot, I have the CBC error message. So, I change the SCCS ip address to another dummy ip and run the serve setup configuration. After reboot, the message is gone.

I believe the problem is related to the Server Setup Configuration process.

 

[ipeology]

i have fix the problem.

what i did is change the Historical Statistic > Call by Call tab > and set ALL to NONE, also set the Duration to only 1 day. After this close the SCCS Client. Run again SCCS client put back the setting to LOCAL. Then see if you have data on your CBC.

if this does not fix the problem, restart only the HDM Service. then try again if you have CBC.

cheers.