Jump to content


Photo

Timeout for matrix queries

time out matrix query windows Nvivo 11

  • Please log in to reply
2 replies to this topic

#1 j.innes

j.innes

    Member

  • Members
  • PipPip
  • 24 posts
  • Gender:Female

Posted 26 April 2016 - 10:54 PM

Hi all,

 

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

B)    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:

C:\Users\[username]\AppData\Roaming\QSR_International1

 

o    You should see few folders that start with NVivo.exe..... Go into the first folder and see if it has subfolder named "11.1.0.411"2. If not, go back one level and go into the second NVivo.exe.. folder to see if it has a 11.1.0.4112 subfolder One of the two folders will definitely have a subfolder named "11.1.0.411"2. Go into this subfolder (11.1.0.411)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,

 http://www.qsrintern....aspx?view=1189

 

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.



#2 IOFarmer

IOFarmer

    Casual Member

  • Members
  • Pip
  • 8 posts

Posted 28 March 2017 - 06:05 AM

Thanks for posting this! I ran into the same issue.

I am finding that the config file seems to override the edits you indicated above and resets back to 60 seconds when I restart the program. I'm on a military network and am wondering if its because I am attempting to make changes as an non-admin user, or if its for another reason. 

I'm surprised there is now way to change the command timeout in the GUI.



#3 IOFarmer

IOFarmer

    Casual Member

  • Members
  • Pip
  • 8 posts

Posted 28 March 2017 - 06:37 AM

Please disregard my response it looks like I was saving in the .bak file which I learned from our IT guy is a backup file and is not the file that changes the configuration. It works now and my analysis went off without any issue :).







Also tagged with one or more of these keywords: time out, matrix query, windows, Nvivo 11

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users