Filling is not Allowed in Queries with Limit Exceeding 30000

Knowledge Drop

Last tested: Jul 24, 2019
 

This is error is in reference to a scheduled job failure. Instead of receiving the schedule, the schedule owner receives an email that the scheduled job has failed with the error message:

Error: Missing values for 'view_name.date_field' were not filled because filling is not allowed in queries with limit exceeding 30000

This is may be due to a pivoted date field with "Fill in Missing Dates" (default) enabled. Even if the displayed data is less than 200 rows and/or column limit is enabled, the schedule will still fail. By selecting "Remove Filled in Dates" from the dimension options, the schedule will send.

This content is subject to limited support.                

Version history
Last update:
‎06-14-2021 06:16 PM
Updated by: