-
Title
DSP: Static Override for a custom field doesn't work - "Invalid column name 'DirSync_HostPlatform'." -
Description
We want to set few custom fields to a static value, but it doesn't take and gives syntax error. "Invalid column name 'DirSync_HostPlatform'."
-
Cause
The number of overrides has exceeded the SQL size limit. This is not a product limitation. See the workaround below, and discuss with your SQL Server administrator before attempting to resolve this issue. -
Resolution
Important: Fully test this in a lab environment, and ensure this works before attempting in a production environment
Please ensure you back up the SQL database first before attempting the following.
In Directory Sync Pro (DSP) SQL database 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)
Perform a execute or F5 to save the change
Additionally, the type of override makes a call to a SQL function therefore the below will also need to be edited:
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)
Perform a execute or F5 to save the change
Additional Steps to get past the override limitation if the above does not work
1. Ensure the default (varchar) was raised to max (varchar)
2. Right-click on the BT_ViewOverrides table and select Design
3. Edit the FieldValue entry in the pane on the right, double click on the data type to change to nvarchar(MAX)
4. Back up the overrides
5. Uncheck the 'Prevent Saving Changes that require table re-creation, located under the Tools | Designers | Tables and Database DesignersContact Product Support if you have any questions or issues with the above resolution.