DirSync Pro Override SQL VarChar Limitation (4316885)

When working with long overrides within DirSync you may run into SQL Varchar limitation. To work around this issue you can perform the following steps:

    In DSP DB navigate to Programmability->StoredProcedures->dbo.CreateOrUpdatePersonView->right-click and select Modify

    Look for DECLARE @sql varchar(8000)
    Change DECLARE @sql varchar(8000) to DECLARE @sql varchar(max)
    Now perform a execute or F5 to save the change

    Next, we will perform similar steps for the Functions table
    Navigate to : Functions-Scalar->valued Functions->[dbo].[GetPersonViewField]->right-click and select Modify

    Look for RETURNS varchar(1000)
    Change RETURNS varchar(1000) to RETURNS varchar(max)
    Look for @fieldvalue varchar(1000)
    Change @fieldvalue varchar(1000) to @fieldvalue varchar(max)
    Now perform a execute or F5 to save the change



You can perform the same set of steps for Group overrides with respective of GroupsViewField vs PersonViewField. You can always reach out to support for further clarification.

If you are using a very long override you may also need to do the following

Expand the DirSync Database navigate to tables->dbo.BT_ViewOverrides->Columns

You will see that FieldValue is set to 1000, to set this to max needs to be done via a query, please run the following SQL command.

alter table bt_viewoverrides alter column fieldvalue nvarchar (max)

Note

Changing these settings can impact an upgrade we recommend reversing these changes before attempting upgrade to DirSync and reimplementing them once the upgrade has completed.