Few offline_user_data_job are in pending status for long time after submitting for running

[Paid Media]

Hi Team,

We need to upload the millions of customers' PII data to the user list of type CUSTOMER_MATCH_USER_LIST. 

As part of this, we are submitting thousands of https://developers.google.com/google-ads/api/fields/v9/offline_user_data_job jobs. Using follow java code.

String audienceId = statusAwareUserDataOperation.getAudienceAction().getAudienceId();
String customerId = credentials.getCustomerId();
OfflineUserDataJob offlineUserDataJob = OfflineUserDataJob.newBuilder()
        .setType(OfflineUserDataJobTypeEnum.OfflineUserDataJobType.CUSTOMER_MATCH_USER_LIST)
        .setCustomerMatchUserListMetadata(CustomerMatchUserListMetadata.newBuilder()
        .setUserList(ResourceNames.userList(Long.valueOf(customerId), Long.valueOf(audienceId)))).build();

try (OfflineUserDataJobServiceClient offlineUserDataJobServiceClient = googleAdsClient.getLatestVersion().createOfflineUserDataJobServiceClient()) {
    // Issues a request to create the offline user data job.
    CreateOfflineUserDataJobResponse createOfflineUserDataJobResponse = offlineUserDataJobServiceClient.createOfflineUserDataJob(customerId, offlineUserDataJob);
    String offlineUserDataJobResourceName = createOfflineUserDataJobResponse.getResourceName();
    AddOfflineUserDataJobOperationsRequest addOfflineUserDataJobOperationsRequest = AddOfflineUserDataJobOperationsRequest.newBuilder()
            .setResourceName(offlineUserDataJobResourceName).setEnablePartialFailure(true)
            .addAllOperations(operations).build();

    // Issues a request to add the operations to the offline user data job.
    AddOfflineUserDataJobOperationsResponse response = offlineUserDataJobServiceClient.addOfflineUserDataJobOperations(addOfflineUserDataJobOperationsRequest);

    // Issues an asynchronous request to run the offline user data job for executing all added operations.
    offlineUserDataJobServiceClient.runOfflineUserDataJobAsync(offlineUserDataJobResourceName);
    return new ImmutablePair<>(response,offlineUserDataJobResourceName);
}

runOfflineUserDataJobAsync method successfully invoked for all these thousands of jobs. 

Issue:- 

A few jobs out of these thousands of jobs submitted for running are still pending status for more than 48 hours  when queried offline_user_data_job with offline job resource id.

Is this behavior is expected or let us know if any correction required. 

[Paid Media]

Adding more details to the post
We are also maintaining the list of all the resource IDs generated for each job. So if we have submitted 1000 offline use data job requests, then we have 1000 resource ids in a list.
We are querying the status of these jobs at frequent intervals using the following GQL.

SELECT offline_user_data_job.resource_name, offline_user_data_job.id, offline_user_data_job.status, offline_user_data_job.type, offline_user_data_job.failure_reason FROM offline_user_data_job WHERE offline_user_data_job.resource_name IN ('customers/1558465821/offlineUserDataJobs/18772471223')

We see that most of the jobs have been completed but few have been stuck. For the stuck ones when we try to query status after 24 hours and 48 hours, sometimes we get no result in the response, and sometimes we get the PENDING status.
Could you please let us know what's wrong with these jobs? Why sometimes we are not getting any results from the status query? and why some time jobs are stuck in PENDING status even after 24 hours?

[Google Ads API Forum Advisor]

Hello,

Thanks for reaching out. Can you please reply privately with the complete request and response logs associated with the jobs that are stuck in a pending state?

Thanks,
Matt
Google Ads API Team

Matt Google Ads API Team

ref:_00D1U1174p._5004Q2YlnlD:ref

[Ngon Nguyen]

Chào mừng bạn đến với bảng nhớ tạm của Gboard, bất kỳ văn bản nào bạn sao chép sẽ được lưu tại đây.Sử dụng biểu tượng chỉnh sửa để ghim, thêm hoặc xóa đoạn.Nhấn vào một đoạn để dán vào hộp văn bản.Chạm và giữ một đoạn để ghim đoạn đó. Các đoạn đã bỏ ghim sẽ bị xóa sau 1 giờ.

Vào 14:58, Th 4, 16 thg 3, 2022 Paid Media <paid.m...@gmail.com> đã viết:

--
--
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
Also find us on our blog:
https://googleadsdeveloper.blogspot.com/
=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~=~
 
You received this message because you are subscribed to the Google
Groups "AdWords API and Google Ads API Forum" group.
To post to this group, send email to adwor...@googlegroups.com
To unsubscribe from this group, send email to
adwords-api...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/adwords-api?hl=en
---
You received this message because you are subscribed to the Google Groups "Google Ads API and AdWords API Forum" group.
To unsubscribe from this group and stop receiving emails from it, send an email to adwords-api...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/adwords-api/96ad0032-c064-4073-a901-1340fea22dcbn%40googlegroups.com.