[KBA-79155] Access Manager role fails to connect to the database - Security Center 5.10.4.0 - 5.10.4.13 and 5.11.0.0 - 5.11.3.0

Applies to
Security Center 5.10.4.0 - 5.10.4.13 and 5.11.0.0 - 5.11.3.0
Last updated
2023-07-07
Internal reference number
3419107
Content type
KB articles
Language
English
Product
Security Center
Version
5.11
5.10
Category
KB articles

[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).

Query result in SQL Server Management Studio showing an entity with a blank Name field.

Workaround

None.

Status

This issue is resolved in Security Center 5.10.4.14 and 5.11.3.1.