Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Analytics Report.Get not returning data and intermittently failing.

Avatar

Avatar
Validate 1
Level 1
chrisalvarespmg
Level 1

Like

1 like

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile

Avatar
Validate 1
Level 1
chrisalvarespmg
Level 1

Like

1 like

Total Posts

8 posts

Correct Reply

0 solutions
Top badges earned
Validate 1
Boost 1
View profile
chrisalvarespmg
Level 1

19-09-2019

We started noticing the Report.Get endpoint has stopped returning data as of 3 days ago with a: no_warehouse_data error message. The interesting part is when looking at the Adobe Analytics DataWarehouse tab in the UI, if you were to duplicate the report and have it emailed to you, it works and returns the data requested.

Making the following request will work and give back a valid report id:

{ reportSuiteID: '[redacted]',

  dateFrom: '2019-09-16',

  dateTo: '2019-09-17',

  dateGranularity: 'day',

  metrics:

   [ { id: 'event5' },

     { id: 'event7' },

     { id: 'event8' },

     { id: 'revenue' },

     { id: 'uniquevisitors' },

     { id: 'visits' },

     { id: 'orders' } ],

  elements:

   [ { id: 'mobiledevicetype', everythingElse: true },

     { id: 'trackingcode', everythingElse: true },

     { id: 'visitnumber', everythingElse: true },

     { id: 'trackingcode',

       classification: 'Tracking Code Classification 1',

       everythingElse: true },

     { id: 'trackingcode',

       classification: 'Tracking Code Classification 2',

       everythingElse: true } ],

  locale: 'en_US',

  currentData: true,

  source: 'warehouse',

  elementDataEncoding: 'utf8' }

But when querying the data, we getting the following message:

{

    "error": "no_warehouse_data",

    "error_description": "Warehouse request returned no data for time period",

    "error_uri": null

}

The interesting part here is calling the Request.Get about 5 times makes the report work and I am able to retrieve data, but refreshing again, and the report fails.

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar
Boost 1
Level 1
Jared_Stevens
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

1 solution
Top badges earned
Boost 1
Affirm 1
View profile

Avatar
Boost 1
Level 1
Jared_Stevens
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

1 solution
Top badges earned
Boost 1
Affirm 1
View profile
Jared_Stevens
Level 1

19-09-2019

I want to clarify Kevin's post -- we've identified the problem and made the change to fix it. The change isn't in production yet though. We're working to get approvals to get that pushed out ASAP.

Its worth noting that this error is intermittent - retrying the Report.Get() request 2-3 times will eventually find a healthy host and retrieve the data.

Either myself or someone from Customer Care will reply and indicate when it is fixed in production. Thank you for your patience!

Answers (3)

Answers (3)

Avatar

Avatar
Boost 1
Level 1
Jared_Stevens
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

1 solution
Top badges earned
Boost 1
Affirm 1
View profile

Avatar
Boost 1
Level 1
Jared_Stevens
Level 1

Like

1 like

Total Posts

2 posts

Correct Reply

1 solution
Top badges earned
Boost 1
Affirm 1
View profile
Jared_Stevens
Level 1

23-09-2019

Our change was deployed -- this should be resolved.

Avatar

Avatar
Boost 1
Level 1
kevinc62217343
Level 1

Like

1 like

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile

Avatar
Boost 1
Level 1
kevinc62217343
Level 1

Like

1 like

Total Posts

1 post

Correct Reply

0 solutions
Top badges earned
Boost 1
View profile
kevinc62217343
Level 1

19-09-2019

Hi all,

I got same issue and already raised issue with client care 3 days ago. Here is latest updates from client care @4:30pm EST 9/19/2019, "Engineering found a configuration problem and made a fix to the code today.

Avatar

Avatar
Give Back 5
Employee
ankits28281247
Employee

Likes

21 likes

Total Posts

80 posts

Correct Reply

24 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Boost 5
Boost 3
View profile

Avatar
Give Back 5
Employee
ankits28281247
Employee

Likes

21 likes

Total Posts

80 posts

Correct Reply

24 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back
Boost 5
Boost 3
View profile
ankits28281247
Employee

19-09-2019

There is an open issue at the moment on this and Engineering is looking into.

If you can provide your request header/body and the response headers and body that will be helpful. you can also raise a issue with clientcare for investigation with the details.