Page 1 of 1

Unable to run reports

PostPosted: Mon Mar 07, 2016 9:13 am
by Dcdata
Good morning guys,

We've found that none of the reports are loading.
The reports page lists all reports but when clicking on any Detailed or Summary report, the report never loads.
We are running TNG for Asterisk 1.1.1.12
Any ideas why?

Re: Unable to run reports

PostPosted: Mon Mar 07, 2016 9:25 am
by Luanda_Junzi
Good Morning DcData

How big is the report?

Is the call list updating in case the database is corrupt.

Kind Regards

Luanda

Re: Unable to run reports

PostPosted: Mon Mar 07, 2016 7:52 pm
by Dcdata
Hi Luanda,

Thank you for your reply.

The report will more than likely be big but TNG is not even allowing me to run the report. Nothing happens when I click on "Extension Detail Report" in the reports menu. The browser simply sits there waiting for the next screen that would allow the date and other criteria to be selected. After minutes of waiting the connection eventually times out and I have to re-login to TNG.

I've tried restarting TNG but it hasn't helped but I have noticed that TNG takes hours to start and get to the point where I can access the web interface on port 7080.

There are a fair amount of calls in this system '1data_1.1.1.x.dat' and '2data_1.1.1.x.dat' are around 780 MB in size each. I am not sure if this perhaps pointing to the issue?

>Is the call list updating in case the database is corrupt.
Yes. New calls are showing in "Call list".

Many thanks.
David Wilson

Re: Unable to run reports

PostPosted: Mon Mar 07, 2016 8:02 pm
by Luanda_Junzi
Good Evening David

You have a big database, can you plank your database.
let TNG rebuild a new one. TNG will take time to load depending on the number of ext's you have.

give it 20 to 30 min if you have ext more than 500.


Regards

Luanda

Re: Unable to run reports

PostPosted: Tue Mar 08, 2016 9:17 am
by Dcdata
Thank you Luanda.

By 'plank' the database, I am assuming that I should delete 1data* and 2data*?

Re: Unable to run reports

PostPosted: Tue Mar 08, 2016 9:34 am
by Luanda_Junzi
Hi David

Yes, but don't delete just rename or move the files to another location.

Kind Regards

Luanda