Return
-
Title
LDAPAccount.RoomNumber lengthen column -
Description
There is no consistency on column lengths for Room and LDAPAccount with greater than 20 characters. Room identifier doesn't fit because LDAPAccount.RoomNumber has only 20 characters.
Looking at the other tables with Room attribute, it is either 32 (Locality, Org) or 64 characters (Workdesk, UCI/CSMUser). Person.Room is unlimited.
Since RoomNumber is not in an index, and has no limit in the target system, and has no extra handling in Identity Manager, the column should be extended to 64 characters.
The data flow fits:
-PersonAuto: LDAPAccount.RoomNumber => Person.Room
-Template: Locality.Room => Person.Room => LDAPAccount.RoomNumber -
Cause
Product Enhancement Request ID 34099.
-
Resolution
WORKAROUND
Extend the column length manually via SQL. The data won't be lost in migration after the inclusion of the enhancement.
ALTER TABLE LDAPAccount ALTER COLUMN RoomNumber nvarchar(64)
UPDATE DialogColumn
SET SchemaDataLen = 64
WHERE UID_DialogColumn = 'LDP-8453FC0D14EB4E4690B8B52CF5A625A7'
AND SchemaDataLen = 20
Please ensure a recent database backup exists before making any schema changes.
STATUS
This Enhancement is currently planned for the next major version of Identity Manager and for the next Service Pack of version 8.1. Please contact Support referencing CR 34099 for a Hotfix. -
Change Request
34099