Skip to main content
Solved

Performance issue is Repaircenter screen

  • March 14, 2024
  • 3 replies
  • 102 views

Chethana
Sidekick (Employee)
Forum|alt.badge.img+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

Hi @Chethana,

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

Thanks & Best Regards,
Hushan

3 replies

Hushan Hasarel
Hero (Employee)
Forum|alt.badge.img+12
  • Hero (Employee)
  • 58 replies
  • Answer
  • March 14, 2024

Hi @Chethana,

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

Thanks & Best Regards,
Hushan


Chethana
Sidekick (Employee)
Forum|alt.badge.img+5
  • Author
  • Sidekick (Employee)
  • 56 replies
  • March 14, 2024

@Hushan Hasarel , Thanks for the update


Chethana
Sidekick (Employee)
Forum|alt.badge.img+5
  • Author
  • Sidekick (Employee)
  • 56 replies
  • April 25, 2024

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.