I have a BAQ that is popping a SQL error upon opening. We are on public cloud. How do I see this error so I can resolve?
System Monitor doesn’t appear to be it.
This is the error I get:
Text version for search engines:
Bad SQL statement.
Review the server event logs for details.
Usually a divide by zero issue but I’m not sure how you could get the actual error
Any way I can see the error log?
Try to add any calculated field and click check syntax, sometime it will give detailed error of BAQ.
Also, do you already have any calculated fields in your BAQ?
I’ve seen cases where, even though a BAQ will pass all the syntax checks
it may still throw similar errors intermittently when a record with a null value is encountered. Why I’ve gotten in the habit of handing nulls and zeros in calculated fields.
e.g. for a numrtoc calc field, I might do something like this
(case
when ISNULL(num01,0) > 0
AND ISNULL(num02,0) > 0
then (num01 / num02)
else 0
end)
or for a strings
when string01 > ‘’ then…
Do you mean after clicking “Test” or just when you open the BAQ?
It happens with I open the dashboard that the BAQ is based on.
I don’t believe it happens when I test the BAQ.
Contact suport to get the exact error from the log
There is a an option for Server Logs on the client. It has some of the logs…