WRS endpoints for reporting is unresponsive

[Yognalawade]

Hello Experts,

The Reporting Domain (v1) of Windchill REST Services is having errors responding to the /ReportTemplates endpoint. The query was running from long time for specific users and there are several errors in the method server log around that time.

We do not have any custom WRS domains. Noticed many errors/warnings like Delegate not found for selector/couldn't find the imported domain.

Since, Report Template represents Windchill object that is a saved query, that can be used to generate and run a query. The ReportTemplate entity represents Persistable information about report templates.

Every Report template object is represented as an entity type in metadata with QML attributes as its Properties. Report templates are non-persistable entities. Report templates are auto generated based on the number of report templates that exist.

So, having below questions: 

• Is there anything about a report's QML that would slow down the API?
• Or does the API call actually run _all_ of the reports?

Noticed,  Removing 6 custom report templates (which were not being called through WRS) made the Reporting domain respond in a manageable time, from more than 20 minutes to about 5 seconds.

The code uses GET v1/Reporting/ReportTemplates and
POST v1/Reporting/ReportTemplates('xxx')/PTC.Reporting.ExecuteReportTemplate.

This issues seems to be related to executing OOTB ExecuteReportTemplate.

Looking for guidance how the report queries get executed for QML Reports in Reporting domain. 

Regards,

Yogesh 

[HelesicPetr · Accepted solution]

Hi @Yognalawade 

If any report is not well designed (written) then it can be running forever in never ending loop.

So it seams that your report template could case something like that if you remove them and now it works. 

PetrH

[tarik.wifak.p]

Does the report work correctly from the Reports utility ? If yes, is it slow too or generate same errors? 

Also check https://www.ptc.com/en/support/article/CS399283

[rleir]

Which version of Windchill do you have?

Which version of WRS ? Go to

yourdomain.com/Windchill/netmarkets/html/wrs/doc.html

At the bottom of the page there is a link to 

https://support.ptc.com/help/windchill_rest_services/r2.5/en/

In the above you can see it's version 2.5.

Or go to 

---

---

Just one more question: do you see errors in the log when you try to run a report like this?