Genesys Engage on-premises

 View Only
Discussion Thread View
  • 1.  Slowness while running interaction flow report GCXI

    Posted 11-03-2020 03:42
    Edited by Abdelrahman Mohamed 11-03-2020 03:43
    Hello ,

    When we try to run "interaction flow report" through GCXI . it take forever to run. and timeout
    I tried to get the query as per the following link Slow Response  and run it to the database directly and found it very slow.

    When I tried to change the date time key search 
    and itf.START_DATE_TIME_KEY >= (SELECT min(DATE_TIME_KEY) from DATE_TIME WHERE CAL_DATE IN (select max(CAL_DATE) FROM DATE_TIME WHERE CAL_DATE <=CONVERT(datetime2, '2020-11-03 00:00:00.0000000', 121)))- 2764800
    and itf.START_DATE_TIME_KEY <= (SELECT Min(DATE_TIME_KEY) FROM DATE_TIME WHERE CAL_DATE IN (SELECT Max(CAL_DATE) FROM DATE_TIME where CAL_DATE <= CONVERT(datetime2, '2020-11-04 00:00:00.0000000', 121)))+2764800

    to be
    and itf.START_DATE_TIME_KEY >= 1604347200- 2764800
    and itf.START_DATE_TIME_KEY <= 1604433600+2764800

    and it changed to be as per the following link Fast Response And that become super fast 2 second response

    Is there Any way to enhance the original query ? I tried to reorganize the indexes but still the same.
    The system is very fresh up for 3 months only
    Attached both queries

    Best regards,
    #Reporting/Analytics

    ------------------------------
    Abdelrahman Mohamed
    IST Integration Services And Technologies Co.
    ------------------------------

    Attachment(s)

    txt
    Fast Response.txt   10 KB 1 version
    txt
    Slow Response.txt   13 KB 1 version


  • 2.  RE: Slowness while running interaction flow report GCXI

    Posted 01-12-2022 21:46
    Did you have any luck resolving this?

    ------------------------------
    Vaun McCarthy
    ------------------------------



  • 3.  RE: Slowness while running interaction flow report GCXI

    Posted 02-14-2022 17:50
    I had opened a support case about this same thing and the only advice they provided was to upgrade to a newer release of GCXI.  Supposedly they have made many improvements to the report queries in newer versions.  We have not yet upgraded but I will update this once we do and let you know if it resolves this reports slowness.

    ------------------------------
    Rusty Zimmerman
    Optum Technology, Inc
    ------------------------------



  • 4.  RE: Slowness while running interaction flow report GCXI

    Posted 02-22-2022 09:27
    We have the same situation!

    ------------------------------
    Juan Luis Aguilera Leon
    Interacciones Inteligentes S.A.
    ------------------------------