---
title: "User Receives Desktop Error \"Parameter Width is Insufficient\" After Up"
slug: "user-receives-desktop-error-parameter-width-is-insufficient-after-upgrading-to-xa-server-411x"
description: "AFter upgrading to a new version of the XA Server (e.g., 4.11) and when using the XA Toolbar, the user receives an error. This is a troubleshooting article on how to address this issue."
updated: 2022-06-01T19:47:53Z
published: 2022-06-01T19:47:53Z
canonical: "healthcare.rapididentity.com/user-receives-desktop-error-parameter-width-is-insufficient-after-upgrading-to-xa-server-411x"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://healthcare.rapididentity.com/llms.txt
> Use this file to discover all available pages before exploring further.

# User Receives Desktop Error - Parameter Width is Insufficient - After Upgrading to XA Server 4.11.x

## User Receives Desktop Error "Parameter Width is Insufficient" After Upgrading to XA Server 4.11.x

## PROBLEM

After upgrading to a new version of the XA Server (e.g. 4.11), and when using the XA Toolbar, the user receives an error that reads "This version of the desktop does not function with the current eXactACCESS server. It requires XA Server version 4.11 or higher to function. Parameter width is insufficient..." or an error reading, "Desktop Favorites XML has not been registered with the server..."

## POSSIBLE CAUSE 1: The 4.11 SQL Migration Scripts Were Not Run Against the XA database

The XA Toolbar requires longer parameter widths in the database in version 4.11. Specifically, the **Value** column in the **UserParameterValues** table needs a width of 8000. The associated stored procedures also need to be updated to reflect this change.

alter column [Value] [varchar](8000) NULL

### RESOLUTION 1

Run the following SQL scripts against the XA database:

C:\Program Files (x86)\HealthCast\eXactACCESS\SQL\MSSQL\xa\Migration Update_04_11_00.sql Update_04_11_02.sql

## POSSIBLE CAUSE 2: The Desktop Favorites Control Item has not been Re-registered

The XA Toolbar requires longer parameter widths in the database in version 4.11. Specifically, the **Value** column in the **UserParameterValues** table needs a width of 8000. The associated stored procedures also need to be updated to reflect this change.

alter column [Value] [varchar](8000) NULL

### RESOLUTION 2

1. Delete the existing Desktop Favorites records in the UserParameterValues table. Using the example SQL statements located at the end of this article:
  1. Select the associated ParamGUIDs from the ControlItemParameters table
  2. For each ParamGUID returned, delete the associated UserParameterValues
2. Remove the Desktop Favorites control item from the upper-left-hand quadrant of the XA Administrator Utility (you will have to remove any roles associated with the control item first)
3. Delete the Desktop Favorites control item from the upper-right-hand quadrant of the XA Administrator Utility
4. Re-add the Desktop Favorites control item (right-click upper-right-hand quadrant of the XA Administrator Utility, select **Import Application**, select C:\Program Files (x86)\HealthCast\eXactACCESS\DESKTOP_SERVER.xml)
5. Re-add the Desktop Favorites control item to the Organization Map (Dragged the Desktop Favorites control item over to the upper-left quadrant of the XA Administrator Utility)
6. Assigned roles to the Desktop Favorites control item on the Organization Map, and test

#### SQL STATEMENTS

**Select the associated ParamGUIDs from the ControlItemParameters table**

SELECT ParamGUID, ControlItemGUID, ParameterName, DefaultValue, isMasked FROM ControlItemParameters WHERE (ControlItemGUID = 'baa20d2a-f6f2-41a4-98ec-4b0909badd94')

For each ParamGUID returned (7 records):

DELETE from UserParameterValues where ParamGUID = '1a157e3d-4e8e-4043-882f-25a3fdc59681'