Error: Missing select parameter : while fetching analytics data from management server on 13 node cluster

Google Cloud Apigee
1

We are hitting the Management server to fetch the analytics data.

URL is as follows:

https://MS:port/v1/o/xxx/e/xxx/stats/messageview/?timeRange=1%2F1%2F2014%200%3A0%3A0~4%2F8%2F2015%206%3A42%3A41&realtime=true&limit=1000&offset=0

We have a 13 node setup with 2 management servers and 2 analytical servers.

The above URL works fine in an 2 node setup but it fails on a 13 node setup with the following error

{ code: “Missing select parameter” message: “Missing select parameter” contexts: [0] }

Please let know what parameter I am missing here?

2

@asurajpai, The API you mentioned should work irrespective of number of nodes you have . It works well for me .

Can you try below and see what response you get https://MS:port/v1/o/xxx/e/xxx/stats/messageview/ without any query params and

https://MS:port/v1/o/xxx/e/xxx/stats/messageview?timeUnit=day&timeRange=02/14/2015%2005:30~03/02/2015%2001:30&select=sum(message_count)

Check this for more info http://apigee.com/docs/analytics-services/reference/analytics-reference

1 Like
3

This is a new behavior in SP1 <apigee-edge-4.15.01.00-SUSE> where the analytics data to retrieve data, in the url there is a change.

In SP0 we were passing in the URL as

https://MP:port/v1/o/xx/e/xx/stats/messageview/?timeRange=1%2F1%2F2014%200%3A0%3A0~4%2F8%2F2015%206%3A42%3A41&realtime=true&limit=1000&offset=0

After the messageview you need not pass the / and append the ?timeRange directly. Hence closing the case with the solution that the URL to be used in SP1 is https://MP:port/v1/o/xx/e/xx/stats/messageview?timeRange=1%2F1%2F2014%200%3A0%3A0~4%2F8%2F2015%206%3A42%3A41&realtime=true&limit=1000&offset=0