search

Icinga / icingaweb2-module-idoreports

Icinga IDO Reports provides host and service availability reports for Icinga based on the monitoring database (IDO).
GNU General Public License v2.0
34 stars 13 forks source link

SQLSTATE[22000]: Data exception: 7 ERROR #35

Closed adtalmeda closed 2 years ago

adtalmeda commented 4 years ago

Describe the bug

I'm using the postgres version. When I try to view any Host SLA report, I get the below error no matter which option I choose. Service SLA report works fine.

SQLSTATE[22000]: Data exception: 7 ERROR: range lower bound must be less than or equal to range upper bound CONTEXT: SQL function "idoreports_get_sla_ok_percent" statement 1, query was: SELECT h.display_name AS host_display_name, h.display_name AS host_display_name, idoreports_get_sla_ok_percent(ho.object_id, '2020-04-23 00:00:00', '2020-04-23 15:42:33', NULL) AS sla FROM icinga_objects AS ho INNER JOIN icinga_hosts AS h ON h.host_object_id = ho.object_id AND ho.is_active = 1 AND ho.objecttype_id = 1 ORDER BY LOWER(h.display_name) ASC (Pdo.php:225)

0 /usr/share/icingaweb2/library/vendor/Zend/Db/Statement.php(297): Zend_Db_Statement_Pdo->_execute(Array)

1 /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Abstract.php(470): Zend_Db_Statement->execute(Array)

2 /usr/share/icingaweb2/library/vendor/Zend/Db/Adapter/Pdo/Abstract.php(238): Zend_Db_Adapter_Abstract->query('SELECT h.displa...', Array)

3 /usr/share/icingaweb2/modules/idoreports/library/Idoreports/IdoReport.php(190): Zend_Db_Adapter_Pdo_Abstract->query(Object(Zend_Db_Select))

4 /usr/share/icingaweb2/modules/idoreports/library/Idoreports/HostSlaReport.php(85): Icinga\Module\Idoreports\IdoReport->fetchHostSla(Object(Icinga\Module\Reporting\Timerange), Array)

5 /usr/share/icingaweb2/modules/idoreports/library/Idoreports/IdoReport.php(29): Icinga\Module\Idoreports\HostSlaReport->fetchSla(Object(Icinga\Module\Reporting\Timerange), Array)

6 /usr/share/icingaweb2/modules/reporting/library/Reporting/Report.php(293): Icinga\Module\Idoreports\IdoReport->getHtml(Object(Icinga\Module\Reporting\Timerange), Array)

7 /usr/share/icingaweb2/modules/reporting/application/controllers/ReportController.php(42): Icinga\Module\Reporting\Report->toHtml()

8 /usr/share/icingaweb2/library/vendor/Zend/Controller/Action.php(507): Icinga\Module\Reporting\Controllers\ReportController->indexAction()

9 /usr/share/php/Icinga/Web/Controller/Dispatcher.php(76): Zend_Controller_Action->dispatch('indexAction')

10 /usr/share/icingaweb2/library/vendor/Zend/Controller/Front.php(937): Icinga\Web\Controller\Dispatcher->dispatch(Object(Icinga\Web\Request), Object(Icinga\Web\Response))

11 /usr/share/php/Icinga/Application/Web.php(300): Zend_Controller_Front->dispatch(Object(Icinga\Web\Request), Object(Icinga\Web\Response))

12 /usr/share/php/Icinga/Application/webrouter.php(99): Icinga\Application\Web->dispatch()

13 /usr/share/icingaweb2/public/index.php(4): require_once('/usr/share/php/...')

14 {main}

To Reproduce

Steps to reproduce the behavior:

  1. Create any SLA Host Report in Icinga
  2. Open/ View the report in Icinga

Expected behavior

I'd get a normal report just like when I view the Service SLA reports

Screenshots

idoreportserror

If applicable, add screenshots to help explain your problem.

Your Environment

Additional context

Add any other context about the problem here.

bluthg commented 4 years ago

Hi!

Could you try to narrow this down to the hosts that triggers it and provide some test data? Are any downtimes (icinga_downtimehistory) or "out of SLA"s (icinga_outofsla_periods) defined around your report time?

adtalmeda commented 4 years ago

bluthg,

I did not have anything on the filter. I don't have usage documentation and I thought I could leave it blank like the Service SLA, which works with a blank filter. I added filer "host_name=" and got results. I guess I just need a guide. Thank you.

bluthg commented 4 years ago

Well, it should work nonetheless... I reckon you have more than one hosts? If so, mind going through them and see if one triggers the above error?

adtalmeda commented 4 years ago

yes, I have more than one host. So right now, it works if I specify a host/ group.

On Mon, Apr 27, 2020 at 9:42 AM bluthg notifications@github.com wrote:

Well, it should work nonetheless... I reckon you have more than one hosts?

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/Icinga/icingaweb2-module-idoreports/issues/35#issuecomment-620100755, or unsubscribe https://github.com/notifications/unsubscribe-auth/AO5M465XRCQMLEUP6DTN3C3ROWYWTANCNFSM4MPUOU4Q .

phamlankt commented 4 years ago

Hi adtalmeda,

could you please let me know how you get the icinga reporting 0.10.0 (postgres version)? i also use postgres and dont want to switch to mysql.

Thanks!

adtalmeda commented 4 years ago

Its github has a postgres branch:

https://github.com/Icinga/icingaweb2-module-reporting/tree/feature/postgresql

I cloned it to my module by doing: git clone https://github.com/Icinga/icingaweb2-module-reporting.git --branch "feature/postgresql" reportingpostgresql

On Thu, May 28, 2020 at 10:09 AM phamlankt notifications@github.com wrote:

Hi adtalmeda,

could you please let me know how you get the icinga reporting 0.10.0 (postgres version)? i also use postgres and dont want to switch to mysql.

Thanks!

— You are receiving this because you authored the thread. Reply to this email directly, view it on GitHub https://github.com/Icinga/icingaweb2-module-idoreports/issues/35#issuecomment-635479069, or unsubscribe https://github.com/notifications/unsubscribe-auth/AO5M467ZM6VMHH72KUAOVSDRT2LEPANCNFSM4MPUOU4Q .

lippserd commented 4 years ago

Hi @adtalmeda,

The reporting feature has just been merged into the master branch.

Any chance you found out which host or service leads to this error?

All the best, Eric

nilmerg commented 2 years ago

No feedback. Closing.