This error indicates a SQL timeout. SQL is an underlying component of the NVivo software.
If your project file is on a network drive, first move it to your local device to see if the error resolves.
If you continue to get the error and you have ruled out other causes of slow performance , you can change the SQL Time out period manually by editing your configuration file.
NOTE: You can ask your IT support personnel to help you with this if you are unable to do this yourself.
1. Find your NVivo Version number by selecting File > Help > About NVivo. Make a note of this and close NVivo.
Make Sure "Show Hidden Files..." is Enabled in your Folder settings.
With NVivo closed, follow the steps below:
a) In the Search box on the bottom left, start typing ‘Folder Options’ and click on File Explorer Options in the search results
b) In the File Explorer window that opens, click on the View tab
c) In the Advanced settings section, under Hidden files and folders, select "Show hidden files, folders and drives" and click OK
2. Go to C:\Users\yourusername\AppData\Roaming\QSR_International and search for "user.config" in Windows Explorer. The file you want to modify is in an NVivo folder starting with the version number you are running:
Right-click on the 'user.config' file and select Edit. The file should open in Notepad.
3. Locate the line in the file that says 'SqlCommandTimeout'.
The value between '<value>X</value>' is 60 by default.
- Change this value to a higher number like 120 or 180. Save the changes in the file by going to File -> Save and close the file.
NOTE: Changing the SQLTimeout value may result in the 'Cancel' button becoming unresponsive if getting this error when running a query.