Change Status Service suffers from daylight savings time bug

[Jonathan Stack]

Hello,

when executing the following query:
SELECT change_status.resource_name, change_status.last_change_date_time, change_status.resource_type, change_status.ad_group_criterion, change_status.resource_status FROM change_status WHERE change_status.last_change_date_time >= '2021-11-07 01:59:59.9999999' AND change_status.last_change_date_time <= '2021-11-08 12:00:51.7769511' AND change_status.resource_type = 'AD_GROUP_CRITERION' ORDER BY change_status.last_change_date_time LIMIT 10000
we receive data starting with last_change_date_time beginning with values '2011-11-07 01:10:50.726134'

however for query
SELECT change_status.resource_name, change_status.last_change_date_time, change_status.resource_type, change_status.ad_group_criterion, change_status.resource_status FROM change_status WHERE change_status.last_change_date_time >= '2021-11-07 02:00:00.0000000' AND change_status.last_change_date_time <= '2021-11-08 12:00:51.7769511' AND change_status.resource_type = 'AD_GROUP_CRITERION' ORDER BY change_status.last_change_date_time LIMIT 10000
we receive only one record beginning at  2021-11-08 09:22:23 Please draw your attention to the first query where specifically we ask for data change_status.last_change_date_time >= '2021-11-07 01:59:59.9999999' 

yet receive data with timestamp less than that filter

this results in a time loop where we take the last received timestamp in a batch for 10k and use that in the next query for the next batch of 10k only to get the same batch we just requested. We are stuck in a time loop. 

[Google Ads API Forum Advisor]

Hi Jonathan,

For us to assist you further, could you please provide the following details via Reply privately to author option? If this option is not available, then send it instead on this email address googleadsa...@google.com.​​​​​​

• Customer ID
• login-customer-id
• complete 2 GAQL 
• complete logs (request and response with request-id)?

Logging can be enabled by navigating to the Client libraries > Your client library (ex. Java) > Logging documentation, which you can access from this link.

Regards,

Reminder: Share your feedback about the Google Ads (AdWords) API! Take the 2021 Google Ads API and AdWords API Annual Survey
 

Teejay Wennie Pimentel Google Ads API Team

 

ref:_00D1U1174p._5004Q2R7O7o:ref