This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

LRE 2022 R2- Analysis doesn't generate summary result properly

Hello Everyone,

We have recently upgraded to LRE 2022 R2 and facing issue while analyzing big size raw result files. As access database has its limit, we are using SqlLite option while generating analysis results. However if we select "Generate Summary data only" option then summary result doesn't generate proper data (No data for many transactions). If we select "Generate complete data only" option then summary result shows correct data but it takes more than 24 hrs to finish the analysis.

Screenshots are attached.

Anyone has some suggestions to resolve the issue?

Thanks!

-Ankit

  • 0  

    , Analysis is not the fasted application (single threaded), but 24 hours is very long. How many transactions do you have? We have 130 mil transactions that took about 10h (AWS t3.large). The SQLite DB is around 7GB.

    It has some impact when you have many error messages in your test. You should prevent that with high volume transaction tests.

    You might speed up a full analysis by using a very limited default analysis template (no graphs).

    See also configuration setup advice in  RE: Analysis 2022R2 crashes during Reportgeneration on Win11with MSO 365 (64Bit) Especially pay attention to Aggregation Configuration. The results might surprise you.

    When you later what to apply time windows to your analysis, it is also very time consuming. I just had a look to the SQLite database (Use SQLiteStudio) and made a query that gives me the transaction statistics. It ran for 15 min to report over 100 mil transactions (it is not that bad to reverse engineer).

    You might also use very vast system with high single CPU/Core speed.

    Note that OT (MF) abandoned Access all together in LRE 2023R1.

    How to ask questions

    Reward contributions via likes or 'verified answers'

  • 0 in reply to   

    Hello  , Thanks for your detailed explanation. I also checked different options available in analysis and found out that "Analyze Transaction Setting" option under tools-> option is affecting our analysis time mostly. If I uncheck correlations from this setting, we get our analysed results within 1 hr with complete data option.

    What are the drawbacks if we do not select this option while analyzing the test results?

  • 0   in reply to 

    , thanks for sharing your interesting observation. When add an Analyze Transaction Report:

    Select a transaction and press Generate report, you get on that report correlation data:

    This data is missing when you disable the option you discovered.

    How to ask questions

    Reward contributions via likes or 'verified answers'

  • 0 in reply to   

    Okay, Thanks for the explanation. I think we can work without this feature and get the analysis faster than expected :-)