Dear Fellows,
We encounter a problem when starting a Box and Whisker plot, Namely;
Error setting Box and Whisker data. Data contains NULL values.
The problems is that our data contains no NULL values.
The Query being used ls the following:
SELECT *
FROM
(SELECT Cavity,
round(Label_back,1) AS Label_back, Limitmin_LB, Limitmax_LB FROM “3DData”
) AS RawData
Where Label_back is not null
Does anybody has a clue for us to solve this anoying error
Thanks in Advance
Why are you using a sub query here?
SELECT Cavity, round(Label_back,1) AS Label_back, Limitmin_LB,Limitmax_LB FROM 3DData
Will return exactly the same set.
Also, I don’t believe that the Table Name should be in quotes.
You are right about the subquery which is not nessassary but i wanted to be sure that there are no NULL values in the table I provide to the Box Whisker. The table name needs to be in double quotes…
Then do this:
SELECT Cavity, round(Label_back,1) AS Label_back, Limitmin_LB,Limitmax_LB
FROM "3DData"
WHERE Label_back IS NOT NULL
What DB are you using?
If you must use the double quotes, then the table was created with a quoted identifier, in which case you must insure the case sensitivity is correct. Does the table name "3DData" match the table name exactly and for case?
If you can avoid using quoted identifiers I would recommend it. It is generally not best practice to use them and some tools may not support their use. Use unquoted identifiers and everyone's life will be easier.
Without the Quotes I get the following error:
Error running query: SELECT * FROM 3DData Incorrect syntax near ‘3’.
Not surprising, table names should not start with a decimal number, so when the table was created it was undoubtedly created as a quoted identifier.
Are you certain there are no NULL values in the table?
Have you ran the following query in the Query Browser to see if it returns rows:
SELECT Cavity, round(Label_back,1) AS Label_back, Limitmin_LB,Limitmax_LB
FROM "3DData"
WHERE Label_back IS NULL
Where as the following query:
SELECT Cavity, round(Label_back,1) AS Label_back, Limitmin_LB,Limitmax_LB
FROM “3DData”
WHERE Label_back IS not NULL
delivers:
It seams like an annoying failure of ignition working with the Box plot
Your query checks for NULL in Label_back, but a null value in Limitmin_LB or Limitmax_LB can also cause this error. I’d try changing your WHERE clause in the query browser to
WHERE Label_back IS NULL or Limitmin_LM IS NULL or Limitmax_LB IS NULL
to see where the bad data is.
I really think it’s a bug in Ignition
In that case, can you file a support ticket? I’ve looked at the code and I don’t see any way this error can come up without a NULL value somewhere in your data (I missed Cavity in your query – hopefully there are no NULLs there). Because I can’t see a way this can happen, I have no idea how to replicate the issue. If you file a ticket with support they can work with you to figure out how this is happening and we can fix it.
Hi Kathy i have made a simple Memory tag in an empty project and opened a Box Whisker plot but it results in exactly the same failure. Is it possible for you to check if the failure also exists in the last version of Ignition?
