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

Workato error
UndefinedColumn - Column does not exist

02Likely 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

  1. Verify the column names against the table schema.
  2. Check the input fields for unintended column names in Order by or Where clauses.
  3. Confirm with the database administrator that the columns exist.
  4. Refresh the recipe to update the schema from your connections if the recipe uses a datapill from a previous step.

04Official documentation

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

The iPaaS Brief

Subscribe to The iPaaS Brief.

The iPaaS newsletter for the people who run integrations. From iPaaS Group.

Free. You finish on theipaasbrief.com and confirm by email.