Report Generation in VLM 2024 Q4 Fails with Redirect to SQLite Interpreter Error Page

Issue Details

When using NI Volume License Manager (VLM) 2024 Q4, the application may crash when attempting to generate a report. After the crash, a web browser may open and redirect the user to the following SQLite SEE licensing page:

https://www.sqlite.org/purchase/sds?app=NI%20Volume%20License%20Manager&err=interpreter%20creation%20is%20temporarily%20disabled

This issue has been observed during normal use of the report generation feature and may affect some environments using this version of VLM.

Solution

This issue may be resolved by updating the environment variable and applying an experimental patch to the SQLite SEE component used by NI Volume License Manager. Follow the steps below:

1. Set the following environment variable:

   TrustFlags = WTD_REVOKE_NONE WTD_CACHE_ONLY_URL_RETRIEVAL

2. Replace the existing SQLite SEE DLL with the patched version:

   • Download and extract the file: sds-see-1.0.117.0-R4-NetFx40.zip

   • Backup the existing file:

     C:\Program Files (x86)\National Instruments\Volume License Manager\System.Data.SQLite.SEE.License.dll

   • Replace it with the DLL provided in the patch.

3. Restart NI Volume License Manager after making the changes.

⚠️ Note: Please ensure both the original DLL and the entire Volume License Manager directory are backed up before applying the patch, in case a rollback is needed.

Additional Information

This issue appears to be related to a known limitation in SQLite version 1.0.117.0, where the SEE (Software Encryption Extension) component fails to initialize the interpreter under certain conditions. Although the issue could not be reproduced internally using the customer database, related user reports have been documented in the SQLite forums:

• https://sqlite.org/see/forumpost/7fd019741dc322d4d6c5b91c3e0a20a4e79c05c9921029db790c7800c4563323

• https://sqlite.org/see/forumpost/243b866b91c38c9c85d049420faf8d5c680d4e9a36a2a27db1b5cdfca2e88656

• https://sqlite.org/see/forumpost/aa00c799ac331dcd0b5ac33f5fe9339064fe0cfa7127e50db3b70751a4f9f2e0

These links may require login access to view. An experimental DLL provided by SQLite was used in this workaround.