Hello!
Some times for particular date range Im getting Internal error with code 13.
My GAQL query:
SELECT
change_event.resource_name,
change_event.change_date_time,
change_event.change_resource_name,
change_event.user_email,
change_event.client_type,
change_event.change_resource_type,
change_event.old_resource,
change_event.new_resource,
change_event.resource_change_operation,
change_event.changed_fields,
campaign.id,
campaign.nameFROM change_event
WHERE
change_event.change_resource_type = 'CAMPAIGN'
AND
campaign.id IN (TEST_ID)
AND change_event.change_date_time <= '2021-07-02'
AND change_event.change_date_time >= '2021-06-23'
LIMIT 10
But if I change date range, i.e. to:
SELECT
change_event.resource_name,
change_event.change_date_time,
change_event.change_resource_name,
change_event.user_email,
change_event.client_type,
change_event.change_resource_type,
change_event.old_resource,
change_event.new_resource,
change_event.resource_change_operation,
change_event.changed_fields,
campaign.id,
campaign.nameFROM change_event
WHERE
change_event.change_resource_type = 'CAMPAIGN'
AND
campaign.id IN (TEST_ID)
AND change_event.change_date_time <= '2021-06-26'
AND change_event.change_date_time >= '2021-06-25'
LIMIT 10
Everything is OK
Im receiving this error only for campaigns of one particular account, there are no problems for campaigns from another accounts.