Sense Governance Dashboard refresh takes long time

Anonymous — Sat, 16 Nov 2024 09:06:36 GMT

QS version: 3.2 SR 3

QSGC version: 2.1.1

First attempt at trying to get the QS Governance Dashboard working. The qsgc-Refresh-Governance-Dashboard task completed successfully, but took over 7 hours to complete. The bulk of the time was in the following resident load:

2017-10-27 18:36:51 0200 AppTree_tmp:

2017-10-27 18:36:51 0201 Hierarchy(AppTreeNodeId,AppTreeParentNodeId,AppTreeNodeName,'AppTreeParentNodeName',AppTreeNodeName,'AppTreePath','/','AppTreeDepth')

2017-10-27 18:36:51 0202 LOAD

2017-10-27 18:36:51 0203 NodeId as AppTreeNodeId,

2017-10-27 18:36:51 0204 ParentNodeId as AppTreeParentNodeId,

2017-10-27 18:36:51 0205 NodeName as AppTreeNodeName,

2017-10-27 18:36:51 0206 KeyAppTree

2017-10-27 18:36:51 0207 resident AppsTreeStruct

2017-10-27 18:36:51 4 fields found: AppTreeNodeId, AppTreeParentNodeId, AppTreeNodeName, KeyAppTree,

2017-10-27 18:36:51 20,842 lines fetched

2017-10-28 03:04:10 11 fields found: AppTreeNodeName1, AppTreeNodeName2, AppTreeNodeName3, AppTreeNodeName4, AppTreeParentNodeName, AppTreePath, AppTreeNodeId, AppTreeParentNodeId, AppTreeNodeName, KeyAppTree, AppTreeDepth,

2017-10-28 03:04:10 1,404,312,315 lines fetched

2017-10-28 03:04:15 0210 AppTree:

2017-10-28 03:04:15 0211 NoConcatenate

2017-10-28 03:04:15 0212 load *,

Any comments on this runtime? Is this the expected runtime for what it's attempting to do, or is there any way to optimize this area?

topic Sense Governance Dashboard refresh takes long time in Management & Governance

Sense Governance Dashboard refresh takes long time