Workato · Database connectors
UndefinedColumn - Column does not exist
Short answer
UndefinedColumn - Column does not exist means the database cannot find a column named in the step's SQL. It often happens after a column in the underlying table was renamed, so check the names and refresh the recipe's schema.
VerifiedLast verified
01Error text
UndefinedColumn - Column does not exist02Likely causes
- A column name in the SQL does not match any column in the table.
- An input field carries an unintended column name in an Order by or Where condition.
- The schema from a previous step is outdated because the underlying table changed its column names.
03How to fix it
- Verify the column names against the table schema.
- Check the input fields for unintended column names in Order by or Where clauses.
- Confirm with the database administrator that the columns exist.
- Refresh the recipe to update the schema from your connections if the recipe uses a datapill from a previous step.
04Official documentation
→Related errors
- No such column errorNo such column error in the Query lists action of SQL Collection by Workato means the query names a column that the list does not have. Use the column's API name in the query, not its label name.
- Undefined method for nil:NilClassUndefined method for nil:NilClass means a formula ran on a datapill that had no value at runtime. Add the & safe navigation operator to the formula, for example [Datapill]&.capitalize, so it is skipped when the datapill is null.
Test every fix in a non-production environment before you apply it to production. See how entries are verified.
More for Workato work:Open Workato jobsWorkato rates and salariesHire a senior Workato developer