Database view giving error: Syntax Error or Access Rule Violation detected by database ((conn=395195) Unknown column 'cod.a_str_22' in 'on clause')

[TT3]

I am trying to create a database view. After specifying all the details, when I click on Try It link, I am getting below error.

Syntax Error or Access Rule Violation detected by database ((conn=395195) Unknown column 'cod.a_str_22' in 'on clause')

I have checked:

• There is no column named a_str_22 in the table which aliases cod.
• None of the where clause refers to a_str_22 column for table which aliases cod.
• The table which aliases cod, does not have any access restriction. I was able to create another view in the same scope.

Am I missing anything?

Note: Relevant answers/comment will be marked appropriately.

[Miguel Donayre]

I suggest opening a HI Support ticket. 

[TT3 · Accepted solution]

The fix was to update "order" column. So the table that is primary and have no dependency then it should be 100 and subsequent can be 200 and so on.

Thank you.