I have revived an old thread in Nvivo9/10 forum about query timeout.
I have gratefully received a response from QSR helpdesk about this topic and so am sharing this in case anyone else finds it useful:
Firstly, please follow the steps below to perform a Compact and Repair of your project:
1. If your project is located on a network drive, copy it to your local machine.
2. If the project is currently open, close the project via File > Close.
3. Click the File tab > Help > Compact and Repair Project.
4. At the Select Project dialog box, locate and select the project - select NVivo Projects (*.nvp) to repair a standalone project.
5. Click Open.
If the issue persists, you may need to change the SQL Time out period manually by editing your configuration file. This may be a little technical. You can ask your IT support personnel to help you with this if you are unable to do this yourself. The steps are below:
o Ensure NVivo 11 is closed.
o Go to Start -> All Programs -> Accessories -> Wordpad
o Click on File -> Open. Ensure "All Documents (*.*) is selected in the 'Files of Type' dropdown menu in the Open dialog box.
1. With NVivo 11 closed, open Windows Explorer
a) Right-click on the Windows Start circle -> Explore.
2. Display all hidden files and folders:
a) Click on Organize -> Folder and Search Options
On the 'Folder Options' dialog, click on the View tab and check 'Show hidden files and folders' option
c) Click on the Apply button and click OK.
2. Navigate to the following folders:
o You should see few folders that start with NVivo.exe..... Go into the first folder and see if it has subfolder named "126.96.36.1991"2. If not, go back one level and go into the second NVivo.exe.. folder to see if it has a 188.8.131.5212 subfolder One of the two folders will definitely have a subfolder named "184.108.40.2061"2. Go into this subfolder (220.127.116.111)2. You should see a file called user.config, double click on it to open it.(Open it with Notepad)
o The 19th3 line from top in this file (or one or two lines above or below) should have something that says SqlCommandTimeout setting. The next line should have a value of 60. Change this value to a higher number like 120 or 180.
o Open NVivo 11 and re-run your query. If you still get the same error. Try increasing the timeout value to a higher number.
Please note changing the sqltimeout value may result in the Cancel button (when you run a query) to become unresponsive.
Lastly, if you are using 32-bit NVivo 11, it will also help to switch to 64-bit version. Please refer to the link below to find whether you can install 64-bit,
1. Rather than going through all those steps, I found it easier to type %appdata% into my Windows Explorer and choose the right version of Nvivo from there.
2. Just to point out that this number is the version of Nvivo you're running. Your version may be different, so check this first. You can do that by going to 'File', 'Help', 'About Nvivo'.
3. It was not the 19th line for me. I just used CTRL+F to find the SqlCommandTimeout setting.