Highlighted
Micro Focus Expert
Micro Focus Expert
154 views

(PC) Support tip: PC 12.20 LAB Management->Usage Reports causes application to hang

In PC 12.20 and 12.01, clicking on any usage report under LAB Management causes the application to hang

To address the behavior, follow the below suggested workaround:

On all the ALM servers, change a file called Concurrency.config.xml under PCLAB.jar. Change the SQL as outlined below. Changes shown in RED:

  < data-table id = "Run" >

    < sql provider = "MSSQL" >

      SELECT

           PRJP_DOMAIN + '\' + PRJP_PROJECT_NAME  AS PROJECT,

           PRJP_PROJECT_ID AS PROJECTID,

           LRN_RUN_ID AS ID,

           LRN_START_DATE AS STARTAT,

           LRN_END_DATE AS ENDAT,

           (CASE

            WHEN (LRN_CONTROLLER_NAME > '' AND PATINDEX('%'+ LRN_CONTROLLER_NAME+'%', LRN_LOAD_GENERATORS) = 0)

               THEN (LEN(LRN_LOAD_GENERATORS) - LEN(REPLACE(LRN_LOAD_GENERATORS, ';', ''))) + 1

            ELSE (LEN(LRN_LOAD_GENERATORS) - LEN(REPLACE(LRN_LOAD_GENERATORS, ';', '')))

            END) AS MACHINES,

            LRN_VUSERS_MAX AS VUSERSRUNMAX,

            LRN_VUSERS_AVERAGE AS VUSERSRUNAVRG

      FROM LAB_RUNS     

         INNER JOIN LAB_PROJECT_PROPERTIES ON PRJP_PROJECT_ID = LRN_PROJECT_ID

      WHERE ( LRN_TYPE = 'Performance Test' AND LRN_END_DATE IS NOT NULL AND LRN_START_DATE IS NOT NULL AND LRN_END_DATE > LRN_START_DATE)

      AND (@StartTime@ is NULL OR LRN_START_DATE >= @StartTime@ )

      AND (@EndTime@ is NULL OR @Endtime@ >= LRN_START_DATE )

      AND PRJP_PROJECT_ID != 0

      [[projects: AND PRJP_PROJECT_UID IN (${projects})]]

    </ sql >

    < sql provider = "ORACLE" >

        SELECT 

        PRJP_DOMAIN || '\' || PRJP_PROJECT_NAME AS PROJECT,

        PRJP_PROJECT_ID AS PROJECTID,

        LRN_RUN_ID AS ID,

        LRN_START_DATE AS STARTAT,

        LRN_END_DATE AS ENDAT,

        (CASE

         WHEN (NOT(LRN_CONTROLLER_NAME IS NULL) AND NVL(INSTR(LRN_LOAD_GENERATORS, LRN_CONTROLLER_NAME),0) = 0)

            THEN (NVL(LENGTH(LRN_LOAD_GENERATORS),0) - NVL(LENGTH(REPLACE(LRN_LOAD_GENERATORS, ';')),0)) + 1

         ELSE (NVL(LENGTH(LRN_LOAD_GENERATORS),0) - NVL(LENGTH(REPLACE(LRN_LOAD_GENERATORS, ';')),0))

        END 

        ) AS MACHINES,   

        LRN_VUSERS_MAX AS VUSERSRUNMAX,

        LRN_VUSERS_AVERAGE AS VUSERSRUNAVRG

           FROM LAB_RUNS

               INNER JOIN LAB_PROJECT_PROPERTIES ON PRJP_PROJECT_ID = LRN_PROJECT_ID     

               WHERE ( LRN_TYPE = 'Performance Test' AND LRN_END_DATE IS NOT NULL AND LRN_START_DATE IS NOT NULL AND LRN_END_DATE > LRN_START_DATE)

                     AND (@StartTime@ IS NULL OR LRN_START_DATE >= @StartTime@) AND (@EndTime@   IS NULL OR @Endtime@ >= LRN_START_DATE)

                     AND PRJP_PROJECT_ID != 0

           [[projects: AND PRJP_PROJECT_UID IN (${projects})]]

    </ sql >

    < Parameters >

      < Param name = "StartTime" type = "Date" />

      < Param name = "EndTime" type = "Date" />

    </ Parameters >

 RELEVANCE:

 This query affects ONLY the generate report feature under the projects and will not touch any other functionality

Also for further usage of generating these reports, it is recommended to use the standalone version of the Usage Reports tool that comes packaged with PC12.50 and above

Microfocus Support

If you find that this or any post resolves your issue, please be sure to mark it as an accepted solution.
Labels (1)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.