You discover that usage data is not being updated for virtual machines (VMs) that are managed by Windows Azure Pack (WAP). In this situation, an event that resembles the following is logged by the Service Provider Foundation services:
Log Name: Microsoft-ServiceProviderFoundation/Analytic
Source: Microsoft-ServiceProviderFoundation
Event ID: 11
Task Category: (65523)
Level: Error
Keywords: None
Description:
Component: 7
Activity [WebAuthentication Call, id {0f4f34b4-aa65-499d-b894-c62862a06ef6}]
Parent activity [none, id {00000000-0000-0000-0000-000000000000}]
Elapsed: 0ms
Context: {82c0e5a7-5ffa-49a6-8599-83eb4115c91c}
The SPF Usage Metering Retriever encountered an error while attempting to retrieve usage data. All SCSPFDB database changes have been rolled back. Failure information: The given value of type String from the data source cannot be converted to type nvarchar of the specified target column.
Additionally, SPF debug logs show an entry that resembles the following:Source: Microsoft-ServiceProviderFoundation
Event ID: 11
Task Category: (65523)
Level: Error
Keywords: None
Description:
Component: 7
Activity [WebAuthentication Call, id {0f4f34b4-aa65-499d-b894-c62862a06ef6}]
Parent activity [none, id {00000000-0000-0000-0000-000000000000}]
Elapsed: 0ms
Context: {82c0e5a7-5ffa-49a6-8599-83eb4115c91c}
The SPF Usage Metering Retriever encountered an error while attempting to retrieve usage data. All SCSPFDB database changes have been rolled back. Failure information: The given value of type String from the data source cannot be converted to type nvarchar of the specified target column.