DV360 Report Hanging and Failing

[Matthew Keeran]

Hi, 

One of our reports has been failing or taking hours when it is a very small amount of data (~6.5 MB) which previously only took ~6 mins to build.

This began happening during our morning runs on 09/08 and has been happening everyday since including today.
Our process times out before the files ultimately fail to be created so unfortunately I don't have an error message for you, it just keeps saying its in the queued state

• DCM Account ID - 485401
• Profile ID used in request call - 5090318
• Report ID and File ID of the affected report
  • Report ID: 631846354 File ID: 4270267149 or 4273055037

• File status is QUEUED
  

Let me know if you need any additional information.

Thanks,

Matt

[DCM API (DoubleClick Campaign Mgr)]

Hi Team,

Thank you for reaching out to the CM360 API support team.

Could you further elaborate on what exactly you are looking for from the CM360 API support team. If possible, please share the related screenshots  and API request in JSON format (complete HTTP request and body of the request) for further investigation. Please be informed that our team can only provide assistance with the technical issues related to the CM360 API.

You can send the details via Reply privately to the author option, or direct private reply to this email.

 

This message is in relation to case "ref:_00D1U1174p._5004Q2okcPl:ref"

Thanks,
 

DCM API Team

[Matthew Keeran]

We have not been able to do reporting on DV360 for over 4 days because of this issue, we would like the issue on the backend investigated and resolved please.

Our team has reported DV360 issues here before and has had them addressed, Is this not the place for DV360 support?

If not, could you please tell me where I should raise this issues?

Here is a screenshot showing the report ID I provided with many but not all of the failed files which should serve as a starting point for your investigation.

Its the backend thats the issue, not the request, but here is how we are making the request using the Python API

import dv360_report.util as util

queryId = 631846354

doubleclick_bid_manager = util.setup(args)

report_body = {}

dateRange =  {
                    'range': 'CUSTOM_DATES',
                    'customStartDate': {
                      'year': start_date.strftime("%Y"),
                      'month': start_date.strftime("%m"),
                      'day'  : start_date.strftime("%d")
                    },
                    'customEndDate': {
                        'year': end_date.strftime("%Y"),
                        'month': end_date.strftime("%m"),
                        'day'  : end_date.strftime("%d")
                    }
                }

            # Add the criteria to the report resource.
            report_body['dataRange'] = dateRange

path_report_file = doubleclick_bid_manager.queries().run(queryId=query_id,body = report_body).execute()
        logger.info('File with ID %s has been created.' % path_report_file['key']['reportId'])
        report_id = int(path_report_file['key']['reportId'])

query = doubleclick_bid_manager.queries().reports().get(queryId=query_id,reportId=report_id).execute()

status = query['metadata']['status']['state']
            if status == 'DONE':
                logger.info('File status is %s, ready to download.' % status)
                return query
            elif status not in ('QUEUED','RUNNING'):
                logger.error('File status is %s, processing failed.' % status)
                raise
            elif time.time() - start_time > MAX_RETRY_ELAPSED_TIME:
                logger.error('File processing deadline exceeded.')
                raise

[DCM API (DoubleClick Campaign Mgr)]

Hi Team,

Thank you for getting back to us.

Based on the information provided, I understand that you need assistance related to the DBM API. Kindly note, we can only assist with the technical queries/concerns related to CM360 API. I am routing this request to the DBM API team as they are best suited to assist you on this request.

[Matthew Keeran]

Is there a link to the DBM API Forum you can provide me or an DBM API support email for future reference?