cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Community Tip - Visit the PTCooler (the community lounge) to get to know your fellow community members and check out some of Dale's Friday Humor posts! X

Translate the entire conversation x

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

GL_9568686
3-Newcomer
3-Newcomer
‎Feb 25, 2025 07:20 AM
‎Feb 25, 2025 07:20 AM

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

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
0 Kudos
Notify Moderator
1 REPLY 1
avillanueva
23-Emerald I
23-Emerald I
(To:GL_9568686)
‎Feb 25, 2025 07:35 AM
‎Feb 25, 2025 07:35 AM

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?

0 Kudos
Notify Moderator
Announcements
Contact Community Management
Top Tags