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