Expand my Community achievements bar.

SOLVED

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

Avatar

Level 1

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.
1 Accepted Solution

Avatar

Correct answer by
Level 1

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

View solution in original post

2 Replies

Avatar

Employee

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

Avatar

Correct answer by
Level 1

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