Cloud Assert Blogs

How to troubleshoot Windows Azure Pack and System Center Usage Pipeline?

How to troubleshoot Windows Azure Pack and System Center Usage Pipeline?

Author: siva/Wednesday, August 19, 2015/Categories: Windows Azure Pack, Usage and Billing

Rate this article:


We have been observing that when we deploy the Usage and Billing solution to the clients, System Center records are not updated in the 'Microsoft.MgmtSvc.Usage' table. Following are some of the possible fixes for the issues that we found in existing deployments of our clients. 


1. Before deploying the Usage and Billing solution make sure you can find 'System Center' records        in 'Microsoft.MgmtSvc.Usage' database. Execute the following SQL query.

  SELECT count(*)
  FROM [Microsoft.MgmtSvc.Usage].[usage].[Records]
  where ResourceProviderId = (select ProviderId  FROM 
            where ProviderName='systemcenter')

2. If the result is greater than '0', then you can go ahead deploying the Usage and Billing.  

3. If not, please refer the following links to see if the 'VMM --> OperationManager --> OperationsManagerDW --> SPF  --> WAP’ integration is setup fine. 

Step 1: IaaS Usage and Service Reporting using System Center 2012 R2 and Windows Azure Pack

Step 2: Configuring VMM and OM for IaaS usage and metering.

Step 3: Configuring SPF and Windows Azure Pack for IaaS usage and metering.

If you are facing issues even after following all the steps in the above article, then please go through the following steps.


Please make use of the troubleshooting steps on known issues from our client deployments.


a) Checking OperationManager and OperationsManagerDW Integration:

Execute the following query against 'OperationsManagerDW'  database.

SELECT TOP 1000 [ManagedEntityRowId]
  FROM [OperationsManagerDW].[dbo].[ManagedEntity] where DisplayName = 'xxxxx'

xxxx -> Replace it with any VM Name that was recently created from 'WAP'.

If you get some records, then OperationManager and OperationsManagerDW integration is fine. 

b) Troubleshooting the OperationsManagerDW and SPF integration:

1. Please use the following URL replacing with your 'spf-server-name':


2. Provide the respective credentials in the window that prompts.

3. A JSON will be downloaded. Open the file and check if it contains some records. If it does not, then following might be the issues. Incase if you can see the records in JSON file, then please skip this section and go to the section 'Troubleshooting SCSPF DBs'.

Check if you have added any SCSPF setting more than once: 

1. Go to SPF machine.

2. Open the powershell with an administrator privilege.

3. Execute the following command.


4. Result is like below.


5.Make sure if there is only one setting with the name 'SCOM-DB-SERVER-NAME'.

6. If it is more than once, then remove the duplicate 'DB connection string' entry by using the following command (But do not remove the EndpointUrl setting).

 Get-SCSPFSetting -Id 'xxxx' | Remove-SCSPFSetting 


xxxx-> Replace with the actual Id of the setting that you need to remove.


Troubleshooting in SCSPF and WAP Integration:


1. Execute the following query against SCSPF database.

SELECT TOP 1000 [Id]
  FROM [SCSPFDB].[scspf].[SpfUsageRecord]

 order by RecordIndex desc


2. Note the RecordIndex column of the first row from the result. If there are no records then replace 'XXXX' in the following query with '0'.


3.  Update the following query with the noted RecordIndex.
Update [Microsoft.MgmtSvc.Usage].[usage].[ProvidersConfiguration] set LastUsageEventId = 'XXXX' where ProviderName = 'systemcenter'


XXXX - RecordIndex taken from the previous query.

4. Execute the following query to update the ‘DefaultTimeOut’  setting in [Microsoft.MgmtSvc.Usage]  database.

  Update [Microsoft.MgmtSvc.Usage].[usage].[Configuration]  set Value = 600 where    [Microsoft.MgmtSvc.Usage].[usage].[Configuration].[Key] = 'OutgoingCallsDefaultTimeoutInSeconds'

5. Please recycle the usage collector app pool.


6. Check for the System Center records in Microsoft WAP Usage database.


If still usage records are not coming up try the following section. 


401 UnAuthorized Exceptions Stops pulling Usage data:


1. In the same machine where Usage Collector runs check for the following Event Log Name.


2. Under that, check for the logs with the similar Error message.


Provider read error occurred for provider 'systemcenter' instance id: '{04a0de02-6ab6-4e51-9620-df04e41b427a}'. Error: System.Net.Http.HttpRequestException: Response status code does not indicate success: 401 (Unauthorized).

   at System.Net.Http.HttpResponseMessage.EnsureSuccessStatusCode()

   at Microsoft.WindowsAzure.Server.Usage.DefaultUsageRecordsReader.<GetRecordsAsync>d__0.MoveNext()

--- End of stack trace from previous location where exception was thrown ---

   at System.Runtime.CompilerServices.TaskAwaiter.ThrowForNonSuccess(Task task)

   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)

   at System.Runtime.CompilerServices.TaskAwaiter`1.GetResult()

   at Microsoft.WindowsAzure.Server.Usage.CycleRunner.<ProcessProviderInternal>d__19.MoveNext()

3. If you don't find any event logs, then please execute the following query against Microsoft.MgmtSvc.Usage database.

  FROM [Microsoft.MgmtSvc.Usage].[UsageDiagnostics].[ProviderCollectionCycles]
  where ResourceProviderId = (select ProviderId  FROM 
            where ProviderName='sqlservers') 
   order by ProviderCycleID desc

4. Now check for the Error column and see if you have similar '401 (Unauthorized)' Error message given in Step2. 

5. Incase if you find '401 (Unauthorized)' message, please go to Admin Portal --> VM Clouds.

 a. click on the Cloud icon.

 b. Click on the link under 'Register Service Provider Usage' and set the appropriate username and password.

 c. Now restart the UsageCollector service and check for the System Center usage records in Microsoft.MgmtSvc.Usage database.

We will keep updating this article, as we came across new issues in our U&B customer deployments.


Number of views (16784)/Comments (8)

8 comments on article "How to troubleshoot Windows Azure Pack and System Center Usage Pipeline?"

Avatar image

write essay

5/23/2018 3:34 AM

Absolutely fantastic posting! Lots of useful information and inspiration, both of which we all need!Everything is just so lovely and perfect!You will get academic integrity, quality and punctuality from sites available now. Hence, each of the paper done at custom essays has a touch of professionalism.So try to write better and make your essay better at any level.Its the better way for you to make your essay with good contents.

Avatar image

uk assignment

6/2/2018 3:26 AM

On the off chance that you made a bet on Windows Azure Services for Windows Server when it was discharged not long ago, certainly set aside the opportunity to get the more current Windows Azure Pack to begin exploiting the new highlights. The detailed step by step guide can be found in the link below.

Avatar image


10/16/2018 2:15 AM

This is really a great blog and i need this windows troubleshoot information. if you have to also need a windows file exploring function so try to learn our given tutorial, after using this file explorer your can access your files any computer and anywhere.

Avatar image


10/20/2018 12:19 AM

She appeared to be so pleasant and reasonable on our Skype meet, as well. Be that as it may, better believe it that reaction that I should grope fortunate sent a notice hail, so I swung to you dazzling redditors for advice.

Avatar image

AOL Support

10/26/2018 5:08 AM

You have raised very valid points in your post. It really happened some person do not have the right idea. But with your awesome tips, one can easily identify it. for any query or problem related to AOL you may visit AOL Support Number at

Avatar image

Black Friday

10/27/2018 4:02 AM

Holy crap you are right. I absolutely missed that. But now I'm more confused about why WikiLeaks would link to a HuffPost article. I need to go back to watching funny gifs.

Leave a comment

This form collects your name, email, IP address and content so that we can keep track of the comments placed on the website. For more info check our Privacy Policy and Terms Of Use where you will get more info on where, how and why we store your data.
Add comment