Performance issue is Repaircenter screen

  • 14 March 2024
  • 3 replies

Userlevel 3
Badge +5

Hi Experts,

I have a problem with the Repaircenter baseline screen in FSM 6U27.

When I click the search button in the Repaircenter screen, it takes nearly 1 minute to show the results. Additionally, if I click on one of the Repaircenter records, it takes nearly 2 minutes to enter the screen. Sometimes, the application is unresponsive when I attempt to enter the Repaircenter record.

I have captured the XML query when clicking the search button in Repaircenter, and I have attached the XML.

Currently, in my system, the repair_center_view has 80457 records.


Can we categorize this as an indexing problem?



Best answer by Hushan Hasarel 14 March 2024, 18:27

View original

3 replies

Userlevel 4
Badge +11

Hi @Chethana,

There is already an ongoing support case for this issue. I suggest you keep up with it. CS0204791

Thanks & Best Regards,

Userlevel 3
Badge +5

@Hushan Hasarel , Thanks for the update

Userlevel 3
Badge +5

As a temporary solution, we have removed the 6U27 baseline request_unit_location SQL view and added it with the 6U25 request_unit_location SQL view. This has effectively resolved the issue.