none
Windows Azure Pack Usage problem RRS feed

  • Question

  • Hi Everyone,

    I’ve hit the wall with this WAP Usage problem so I was hoping someone could help me out.

    I’ve just finished another WAP deployment and have completed the usage setup but it’s not working.

    The integration between SCOM and VMM is working fine as the connector status is OK  (see below “screenshot1”) and I can see data in the SCOM data warehouse appearing from VMM when running the “Virtual Machine Utilization” report in SCOM (see below "screenshot2").

    The configuration in WAP admin for the usage is pointing to the SPF Usage web service, and the user used to do so is a domain user that runs the Usage service itself (see “screenshot3”).

    On the SPF server, I have then configured the SPFSettings to point it to the SCOM server and SCM data warehouse (see “screenshot4”).

    I‘ve also ensured that the domain user used for the SPF Web Service has the appropriate access (and many more as test) to the SCOM Data warehouse SQL Database (see “screenshot5” and “screenshot6”).

    The problem is the communication between SPF and SCOM I believe as the “SpfUsageRecord” table remains empty no matter what I try (see “screenshot7”).

    I can see in the IIS logs on the SPF server that the Usage web request returns a code 200, so all good there, but the “lastId” value is blank, which I assume is because my “SpFUsageRecord” table is empty in the first place:

    2016-08-04 00:01:29 192.168.10.157 GET /USAGE/usage lastId=&batchSize=10000 8090 xxx\svc-wap-spf 192.168.10.62 - - 200 0 0 467

    2016-08-04 00:10:29 192.168.10.157 GET /USAGE/usage lastId=&batchSize=10000 8090 xxx\svc-wap-spf 192.168.10.62 - - 200 0 0 46

    Any suggestion on where to look next?

    Thank you, Stephane

    Screenshot1

    Screenshot2

    Screenshot 3

    Screenshot 4

    Screenshot 5

    Screenshot 6

    Screenshot 7


    Hope this helps, Stephane

    Friday, August 5, 2016 1:09 AM

All replies

  • Hi,

    We are facing a similar issue.  Did you get a resolution for this?

    Thanks.

    Tuesday, June 13, 2017 7:43 AM
  • Hi,

    At the time, it was a bug in UR10 (upgrading only), which was fixed by installing UR11.

    What update are you running?

    Cheers,
    Stephane


    Stephane

    Tuesday, June 13, 2017 8:11 AM
  • Thanks for your prompt response.

    We are on SC 2016 evaluation version - across SPF/SCOM/VMM.  Is there a specific UR for 2016 version that we need to install?


    Tuesday, June 13, 2017 8:15 AM
  • I'm not sure about 2016. We're in the process of upgrading ourselves, so can't comment if it works or not yet though.

    Are you seeing exactly the same issue as the above? (the SpfUsageRecord table is empty?)

    If so, try to re-run the configuration wizard (from the config website). Usually, that will fix the problem after a little while.
    If there is one thing I've learned about the usage database, is that you have to be patient as any changes you make takes sometimes hours to show any results.


    Stephane

    Tuesday, June 13, 2017 8:26 AM
  • Thanks for your response.

    Yes, we are seeing the same issue - SpfUsageRecord table is empty, and calling the spf usage endpoint using browser (/Usage/usage?lastId=0&batchSize=100) returns empty json.

    RE: re-running configuration wizard, are you indicating from the WAP config website or re-running SPF setup?  How does WAP configuration impact the SPF to SCOM connectivity?



    • Edited by Aravind-CA Tuesday, June 13, 2017 8:38 AM typo
    Tuesday, June 13, 2017 8:31 AM
  • Yes, the WAP configuration website (not the SPF setup).

    Good question on how does it impact it. I recall that was one of the steps I was asked to do by MS at the time.

    Another one was to create the record manually in the SpfUsageRecord table as follow:

    • run this SQL query on the SCOM DW:
      SELECT max(AggregationDateTime) FROM [dbo].[StandardDatasetAggregationHistory] WHERE [AggregationTypeId] = 20
    • This will return a date value (for example 2017-06-13 00:00:00)
      You'll then need to convert this value and "date -1 day" to ticks. you can do this from this website: 
      https://www.venea.net/web/net_ticks_converter
      Again, as an example, if the value return by the query above is "2017-06-13 00:00:00", enter this date in the website above (which returns the following "tick" value: 636329088000000000), then enter "2017-06-12 00:00:00 and record the "tick" value
    • On the SPF database, run the following, but change the "StartTimeTickCount" and "EndTimeTickCount" to the values you've just calculated above

      USE SCSPFDB
      SET IDENTITY_INSERT [scspf].[SpfUsageRecord] ON
      INSERT INTO [scspf].[SpfUsageRecord] ([Id],[RecordIndex],[ResourceId],[StartTimeTickCount],[EndTimeTickCount],[SubscriptionId],[servicetype]) VALUES (NEWID(),100,'VM Utilization','636050412000000000','636050448000000000','79603889-44b1-4620-86a4-9f617d56ad89','VirtualMachine')
      SET IDENTITY_INSERT [scspf].[SpfUsageRecord] OFF 

    After this is completed, you'll have to wait for a few hours to see if the issue is fixed.

    If it is not fixed, simply delete the record you just created in the SpfUsageRecord table (just to be sure to cleanup after ourselves and not introduce more problems).


    Stephane

    Tuesday, June 13, 2017 9:06 AM
  • I have done the above step and waiting for the data to be populated, Will keep you posted please.

    However after running the above script I had some data populated in SPFDB [SPFUSAGERECORD] as below.

    Id RecordIndex ResourceId StartTimeTickCount EndTimeTickCount ServiceType SubscriptionId
    98183AE2-ADEE-42B8-B5F5-46A77DC54F4B 100 VM Utilization 636329484000000000 636329484000000000 VirtualMachine 79603889-44B1-4620-86A4-9F617D56AD89


    Thanks, Akhilesh


    Tuesday, June 13, 2017 1:22 PM
  • Yes, the WAP configuration website (not the SPF setup).

    Good question on how does it impact it. I recall that was one of the steps I was asked to do by MS at the time.

    Another one was to create the record manually in the SpfUsageRecord table as follow:

    • run this SQL query on the SCOM DW:
      SELECT max(AggregationDateTime) FROM [dbo].[StandardDatasetAggregationHistory] WHERE [AggregationTypeId] = 20
    • This will return a date value (for example 2017-06-13 00:00:00)
      You'll then need to convert this value and "date -1 day" to ticks. you can do this from this website: 
      https://www.venea.net/web/net_ticks_converter
      Again, as an example, if the value return by the query above is "2017-06-13 00:00:00", enter this date in the website above (which returns the following "tick" value: 636329088000000000), then enter "2017-06-12 00:00:00 and record the "tick" value
    • On the SPF database, run the following, but change the "StartTimeTickCount" and "EndTimeTickCount" to the values you've just calculated above

      USE SCSPFDB
      SET IDENTITY_INSERT [scspf].[SpfUsageRecord] ON
      INSERT INTO [scspf].[SpfUsageRecord] ([Id],[RecordIndex],[ResourceId],[StartTimeTickCount],[EndTimeTickCount],[SubscriptionId],[servicetype]) VALUES (NEWID(),100,'VM Utilization','636050412000000000','636050448000000000','79603889-44b1-4620-86a4-9f617d56ad89','VirtualMachine')
      SET IDENTITY_INSERT [scspf].[SpfUsageRecord] OFF 

    After this is completed, you'll have to wait for a few hours to see if the issue is fixed.

    If it is not fixed, simply delete the record you just created in the SpfUsageRecord table (just to be sure to cleanup after ourselves and not introduce more problems).


    Stephane

    I'm sorry! this didn't work. I ran this script and waited for about 9-10 hours but still I'm not seeing any data populated in Microsoft.MgmtSvc.Usage Usage.Records table. Do you suggest any other steps to look here please.

    Thanks, Akhilesh

    Wednesday, June 14, 2017 5:33 AM
  • Unfortunately, that's the end of the troubleshooting steps I've had to do to fix the problem.

    You're best bet at this stage is to open a support with Microsoft, or maybe someone else as any ideas on the forum?

    Cheers,
    Stephane


    Stephane

    Wednesday, June 14, 2017 5:48 AM