Forum Discussion
Advocate IIView Errors. OK, Where are they?
Helper IWhen you find the row with the error, then what? Nothing really tells you what's wrong with it. Just that there's an error somewhere in that row.
In the query editor, if you scroll through the columns, there should be at least one column that says "Error" in some or all of the rows. Then click in the empty space next to the word to see a description of the error at the bottom. Most of the time the error is caused by a problem with the data type the column is set to - like text in a date column. Next you should go back to the original table that had the errors and fix them there. Look for the earliest step where that column was changed to that data type, and change it to a text column or replace the values with null or blanks. Then see if the rows in the errors query are now empty. If not, keep looking for data type conflicts.