UI elements is not loading to create section

Menu bar - Structual, Data Capture, Pickers, Action, Data Display is not loading.

Have issue in both App Studio and Dev studio. Earlier we had this issue, after daily server restart it was coming up. But the issue has popped up again.

In logs i see SQL timeout errors.

Few RD which is responsible -

pyGetBasicPegaControlsForPalette

pyGetPickersPegaControlsForPalette

Version - 8.5.2

Appreciate your support on this

@SarathPrashanthC

Do you have any error on your PegaRULES logs? How about if you try to trace it, do you have an error on tracer output?

@MarcLasserre_GCS

Error in Tracer

D_pzRelevantRecordsProperties
There was a problem getting a list: code: 0 SQLState: HY008 Message: The query has timed out.
D_pzRelevantRecordSections

There was a problem getting a list: code: 0 SQLState: HY008 Message: The query has timed out.

D_pzWidgetSections

There was a problem getting a list: code: 0 SQLState: HY008 Message: The query has timed out.

Error in logs is same as i have mentioned.

An error occured on executing the query for the report definition - There was a problem getting a list: code: 0 SQLState: HY008 Message: The query has timed out. 
There has been an issue; please consult your system administrator.  Rule-UI-Components are either missing or cannot be found. 

P.S: Our application is based on UIKit and not on Cosmos. (this might be an issue ??)

Best.

After adding these DSS, did not see those issues again.

Purpose: reporting/useForceOrderHint

Ruleset: Pega-RULES

Value: true

reporting/useForceOrderHintForRRandAC

ruleset: PEGA-RULES

value: true

Purpose: reporting/useMergeHintForRRquery

Ruleset: Pega-Reporting

Value: true