Knowledge Drop

Filling is not Allowed in Queries with Limit Exceeding 30000

  • 15 June 2021
  • 0 replies
  • 195 views

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.                

 

 


0 replies

Be the first to reply!

Reply