Report plugin ''ReportIt" - v0.7.5a (released 23/12/11)

[in2deep]

Hi all, can you someone let me know why i'm get this error when I run the report "REPORTIT ERROR: No data items defined. Report[2] ".
Not sure why im getting this error. I followed step by step how to create report using the instruction below.


http://cdnetworks-us-1.dl.sourceforge.n ... uction.pdf

Installed ReportIt v0.7.3

Thanks for your help in advance.

Tho

[browniebraun]

Hi all, can you someone let me know why i'm get this error when I run the report "REPORTIT ERROR: No data items defined. Report[2] ".
Not sure why im getting this error. I followed step by step how to create report using the instruction below.


http://cdnetworks-us-1.dl.sourceforge.n ... uction.pdf

Installed ReportIt v0.7.3

Thanks for your help in advance.

Tho

Take a look at the list of report configurations. There should be a link named "add data items" at the end of the related row.
Click on that link and select the interfaces / objects you want to include.

Regards
-Andreas

[in2deep]

Hi Andreas, thanks for the reply.

I did included the data items but it's still prompt the same error.
Fyi, I have two cacti servers, and both have reportit plugin installed but only one of the host produces the report.
Still scratching my head because I have no idea how to troubleshoot the problem. I repeated the same steps like I did with the working server many times but still getting the same the result. Weir.

Tho

[zakk]

Anyone have any suggestions here? I'm having the exact same problem and cannot figure it out. I'm just trying to create a simple bandwidth report for my MPLS links. The data items are definitely added to the report config, but when I go to run it, I get:

#REPORTIT ERROR: No data items defined. Report[2]

I really appreciate any help!

[browniebraun]

Anyone have any suggestions here? I'm having the exact same problem and cannot figure it out. I'm just trying to create a simple bandwidth report for my MPLS links. The data items are definitely added to the report config, but when I go to run it, I get:

#REPORTIT ERROR: No data items defined. Report[2]

I really appreciate any help!

Hi,
To be honest I'm a little bit surprised, because that's the first time I've ever heard about an issues like this during the last 4 years.
In that case everybody(!), who is affected, should sent me an email including a debug file of that report, an export of the technical support page, a list of all installed plugins and a mysql dump of table "reportit_data_items".

Best regards and many thanks for your help
-Andreas

[noname]

@in2deep, @zakk:

I also followed the above document, then succeeded.
(I'm using Cacti 0.8.7g + PIA 2.9 + ReportIt 0.7.3)

Report Templates:


Report Configurations:

And when i clicked "edit(1)" link in the above screen, I can see the data item which I added..


To verify, try this query:

% mysql -uUSER -pPASS cacti -e 'SELECT * FROM reportit_data_items as a LEFT JOIN data_local as b ON (b.id=a.id) WHERE a.report_id=XXX;'

XXX is report ID. If you got the error "No data items defined. Report[2]", then ID is 2.

In my case,

Code: Select all

+----+-----------+-----------------------------+-----------+---------+------------+----------+----------+------+------------------+---------+---------------+------------+
| id | report_id | description                 | start_day | end_day | start_time | end_time | timezone | id   | data_template_id | host_id | snmp_query_id | snmp_index |
+----+-----------+-----------------------------+-----------+---------+------------+----------+----------+------+------------------+---------+---------------+------------+
| 27 |         1 | |d1|-|d2| |t1|-|t2| (|tmz|) | Monday    | Friday  | 00:00:00   | 24:00:00 | GMT      |   27 |               41 |       4 |             1 | 10101      |
+----+-----------+-----------------------------+-----------+---------+------------+----------+----------+------+------------------+---------+---------------+------------+

From the above result, I can see a data item associated to this report.
Its "datasource id" is 27 and "data template ID" is 41.
This data item is found by the below query:

% mysql -uUSER -pPASS cacti -e 'SELECT local_data_id,data_template_id,name_cache FROM data_template_data WHERE local_data_id=27 AND data_template_id=41;'

Code: Select all

+---------------+------------------+----------------------------+
| local_data_id | data_template_id | name_cache                 |
+---------------+------------------+----------------------------+
|            27 |               41 | Switch-1 - Traffic - Gi0/1 |
+---------------+------------------+----------------------------+

[zakk]

Hi Andreas,

Thank you for your quick reply. First off, it's now working. I'm not a systems guy (I'm an NE), so a lot of the mysql stuff is lost on me.

The SE that fixed the problem, tells me this: we're using mysql 5.5 and most of the sql stuff in Cacti is geared towards 5.1. So when it tries to create a new table it tries to declare it 'TYPE=MyISAM', when 5.5 requires it to be declared 'ENGINE=MyISAM'

In 5.5 maxValue is a reserved keyword so it choked on line 50 of reportit/lib_int/funct_runtime.php where the sql statement tried to create the variable 'maxValue'. I had to single quote the declaration: $sql = "SELECT c.field_value as 'maxValue', a.*


....those are my SE's words, copy/pasted, so hopefully that all makes sense to you as I won't have much else to contribute. I just wanted to let you know that it's working.

While I have your attention though, I'm having another Reportit problem and I was hoping you could direct me to a thread that talks about it, as I cannot seem to find one. I need to get the automated scheduler working and emailing daily reports. I'm pretty sure I have it all configured correctly and I'm able to manually generate reports and send test messages. The Thold plugin sends out automated email alerts just fine, but Reportit won't.

Where can I find instructions for getting this to work?

Thanks a million!

[in2deep]

I want to thanks Zakk and Andreas for your reply.

I tried Zakk solution by updated line 50 in func_runtim... and the error went away;however I still don't get report. Here is warning I get after run the report "Warning: Invalid argument supplied for foreach() in /var/www/cacti/plugins/reportit/cc_view.php on line 664".

I take a look at the at line 664 in cc_view.. but don't have any clue how to fix it. Any idea what I did wrong?

Tho

[browniebraun]

Hi Andreas,

Thank you for your quick reply. First off, it's now working. I'm not a systems guy (I'm an NE), so a lot of the mysql stuff is lost on me.

The SE that fixed the problem, tells me this: we're using mysql 5.5 and most of the sql stuff in Cacti is geared towards 5.1. So when it tries to create a new table it tries to declare it 'TYPE=MyISAM', when 5.5 requires it to be declared 'ENGINE=MyISAM'

In 5.5 maxValue is a reserved keyword so it choked on line 50 of reportit/lib_int/funct_runtime.php where the sql statement tried to create the variable 'maxValue'. I had to single quote the declaration: $sql = "SELECT c.field_value as 'maxValue', a.*


....those are my SE's words, copy/pasted, so hopefully that all makes sense to you as I won't have much else to contribute. I just wanted to let you know that it's working.

While I have your attention though, I'm having another Reportit problem and I was hoping you could direct me to a thread that talks about it, as I cannot seem to find one. I need to get the automated scheduler working and emailing daily reports. I'm pretty sure I have it all configured correctly and I'm able to manually generate reports and send test messages. The Thold plugin sends out automated email alerts just fine, but Reportit won't.

Where can I find instructions for getting this to work?

Thanks a million!

Did you create the correct crontab entries, which will execute the calculation of your reports?

Regards
-Andi

[browniebraun]

Many thanks to Zakk and in2deep,

I will upgrade my local MySQL server to 5.5.x and check 0.7.3 for all dependencies this weekend. A new minor release will be published next week.

Best regards
-Andi

[zakk]

Andi,

I'm able to manually generate a report, no problems there. It's just not auto-generating the reports and auto-emailing them out. Under the "Report Configurations" section, for the reports I have set up, there is a check mark under "scheduled". And within that reports configuration, under the "administration" tab, I've got:

Change Report Owner = admin
Enable Use of Graph Permissions = enabled
Scheduled Reporting - enabled
Frequency = daily
Auto Generated Data Items = NOT checked
Auto Generated Archive = off
Auto Generated Email = checked
Auto Generated Export = MS Excel 2003 XML

Under the Email tab, I have my email addresses specified.

Under the global "Settings" section, the "Reports" tab, the relevant options (as I see it) are set to:

Operator for Scheduled Reporting = Super User (admin)
Auto E-Mailing = enabled
Auto Exporting = enabled (and in the path specified on my Cacti server, there is nothing. Empty.)

So basically, I don't understand why it's not auto-generating these reports and emailing them to the recipients I've specified. It appears I have it set up correctly, but I must be missing something.

Thank you so much for your help!

Zakk

[browniebraun]

Andi,

I'm able to manually generate a report, no problems there. It's just not auto-generating the reports and auto-emailing them out. Under the "Report Configurations" section, for the reports I have set up, there is a check mark under "scheduled". And within that reports configuration, under the "administration" tab, I've got:

Change Report Owner = admin
Enable Use of Graph Permissions = enabled
Scheduled Reporting - enabled
Frequency = daily
Auto Generated Data Items = NOT checked
Auto Generated Archive = off
Auto Generated Email = checked
Auto Generated Export = MS Excel 2003 XML

Under the Email tab, I have my email addresses specified.

Under the global "Settings" section, the "Reports" tab, the relevant options (as I see it) are set to:

Operator for Scheduled Reporting = Super User (admin)
Auto E-Mailing = enabled
Auto Exporting = enabled (and in the path specified on my Cacti server, there is nothing. Empty.)

So basically, I don't understand why it's not auto-generating these reports and emailing them to the recipients I've specified. It appears I have it set up correctly, but I must be missing something.

Thank you so much for your help!

Zakk

Hey Zakk,

please ensure that you have configured the different cronjobs (Linux) or scheduled tasks (Windows) for that. Take a look at this posting. http://forums.cacti.net/viewtopic.php?p=87970#p87970

Regards
-Andi

[zakk]

Works! A HUGE thank you for your help. I won't be a Cacti newbie for much longer.

Best Regards,
Zakk

[browniebraun]

Works! A HUGE thank you for your help. I won't be a Cacti newbie for much longer.

Best Regards,
Zakk

You're welcome!
I know that ReportIt has a steep learning curve, but it offers many functionalities.

regards
-Andi

[unk]

Hi!

Thanks for this great plugin!
Im in need of the example below.
I would like to have the availibility in '%' of /node a month, as from what i can see is the answer on the picture below.



I would be very thankful if anyone could share it's Template.

Edit: I've solved my question.
See attachment.