Problem: Orchestra fails to find users in the configured OpenLDAP.
Solution: If the central database is MSSQL, the key used for user group data needs to be changed to lower case. Run the following query in SQL Server Management studio:
UPDATE [qp_central].[qp_central].[system_parameter] SET value = 'cn' WHERE parameter_definition_id = 'aaa.ldap.roleAttributeIdName'
Problem: I am not allowed to enter an ldap server with a hyphen in its DNS name in the ldap system parameter.
Solution: This is a known problem in systems that were installed before Orchestra 6, update 2. Run the following query to fix the issue:
UPDATE qp_central.system_parameter_definitions SET validation ‘’ WHERE id = ‘aaa.ldap.urls’