#### ION_Network with Database Manager

Issue: When upgrading ION_Network with the Database Manager, you may see a time-out message.

This time-out is due to a SQL configuration.

Resolution: Use the following workaround to resolve this and continue the upgrades:

- Make sure you upgrade the ION_Data database first, before you upgrade the ION_Network database. This usually resolves the time-out error.
- If you still notice the time-out error, then re-run the ION_Network upgrade.

If neither of these two options resolves the issue, then you need to modify the SQL Server Registry settings to a larger value using the Registry Editor.

Note: To change the registry setting, you must have administrative privileges.

To edit the registry:

1. Go to Start and select Run.
2. Type `regedit` in the Run text box and click OK. A Registry Editor window opens.
3. Select Computer and press Ctrl+F. In the Find what text box, enter `QueryTimeOutSeconds`. The Registry Editor window highlights the `QueryTimeOutSeconds` registry key.
4. Right-click the registry key and select Modify. An Edit DWORD window opens.

   Note: Before you modify `Value Data`, be sure you make a note of the default value data.

5. Select the Hexadecimal option button, and set the Value Data to `258` (OR) select the Decimal option button, and set the Value Data to `600`.

Once the upgrade is complete, it is recommended that you reset the registry to its original setting.

The time-out error may still prevail when there is NULL in a field that does not allow NULL. This occurs in the Name column of ION_Network.dbo.Scheduler table.

To correct this:

1. Go to SQL Server Management Studio.
2. Select File > Open File.
3. Navigate to the \SBS Upgrade Package\SQL_Script_Files folder and open `update_ Scheduler_Table.sql`.

If a NULL value is found, the script will insert “-” in the Name column.