How to eliminate Query error: 403 in Grafana? Example is a Substring

1

error
error1362×601 48 KB

I’m trying to receive a result similiar to ‘13:49:31’ in this panel. Here is the code:

select SUBSTRING(CONVERT(VARCHAR,DATEADD(HOUR,-3,SYSDATETIME())),12,8)

This is the message: “Query error: 403”

I copied the code and executed it at SQL Server Management Studio and it worked.

If I remove the substring function, it works. Like this "select CONVERT(VARCHAR,DATEADD(HOUR,-3,SYSDATETIME()))"

error2
error21338×542 32.4 KB

I found this problem on another panel. I have the same error and the panel works without order by.

2

error3
error31292×611 55.8 KB

3

Here is the query inspector:

{
“xhrStatus”: “complete”,
“request”: {
“method”: “POST”,
“url”: “api/tsdb/query”,
“data”: {
“from”: “1578020400000”,
“to”: “1578106799999”,
“queries”: [
{
“refId”: “A”,
“intervalMs”: 900000,
“maxDataPoints”: 100,
“datasourceId”: 1,
“rawSql”: “select SUBSTRING(CONVERT(VARCHAR,DATEADD(HOUR,-3,SYSDATETIME())),12,8)”,
“format”: “table”
}
]
}
},
“response”: “\n\n\n\n <html class=“no-js” lang=“en-US”> \n\nAttention Required! | Cloudflare\n<meta charset=“UTF-8” />\n<meta http-equiv=“Content-Type” content=“text/html; charset=UTF-8” />\n<meta http-equiv=“X-UA-Compatible” content=“IE=Edge,chrome=1” />\n<meta name=“robots” content=“noindex, nofollow” />\n<meta name=“viewport” content=“width=device-width,initial-scale=1,maximum-scale=1” />\n<link rel=“stylesheet” id=“cf_styles-css” href=”/cdn-cgi/styles/cf.errors.css" type=“text/css” media=“screen,projection” />\n\n<style type=“text/css”>body{margin:0;padding:0}\n\n\n<script type=“text/javascript” src="/cdn-cgi/scripts/zepto.min.js">\n<script type=“text/javascript” src="/cdn-cgi/scripts/cf.common.js">\n\n\n\n\n\n <div id=“cf-wrapper”>\n <div class=“cf-alert cf-alert-error cf-cookie-error” id=“cookie-alert” data-translate=“enable_cookies”>Please enable cookies.\n <div id=“cf-error-details” class=“cf-error-details-wrapper”>\n <div class=“cf-wrapper cf-header cf-error-overview”>\n <h1 data-translate=“block_headline”>Sorry, you have been blocked\n <h2 class=“cf-subheadline”><span data-translate=“unable_to_access”>You are unable to access indrabrasil.com.br\n \n\n <div class=“cf-section cf-highlight”>\n <div class=“cf-wrapper”>\n <div class=“cf-screenshot-container cf-screenshot-full”>\n \n <span class=“cf-no-screenshot error”>\n \n \n \n \n\n <div class=“cf-section cf-wrapper”>\n <div class=“cf-columns two”>\n <div class=“cf-column”>\n <h2 data-translate=“blocked_why_headline”>Why have I been blocked?\n\n <p data-translate=“blocked_why_detail”>This website is using a security service to protect itself from online attacks. The action you just performed triggered the security solution. There are several actions that could trigger this block including submitting a certain word or phrase, a SQL command or malformed data.

\n \n\n <div class=“cf-column”>\n <h2 data-translate=“blocked_resolve_headline”>What can I do to resolve this?\n\n <p data-translate=“blocked_resolve_detail”>You can email the site owner to let them know you were blocked. Please include what you were doing when this page came up and the Cloudflare Ray ID found at the bottom of this page.\n \n \n \n\n <div class=“cf-error-footer cf-wrapper”>\n

\n <span class=“cf-footer-item”>Cloudflare Ray ID: 54f4e5db78daf847\n <span class=“cf-footer-separator”>•\n <span class=“cf-footer-item”>Your IP: 200.159.15.248\n <span class=“cf-footer-separator”>•\n <span class=“cf-footer-item”>Performance & security by <a href=“https://www.cloudflare.com/5xx-error-landing?utm_source=error_footer” id=“brand_link” target="_blank">Cloudflare\n \n <span class=“cf-footer-separator”>•\n <span class=“cf-footer-item”>\n <select id=“lang-selector”>\n <option value="">Select a Language\n <option value=“en”>English\n <option value=“es”>Español\n \n \n \n

\n\n\n\n \n \n\n <script type=“text/javascript”>\n window._cf_translation = {};\n window._cf_translation.locale = ‘en’;\n window._cf_translation.blobs = {};\n\n\n\n\n"
}