Highlighted
Absent Member.
Absent Member.
603 views

Limitations of LR Analysis MSDE

When running LR analysis against a results file > 2GB, LR analysis fails. I have read on the LR analysis help files that in such circumstances I should install SQL Server / MSDE. I have installed MSDE from the LR 8.1 add-in components. I have tested the installation of this and have got as far as successfully testing the config on the database tab at Tools>options on LR analysis. I am now encountering a 'login failure' message. However, before I spend time trying to resolve this issue I have read on some web sites and on a post on sqaforums that MSDE cannot handle a results file greater than 2GB ( the same limitation on the existing LR Analysis Access 2000 DB engine). What is the results file limitation on MSDE? If it is 2GB can you recommend a solution that can handle files > 2GB and what is the limitation of this solution? I am producing results files of 8GB and greater as I am running extended soak tests. Thanks.
Tags (1)
0 Likes
2 Replies
Highlighted
Acclaimed Contributor.
Acclaimed Contributor.

You can use MSDE/SQL Server to analyze your results. The limitation or ~2GB is for MS Access database which is used by LR by default. For login failure, verify the settings as per the article.
0 Likes
Highlighted
Absent Member.. Absent Member..
Absent Member..

I'm new to using SQL Server for storing analysis results and have managed to get it working (no thanks to the HP documentation!). However, I want to know if there is any way to set the database name that is generated as the dynamic names are completely meaningless. I'd like to be able to specify my own db name - is this possible. I'm using LR 11.51 with SQL Server 2008.

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.