Solved

Performance issue is Repaircenter screen

  • 14 March 2024
  • 3 replies
  • 55 views
Chethana
Rank
Userlevel 3
Badge +4

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?

 

icon

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

View original
1 Attachment
Chethana Dasanayaka

3 replies

Hushan Hasarel
Rank
Userlevel 4
Badge +10

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
Rank
Userlevel 3
Badge +4

@Hushan Hasarel , Thanks for the update

Chethana Dasanayaka
Chethana
Rank
Userlevel 3
Badge +4

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.

Chethana Dasanayaka

Reply


Terms & ConditionsCookie settings