0 Replies Latest reply: Nov 1, 2017 7:55 PM by Annemarie Mikolaitis RSS

    Sense Governance Dashboard refresh takes long time

    Annemarie Mikolaitis

      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?