Velixo Reports SQLite Error

SQLite Connection Error with Velixo

Issue

When trying to run or update Velixo on a workstation, you are getting a SQLite access error


Symptoms

You are prompted with the screenshot above when:
  1. Trying to reset the local cache
  2. Do a new install and refresh a worksheet
  3. Trying to add your COA

Resolution

There are a few reasons this could be happening.

Version mismatch or multiple versions installed

If you have tried to install Velixo Reports to a different location, or installed it to multiple locations, or install multiple bittage versions, it may be not able to create the SQLite file required.
Run a full Uninstall of all versions, and reinstall the latest version.

Your domain policies have locked down AppData

The default instance of Velixo installs components to both AppData and LocalAppData repositories. If these are locked down by your policies, you will run into this issue.

Windows Security is blocking creating the initial SQLite database file

Often you see no information about this until you repeatedly error out, and then you will receive a popup. This is particularly evident when running Windows Defender.
Eventually, you will get a popup as soon below:


To resolve the error above, TEMPORARILY add an exclusion to allow the EXCEL.EXE process to create the SQLite file, and once created, remove the exclusion.
To add an exclusion, go to Windows Security > Virus & Threat Protection > Settings > Manage Settings > Exclusions > Add Exclusion > Process



Once you have added the Exclusion, attempt to run a process using Velixo Reports, and once successful, remove the temporary exclusion.


    • Related Articles

    • Error: An error occurred during configuration of inquiry

      Symptom When defining a connection to an MYOB Advanced tenant, the user is presented with a message about one or more inquiries not being set up and asking if the user would like to create them: After clicking Yes, the user is presented in an error ...

    • Velixo login Issues

      Issue: You are trying to login to Velixo but you are getting an Authentication issue. Velixo uses the standard MYOB Advanced authentication mechanisms within the product. There are no separate usernames or passwords stored within Velixo. Therefore, ...

    • Testing Connections and Troubleshooting Connection Errors

      OVERVIEW One of the main functions of the Sage Intelligence software is to connect to a data source(s) and retrieve data; these connections are made through the appropriate ODBC driver(s). Because of this reliance on the ODBC drivers, errors can ...

    • Minimum Role Requirements for using Velixo Reports

      Overview At the most basic level, Velixo is governed by the same access rights as MYOB Advanced.  So if you want to control access to various Velixo features, you can do so by controlling access to the screens used for those elements in MYOB ...

    • Updating a License for Velixo Reports

      Issue You have requested a new license or changed the license in any way, and it is not reflecting on the client site. Resolution 1. Open any functioning Velixo Report 2. Go to the Advanced Tab > Clear Local Cache 3. Do a Full Refresh 4. Go to the ...