The only way that’s going to happen is if you can give us some logs showing the problem.
I’ve explained how to generate them, but haven’t received anything from you.
Nothing can happen until that is done.
Hi Alex!
This was all in the log file,
" |logId,runNo,logDate,channel,page,function,message,display.display,type|||
| — | — | — |
|373247,efb2712,“2019-01-24 18:06:01”,CONSOLE,/,GET,“Layout ID 2885 has an empty region”,ALERT|||
|373248,efb2712,“2019-01-24 18:06:01”,CONSOLE,/,GET,“Layout ID 938 has an empty region”,ALERT|||
|373249,96262be,“2019-01-24 18:10:08”,CONSOLE,/,GET,“Layout ID 2885 has an empty region”,ALERT|||
|373250,96262be,“2019-01-24 18:10:08”,CONSOLE,/,GET,“Layout ID 938 has an empty region”,ALERT|||"
I have saved the zip file and zip file had log file in CSV format where was only the informed lines, nothing else.
Can you please describe a bit clearly, do you want everything placed in the zip file or just the log?
if just the log, that had only the informed lines in it.
If you want everything else, where do you want me to put them? looks like i cannot upload zip file to the forum.
Hi Alex,
Okay, i will make a new one.
What I need you to do is work through the wizard.
When it tells you to recreate the issue, open a new browser tab and try and display the statistics you say generates this error. Then when it fails, go back to the wizard and finish up.
Then take a look at the log, isolate the area where the statistics report is running and let me have the errors in that area.
There simply cannot be 4 lines if you have run through the report fault wizard. Just turning it on and off will generate more than that!
Hi Alex,
have you checked the PDF file attached?
Yes, that’s all the messages.
What we need is it narrowed down please. If you want us to do it for you we can look on a paid basis but if you want free support, you’ll need to meet us half way!
1 Like
Hi Alex,
please accept my apologies,
I have open the new window, duplicated the issue in the new window, went back to the fault reporting and finished it.
The fact is, there is no error of any kind for the issue.
So,
i am a bit lost here,
i get the error from the system while trying to receive proof of play report but fault reporting gives no results of the error.
Log has only like around 50 lines
There are errors that has nothing to do with the actual issue such as,
- 404362,f9580ef,“2019-01-25 19:58:21”,PLAYER,"[Watcher] Watchdog",POST,“Too many active processes”
- 404363,dd86d44,“2019-01-25 19:59:19”,PLAYER,"[Watcher] Watchdog",POST,“No active processes”
- 404392,ce13a3c,“2019-01-25 20:05:25”,PLAYER,"[LogAgent] LogAgent - Run",POST,“Exception in Run: Bad Request”
- 404397,1d4e597,“2019-01-25 20:06:01”,CONSOLE,/,GET,“Layout ID 2885 has an empty region”,ALERT
OK. Can you take a backup of your database please, zip it up and send it to me, letting me know which CMS version you’re using, and the exact steps to reproduce this - including the values you’re entering in to the statistics report.
I’ll send a PM with instructions for where to send it.
Hi Alex!
thanks for the response.
I will check this and let you know.
As you mentioned above, i do have statistics reporting on. It’s always been on for all my display profiles. 
I too have created a debugging zip file from my CMS. Where do i send it?
Were there any errors recorded? I don’t need the complete zip, just any errors at the point you run the report.
No errors in the log file as far as i can see. I had the error on screen while trying to get proof of play data though.
I am no developer, therefore I might not understand the log file as how it was intended.
I’m adding to this thread, I have the same problem.
Very slow if I select one single day, Datatables error if I select more than that.
Maybe too few resources on the vm? My VM, which hosts the docker installation, has 4GB of RAM, 12GB of free disk space, 2 vCPU. The stat.idb file is 4GB (the full db folder is 4.1GB).
I have my database seperate from the docker installation. My docker host server is quite beefy - so perfomance should not be an issue. I can provide specs if needed.
You can certainly try increasing your PHP memory limit and maximum execution time.
Stats are hugely resource intensive. You literally get 1 record for every time any widget runs, and one of the start and finish of every layout, so even with a small number of Players a few million records per hour isn’t unusual.
2.1 has a focus on stats where we’re hoping to improve this.
If you’re able to generate results for a short period, but not for a longer period, then you’re definitely hitting a limit somewhere and giving more resources in that area will resolve it. They will still be very slow though. There’s no getting away from that at the moment.
One way I could get the data I was after was downloading the entire database to my PC, then running a query locally for the media ID I needed statistics for. I am really looking forward to 2.1 