ControlPoint 5.x

Situation

Usage metrics in ControlPoint are not updating.

Resolution

If its not updating then the License service is unable to communicate with SQL Server.

You can enable more detailed logging in License Service by setting the logging level to “ALL” as shown below in

Locate Log4net section in \ControlPoint\LicenseService\ControlPointLicenseService.exe.config:
set <level value="ALL" />
Save change and restart License Service service.
Then review this log: Program Files\Micro Focus\ControlPoint\LicenseService\Logs\LicenseService.log

Often the connectionstrings allowing the service to connect to SQL are incorrect:

e.g.

<connectionStrings>
<add name="ControlPointEntities" connectionString="metadata=res://Autonomy.ControlPoint.DataAccess.Providers.EntityFramework/Entities.ControlPointEntities.csdl|res://Autonomy.ControlPoint.DataAccess.Providers.EntityFramework/Entities.ControlPointEntities.ssdl|res://Autonomy.ControlPoint.DataAccess.Providers.EntityFramework/Entities.ControlPointEntities.msl;provider=System.Data.SqlClient;provider connection string='Data Source=.;Initial Catalog=ControlPoint;Integrated Security=True;Connection Timeout=60;MultipleActiveResultSets=True'" providerName="System.Data.EntityClient" />
<add name="ControlPointAuditEntities" connectionString="metadata=res://Autonomy.ControlPoint.Audit/Entities.ControlPointAuditEntities.csdl|res://Autonomy.ControlPoint.Audit/Entities.ControlPointAuditEntities.ssdl|res://Autonomy.ControlPoint.Audit/Entities.ControlPointAuditEntities.msl;provider=System.Data.SqlClient;provider connection string=&quot;data source=.;initial catalog=ControlPointAudit;integrated security=True;Connection Timeout=60;multipleactiveresultsets=True;App=EntityFramework&quot;" providerName="System.Data.EntityClient" />
</connectionStrings>

In the example  the Data Source is specified as "." which will only work if SQL is on the same machine as the License Service. If SQL resides on a separate machine then update the Data Source to reference the correct machine name. 

Save change and restart License Service service.
Then review this log: Program Files\Micro Focus\ControlPoint\LicenseService\Logs\LicenseService.log
Check there are no errors reported.
Then login to CP and examine Usage and it should be updated.

Access support article here