I am trying to run a custom report to report "Sum of Traffic by Developer App, Product, Proxy" for a duration of 1 Week and it timed out. Tried it multiple times adjusting the duration down and the only one that works without a timeout is '1 Hr' duration. I have set my aggregation level to 1 Day on all attempts and it still doesn't work. This is on prem Apigee environment. I have asked our admins and they indicated that the same problem exists for most any report they try to create as well.
What could be causing it? How can we get around it?
@Rajeev Chinnapareddy at what point does it timeout ? Default UI setting is 6 minutes, if it takes longer than that to retrieve the UI will timeout and is a parameter you can configure. Other piece to check it the IOPS on Postgres ? Also, what version of On premise are you running.
Did you find any solution to these timeouts? We're facing similar kind of situation with our on-premise (v4.17.09) installation.
Answer by Rajeev Chinnapareddy · Oct 31, 2017 at 04:02 PM
@ Christin Brown , @ rdoda Based on my observation, it's timing out after 2 minutes. The other questions about the versions, I would have to get that information from our admins or Let me know if there is a way to look it up thru Edge UI & I can check that. Thanks
Answer by spadmanabhan · Oct 31, 2017 at 05:03 PM
Do you have a rough idea of the TPS rate for your environment? Also, how are the analytics dashboards behaving for duration=1 day or longer?