The same code is not working in all related pages

Question

I managed to make a query that does data extractions and date formatting, the query works in few pages, but it shows error in the same sort of other pages.

Ideally in this case, the same query should work on all pages without making any kind of change.

Thanks and appreciate your taking time to help to answer this problem.

Gohil Jay · Answer

I tried to make some changes but it fails again and again and always shows the above-given error. 
Also, I checked the data from the data table and there everything is fine. (Since query takes only initial 11 letters.)

Brant Schroeder · Answer

@Gohil Jay

So the data is identical on both pages but it fails on one and not the other?  From the error it seems like the data is missing or what you are passing is not recognized as a string.

Gohil Jay · Answer

Hi Brant, 
here is the code and error pic. :)

SELECT T1.'overview',T1.'Status',T1.'ECU', T1.'Checked',

CASE

WHEN T1.'ECU'

THEN SUBSTR(T1.'ECU',1,11)

END AS 'ECU',

case

WHEN T1.'Checked'

THEN SUBSTR(T1.'Checked',1,11)

END AS 'Checked'

FROM T1

This is an error msg that appears in some pages, (where the working data is also same)