Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
Article viewed by category report throws Query Size limitation error — Cloud Customer Connect
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

Received Response
24
Views
2
Comments
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!