You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Article viewed by category report throws Query Size limitation error

edited Apr 5, 2019 9:45AM in Reporting & Analytics for B2C Service 2 comments

Summary

Article viewed by category report throws Query Size limitation error

Content

We have a report to show Articles viewed by category, this report shows sum of Number of Page Hits (sum(ans_stats.hits)/count(distinct categories.id)) for articles. This report was working fine previously but throws query size limitation error now. I understand this is because size of data was less previously and now the report query is not able to run because of query size limitation.

I have tried the following options but no success till now...

Restructured the table links between okcs_answers,ans_stats,removing Categories and okcs_content_category  table from the query

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!