A schedule fails with the error “string must be a vector, not a function.”

If a schedule fails with an error message containing “string must be a vector, not a function” like the following, it may be caused by a missing column.

Error in filter(., str_detect(title, "test")) :
Caused by error in stringr::str_detect():
! string must be a vector, not a function.

The error message does not say “no such column” because a function with the same name exists. In the example above, since the column ‘title’ is missing, R instead finds a function called ‘title’ and tries to use it.

To resolve this issue, follow these steps:

  1. Open Exploratory Desktop, select the relevant data frame, and re-import the data.
  2. Check for missing columns and fix them if needed. The column may have been renamed or removed due to changes in the data source.
  3. Republish the content, then open the Schedule dialog, click the “Run Immediately” button and confirm whether the issue has been resolved.