Skip to main content
Y
Yognalawade17-Peridot
17-Peridot
May 15, 2024
Solved

WRS endpoints for reporting is unresponsive

  • May 15, 2024
  • 3 replies
  • 1092 views

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 

Best answer by HelesicPetr

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

3 replies

HelesicPetr
22-Sapphire II
HelesicPetr22-Sapphire IIAnswer
22-Sapphire II
May 15, 2024

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

    T
    tarik_p14-Alexandrite
    14-Alexandrite
    May 18, 2024

    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

    R
    rleir17-Peridot
    17-Peridot
    May 23, 2024

    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 

    rleir_0-1716477925515.png

    ---

    rleir_1-1716478014542.png

    ---

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

    Terms & ConditionsCookie settingsAccessibility statement