[ZBX-15753] ORA-933 when using trends with zabbix plugin Created: 2019 Mar 04 Updated: 2019 Mar 05 Resolved: 2019 Mar 05 |
|
Status: | Closed |
Project: | ZABBIX BUGS AND ISSUES |
Component/s: | None |
Affects Version/s: | None |
Fix Version/s: | None |
Type: | Incident report | Priority: | Major |
Reporter: | Lefteris Tsekouras | Assignee: | Zabbix Support Team |
Resolution: | Duplicate | Votes: | 0 |
Labels: | None | ||
Remaining Estimate: | Not Specified | ||
Time Spent: | Not Specified | ||
Original Estimate: | Not Specified |
Issue Links: |
|
Description |
Grafana: 5.3.4 Hello. When I select the appropriate range on my dashboards to use trends (eg now -30d) I get “No data points” on my graphs. In Oracle’s alert log, I get the following messages, relevant to this: These errors are: So, the above query is not executed in Oracle: SQL> SELECT t.* FROM trends_uint AS t WHERE t.clock>=1536613200 AND t.clock<=1536614200 AND t.itemid=93624; “AS” should not be used for table aliases in Oracle. The correct syntax is: ITEMID CLOCK NUM VALUE_MIN VALUE_AVG VALUE_MAX |
Comments |
Comment by Andrei Gushchin (Inactive) [ 2019 Mar 05 ] |
Thank you for submitting the issue. It already fixed in |