Hi All
Thanks in advance.I am using an SQL statement where I am passing some Inputs inside query.All the inputs are correct passing I have debugged but still getting the same error.SQL query does not show any warnings and structure is also correct.
I cannot provide screen shot of my query due to business.
Hi @Atal Sharma ,
Just check the Output Structure and its Attributes Datatypes Should be same whatever Select by your query.
Like in Entity one attribute have text datatype and Inside Structure using Integer.
I am not sure without seeing query but it can be a one case.
Hi,
As Rahul suggested its due to mismatch of data type. If its not possible for you to share the query here then I would suggest you should try with some static values in input params and try to find out the difference. Hope it will help to find the buggy input param value.
regards
Hey, are you using a structure as the output structure? The issue is likely due to the order of attributes in your structure and SELECT. They need to match.