[KBA-79155] Access Manager role fails to connect to the database
After upgrading to Security Center 5.10.4.0 or later, the Database status of the Access Manager role remains Not connected.
Applies to
Security Center 5.10.4.0 - 5.10.4.13 and 5.11.0.0 - 5.11.3.0
Cause
This issue is caused by access control entities that were created or modified with
empty names. The following entities are affected:
- access rules
- cardholders
- credentials
- visitors
To check if your database is affected, open SQL Server Management Studio and execute the following query on the Directory database:
select * from [dbo].[Entity] WHERE ([Name] is NULL OR [Name] = '') AND [Type] in (7,9,11,24)If the Name field is blank, contact the Genetec™ Technical Assistance Center (GTAC).
Workaround
None.
Status
This issue is resolved in Security Center 5.10.4.14 and 5.11.3.1.