Extracting amo prefixed elements and metric from the Analytics API gives API Error [500]: Warehouse request failed

tony_edward 08-12-2016

The body (payload) of the request is as follows:

Note that the ReportSuite is obfuscated.

{
  "reportDescription": {
    "metrics": [
      {
        "id": "amo_impressions"
      },
      {
        "id": "amo_clicks"
      },
      {
        "id": "amo_cost"
      },
      {
        "id": "amo_conversions"
      }
    ],
    "source": "warehouse",
    "elements": [
      {
        "id": "amo_cid"
      }
    ],
    "reportSuiteID": "txxxxxx-xxxxxx-xxxxxxl",
    "dateGranularity": "day",
    "dateTo": "2016-12-08",
    "dateFrom": "2016-12-07"
  }
}

Logged = True 2016-12-08_211010: Request Successful Logged = True 2016-12-08_211010: Polling for reportId 1720189127
Logged = True 2016-12-08_211010: Getting Page 1 of Report Adobe_Analytics_Metrics
Logged = True 2016-12-08_211016: Response [400]: Report not ready waiting for 2.7339381395 second
Logged = True 2016-12-08_211023: Response [400]: Report not ready waiting for 4.51874212309 seconds 
Logged = True 2016-12-08_211032: Response [400]: Report not ready waiting for 6.27918222899 seconds 
Logged = True 2016-12-08_211043: Response [400]: Report not ready waiting for 8.34212240084 seconds 
Logged = True 2016-12-08_211056: Response [400]: Report not ready waiting for 10.4209678434 seconds 
Logged = True 2016-12-08_211114: Response [400]: Report not ready waiting for 12.7341329903 seconds 
Logged = True 2016-12-08_211131: Response [400]: Report not ready waiting for 14.7739198844 seconds 
Logged = True 2016-12-08_211150: Response [400]: Report not ready waiting for 16.6802017544 seconds 
Logged = True 2016-12-08_211211: Response [400]: Report not ready waiting for 18.8112416824 seconds 
Logged = True 2016-12-08_211234: Response [400]: Report not ready waiting for 20.4669947937 seconds 
Logged = True 2016-12-08_211257: Response [400]: Report not ready waiting for 22.358385427 seconds 
Logged = True 2016-12-08_211324: Response [400]: Report not ready waiting for 24.9906917413 seconds
Logged = True 2016-12-08_211353: Response [400]: Report not ready waiting for 26.5505271272 seconds
Logged = True 2016-12-08_211423: Response [400]: Report not ready waiting for 28.1055871645 seconds
Logged = True 2016-12-08_211456: Response [400]: Report not ready waiting for 30.8292791309 seconds
Logged = True 2016-12-08_211532: API Error [500]: Warehouse request failed

 

I can extract many other elements and metrics from the warehouse without any issues, it seems to only affect any of the elements and metrics from the Adobe Media Optimizer.

Accepted Solutions (1)

Accepted Solutions (1)

tony_edward 03-01-2017

Hi TanmayM,

I removed the 

 "source": "warehouse",

object and it works fine now.

It may be an issue in the API that is causing it to fail if source is specified.

Tony

Answers (1)

Answers (1)

TanmayMathur
Community Manager
11-12-2016

Hi Tony,

Welcome to the Analytics Community. 

The 500 error is an internal server error which causes a "500 Query Error" status. You can request more information about that using the x-error parameter described here so that we can debug it - http://microsite.omniture.com/t2/help/en_US/insight/qryapi/index.html#The_HTTP_Protocol

Hope this helps