A schedule that had been running successfully is now failing with data type errors such as “Unsupported date-time class ‘character’.”, "do not know how to convert 'x' to class Date”, or "Can't join x$id with y$id due to incompatible types"

Issues
#1

If a schedule that was working previously starts failing with a data type error like the following;

  • "Unsupported date-time class ‘character’.
  • “do not know how to convert ‘x’ to class Date”
  • “Can’t join x$id with y$id due to incompatible types”

the data type of the source data may have changed. The main causes and solutions depend on the type of data source being used.

  • If a database is the data source:
    The column definition may have been changed by the database administrator. In this case, reach out to the administrator to confirm the column settings.
  • If Google Sheets or Excel files are the data source:
    The issue may be due to recent data entries that don’t match the expected format, which caused the data type of the column to change. A common cause is when a non-date value is entered into a column that expects dates, making it no longer recognized as a date type. Check the most recent entries in the data source for any incorrect values.
  • If a CSV file is the data source:
    The problem could be due to an incorrect number of separators (commas, etc.) in recent data entries, caused by mistakes in input. This can result in unexpected data being added to columns. Review the most recent entries in the CSV file to ensure the data is formatted correctly.