Hi Guys,

I have a question about SPF Usage metering. I've installed SPF SP1 update 1 and have configured per the documentation as specified http://technet.microsoft.com/en-us/library/dn133231.aspx.

However I'm not getting any usage data and my spf configuration is working as per normal no issues. I see in the IIS Logs a https status of 301 (redirect) and a HTTP status of 401 (unauthorised). IIS Logs below.

2013-05-06 22:25:48 192.168.2.230 GET /usage lastId=&batchSize=10000 8090 Administrator 192.168.1.250 - - 301 0 0 0
2013-05-06 22:25:48 192.168.2.230 GET /usage/ lastId=&batchSize=10000 8090 - 192.168.1.250 - - 401 2 5 0
2013-05-06 22:34:48 192.168.2.230 GET /usage lastId=&batchSize=10000 8090 Administrator 192.168.1.250 - - 301 0 0 0
2013-05-06 22:34:48 192.168.2.230 GET /usage/ lastId=&batchSize=10000 8090 - 192.168.1.250 - - 401 2 5 15
2013-05-06 22:43:48 192.168.2.230 GET /usage lastId=&batchSize=10000 8090 Administrator 192.168.1.250 - - 301 0 0 15
2013-05-06 22:43:48 192.168.2.230 GET /usage/ lastId=&batchSize=10000 8090 - 192.168.1.250 - - 401 2 5 0
2013-05-06 22:45:50 192.168.2.230 GET /usage lastId=&batchSize=10000 8090 Administrator 192.168.1.250 - - 301 0 0 14
2013-05-06 22:45:50 192.168.2.230 GET /usage/ lastId=&batchSize=10000 8090 - 192.168.1.250 - - 401 2 5 0
2013-05-06 22:54:50 192.168.2.230 GET /usage lastId=&batchSize=10000 8090 Administrator 192.168.1.250 - - 301 0 0 749
2013-05-06 22:54:50 192.168.2.230 GET /usage/ lastId=&batchSize=10000 8090 - 192.168.1.250 - - 401 2 5 0
2013-05-06 23:03:49 192.168.2.230 GET /usage lastId=&batchSize=10000 8090 Administrator 192.168.1.250 - - 301 0 0 0
2013-05-06 23:03:49 192.168.2.230 GET /usage/ lastId=&batchSize=10000 8090 - 192.168.1.250 - - 401 2 5 0
2013-05-06 23:05:52 192.168.2.230 GET /usage lastId=&batchSize=10000 8090 Administrator 192.168.1.250 - - 301 0 0 0
2013-05-06 23:05:52 192.168.2.230 GET /usage/ lastId=&batchSize=10000 8090 - 192.168.1.250 - - 401 2 5 0
2013-05-06 23:14:52 192.168.2.230 GET /usage lastId=&batchSize=10000 8090 Administrator 192.168.1.250 - - 301 0 0 15
2013-05-06 23:14:52 192.168.2.230 GET /usage/ lastId=&batchSize=10000 8090 - 192.168.1.250 - - 401 2 5 0
2013-05-06 23:23:52 192.168.2.230 GET /usage lastId=&batchSize=10000 8090 Administrator 192.168.1.250 - - 301 0 0 0
2013-05-06 23:23:52 192.168.2.230 GET /usage/ lastId=&batchSize=10000 8090 - 192.168.1.250 - - 401 2 5 0
2013-05-06 23:25:54 192.168.2.230 GET /usage lastId=&batchSize=10000 8090 Administrator 192.168.1.250 - - 301 0 0 15
2013-05-06 23:25:54 192.168.2.230 GET /usage/ lastId=&batchSize=10000 8090 - 192.168.1.250 - - 401 2 5 0
2013-05-06 23:34:54 192.168.2.230 GET /usage lastId=&batchSize=10000 8090 Administrator 192.168.1.250 - - 301 0 0 0
2013-05-06 23:34:54 192.168.2.230 GET /usage/ lastId=&batchSize=10000 8090 - 192.168.1.250 - - 401 2 5 0

The Administrator account is what I've used to register SPF and the usage metering says to use the account, which you initially used to register SPF. However I noticed that their is an error in the documentation, which Microsoft has provided http://technet.microsoft.com/en-us/library/dn133231.aspx

The doco says add connect, delete, insert, select, update permissions for OnPremServicesCollectorSessions, OnPremServicesSubscriberWatermarks, and OnPremServicesSubscriberTombstones.  However I noticed when executing the sql script SPFUsageFeatureUpdate.sql  doesn't create a table called OnPremServicesCollectorSessions it actually creates a table called OnPremServicesUsageRecords. Screen shot below.

Any help on this would be really appreciated.

Did you grant the permissions to this table? If, so did the usage data show?

Permissions should be fine, as the other two tables are populated with data. Table OnPremServicesUsageRecords still has no data.

Hi -

I have the same problem, my IiS log looks the same;
GET /USAGE/usage lastId=&batchSize=10000 8090

Did you get to the bottom of the problem?

Thanks

Any news to this topic. I have same problem with 2012r2 environment. usage lastiiD=x and it should have some number in it ?. All permissions are allright Byt nothing comes to database. Is there anyway to reconfigure whole usage metering. I tried with powershell commands "new-spcfsettings" but it says I have allready server configured...