QML Report execution is taking more time to generate View based where used report

[GL_9568686]

I am using Windchill PDMLink Release 12.0 and Datecode with CPS 12.0.2.18

Single Level where Used QML Report is a customized report. as per the requirement, users wants to get the Single Level Where Used based on the View. Report is modified and during execution, it is taking more than 45 mins to generate the report.


Here are the errors that I faced
Report execution is taking more than 45 mins. Need help to find out the root cause

[avillanueva]

Need way more information than that. how about showing the QML report or at least the table joins? It likely is producing a malformed query that is boiling the ocean in the database. What inputs are they using? Are they asking for a specific part or all parts?