ReportIt! Plugin: not capturing/displaying total bandwidth for all data sources?

[jjasen]

I've filed an issue against Cacti ReportIt! here: https://github.com/Cacti/plugin_reportit/issues/101

But as a general gist, running reports -- either manually or scheduled -- not all data sources get populated with TDI/TDO. You can drill down into the data source, and get the 7200 second captures, but in the high level, TDI and TDO display N/A.

Is there a way to restore this functionality?

[jjasen]

This was working with Cacti 1.2.14 and ReportIt 1.1.3. Upgrading Cacti and the databases to 1.2.23 seems to have caused it to break.

[TheWitness]

I saw your GitHub bug on this too. Are there any errors in the Cacti.log when the report is running?

[jjasen]

2023-02-21 09:36:10 - CMDPHP SQL Backtrace: (/plugins/reportit/run.php[55]:calculation(), /plugins/reportit/run.php[78]:runtime(), /plugins/reportit/runtime.php[680]:db_execute(), /lib/database.php[355]:db_execute_prepared())
2023-02-21 09:36:10 - CMDPHP ERROR: A DB Exec Failed!, Error: Unknown column 'INF' in 'field list'
2023-02-21 09:36:10 - CMDPHP SQL Backtrace: (/plugins/reportit/run.php[55]:calculation(), /plugins/reportit/run.php[78]:runtime(), /plugins/reportit/runtime.php[680]:db_execute(), /lib/database.php[355]:db_execute_prepared())
2023-02-21 09:36:10 - CMDPHP ERROR: A DB Exec Failed!, Error: Unknown column 'INF' in 'field list'
2023-02-21 09:36:10 - CMDPHP SQL Backtrace: (/plugins/reportit/run.php[55]:calculation(), /plugins/reportit/run.php[78]:runtime(), /plugins/reportit/runtime.php[680]:db_execute(), /lib/database.php[355]:db_execute_prepared())
2023-02-21 09:36:10 - CMDPHP ERROR: A DB Exec Failed!, Error: Unknown column 'INF' in 'field list'