Running reports: "ValueError: No objects to concatenate"

[Scott Dudley]

Hi all,

I'm running the trial for Websafety 7.5 on a VMware VM.

After configuring the system, I am trying to run some of the periodic reports. I updated them to run once an hour for testing. I tried half a dozen of the reports, but they all return an error such as the following (each ending with "No objects to concatenate") and no data.

2021-02-03 15:00:02,245 Running Periodic Report Builder with the following parameters:
2021-02-03 15:00:02,245 Active configuration:
2021-02-03 15:00:02,245 Stats folder : /opt/websafety-ui/var/stats
2021-02-03 15:00:02,245 Reports folder : /opt/websafety-ui/var/reports/periodic
2021-02-03 15:00:02,245 Mailer configuration:
2021-02-03 15:00:02,245 server : ************
2021-02-03 15:00:02,245 port : **************
2021-02-03 15:00:02,245 username :*********************
2021-02-03 15:00:02,245 password : *** masked ***
2021-02-03 15:00:02,246 use_auth : True
2021-02-03 15:00:02,246 Report to build : Search Queries
2021-02-03 15:00:02,246 Report 'Search Queries' found in the configuration, starting build...
2021-02-03 15:00:02,246 Building report 'Search Queries' ...
Traceback (most recent call last):
File "/opt/websafety-ui/bin/periodic.py", line 146, in <module>
main()
File "/opt/websafety-ui/bin/periodic.py", line 142, in main
run(args)
File "/opt/websafety-ui/bin/periodic.py", line 103, in run
run_single(config, args.report)
File "/opt/websafety-ui/bin/periodic.py", line 47, in run_single
run_report(config, item)
File "/opt/websafety-ui/bin/periodic.py", line 27, in run_report
r.report(item)
File "/opt/websafety-ui/bin/daemon/stats/periodic/reporter.py", line 34, in report
self.build(folder, config)
File "/opt/websafety-ui/bin/daemon/stats/periodic/reporter.py", line 52, in build
df = s.load(config)
File "/opt/websafety-ui/bin/daemon/stats/periodic/storage.py", line 44, in load
return self.read(dates, filters)
File "/opt/websafety-ui/bin/daemon/stats/periodic/storage.py", line 205, in read
return pd.concat(loaded, axis=0, ignore_index=True, sort=False)
File "/usr/local/lib/python3.6/dist-packages/pandas/core/reshape/concat.py", line 284, in concat
sort=sort,
File "/usr/local/lib/python3.6/dist-packages/pandas/core/reshape/concat.py", line 331, in __init__
raise ValueError("No objects to concatenate")
ValueError: No objects to concatenate

Any ideas?

Scott

[Rafael Akchurin]

Hello Scott,

Are you sure you have anything in the logs for the period you build? See UI/Traffic/History.

Best regards,

Rafael Akchurin

On 3 Feb 2021, at 21:23, Scott Dudley <scott....@gmail.com> wrote:

Hi all,

--
You received this message because you are subscribed to the Google Groups "Diladele Web Safety" group.
To unsubscribe from this group and stop receiving emails from it, send an email to web-safety+...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/web-safety/306e82e5-7ab7-424e-8a28-cc788c9e3946n%40googlegroups.com.

[Scott Dudley]

Rafael,

You're right--I don't have any data shown on the history calendar yet for the last week. (I started the VM two weeks ago though and I do see data from Jan 20.)

How often is data batched into the history calendar (or wherever the reports pull their data), and is it possible to configure it to do this batching right now so that I can evaluate the reports? (The "real time traffic" tab is showing plenty of current data for today and I confirm that the site blocking is working.)

Thanks,

Scott

[Rafael Akchurin]

This shows how it works in general - https://docs.diladele.com/administrator_guide_stable/traffic_monitoring/index.html

Best regards,

Rafael Akchurin

On 3 Feb 2021, at 21:31, Scott Dudley <scott....@gmail.com> wrote:

Rafael,

To view this discussion on the web visit https://groups.google.com/d/msgid/web-safety/aa850eb4-72ea-4562-9421-157e51a828b4n%40googlegroups.com.