Hi Team,
I am getting the follwing error while executing the table. Please note i do not have a column named ‘ORDER’. I have no idea what it is refering to.
Issue with table execute
Userlevel 6
+5
Hi
I would assume it is realated to a lookup of some sort or a custom transformation.
It all gets converted to SQL and order is when something is being set to ORDER BY.
Is there anything you use that fits this?
Userlevel 3
+1
Then check your custom transformations. Or fixed transformations when you have a condition on a fixed value or custom value. and it's a string value check if you in the condition you didn't set the string value with '’ tx gives those quotes automaticly and if you add them it gives errors.
it is a simple view which i am trying to read, sync in ODX is working fine &am able to read the data in preview. When i am trying to add this table in DSA, deploy works while execute throws this error
Deleting the table & readding resolved the issue. thanks
Userlevel 3
+1
Did you have this table already in your dsa? Try to add a table with a new name and put it on simple mode. So first right click on your data warehouse and select add new table. Then drag it from the odx to the new table. go to settings and under the setting simple mode put it on enabled.
Reply
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.