Office 365 data does not flow to the Snow License Manager Web Portal, no data was successfully imported as seen from the last import.

Looking at the O365.Import table, there are lots of imports that are in there:

EventaWarehouse log:

2021-01-27 21:48:12:024703 NFO Event warehouse service started

2021-01-27 21:48:12:024703 NFO Logging level is set to 'Info'

2021-01-27 21:48:12:024703 NFO Reading database connection string from Snow License Manager Web.config

2021-01-27 21:48:12:025706 NFO Database connection string successfully read

2021-01-27 21:48:12:045707 NFO Database is up to date, no migration required (MSSQL)

2021-01-27 21:48:12:045707 NFO In insert publish events channel listener

2021-01-27 21:48:12:046709 NFO In request insert events channel listener

2021-01-27 21:48:12:046709 NFO In get events channel listener

2021-01-27 21:48:12:046709 NFO In admin channel listener

Based from the EventWarehouse, the migration has been successfully done.

Office365 log:

2021-02-08 06:00:21.048 -08:00 [INF] (SnowSoftware.LicenseManager.Office365.Compliance.Handlers.ComplianceHandler) Office compliance finished for tenant: 0f01a950-a035-401e-8432-85fb865e1231

2021-02-08 10:12:20.054 -08:00 [INF] (SnowSoftware.LicenseManager.Office365.ImportService.ImportService) Received new ImportedComittedEvent (import id: 95bc3968-2e6b-4e50-b9ea-dcfedf636801, tenant: 0f01a950-a035-401e-8432-85fb865e1231)

2021-02-08 10:12:20.061 -08:00 [INF] (SnowSoftware.LicenseManager.Office365.ImportService.ImportService) Enqueuing import: 95bc3968-2e6b-4e50-b9ea-dcfedf636801 for tenantId: 0f01a950-a035-401e-8432-85fb865e1231

2021-02-08 10:13:08.811 -08:00 [INF] (SnowSoftware.LicenseManager.Office365.Heartbeat.HeartbeatService) Heartbeat Check: Office365 service is currently up and running.

2021-02-08 10:13:09.123 -08:00 [INF] (SnowSoftware.LicenseManager.Office365.Heartbeat.HeartbeatService) Heartbeat Check: Office365 service is currently up and running.

Looking at the O365 log, we can see it is queueing up the the imports, however, it did not end up successfully imported and the O365.import still with rows which would mean no import is happening.

Snow License Manager 9.7.x 

Snow Integration Manager 5.24 and later

Pre-Requisites:

a.Backup Snow Databases

b.Stop Office 365 service

c.Stop EventWarehouse service

dc.Stop Event Store service

1.Execute below script in SQL Management Studio

Use SnowLicenseManager

exec sp_msforeachtable @command1='Truncate Table ?',@whereand='and Schema_Id=Schema_id(''o365'')'

2.Excute below script

a.Check first if no record exist?

Use SnowLicenseManager

Select * from o365.MigrationProgress

Does it have record?

If No, execute below script, then after, proceed with #3

USE [SnowLicenseManager]
GO

INSERT [o365].[MigrationProgress] ([Data], [SequenceNumber], [IsCompleted], [Saved]) VALUES (NULL, -1, 1, CAST(N'2021-03-09T18:50:29.1266667' AS DateTime2))

GO

If there is a record, this article would probably may not resolve the issue, however, give it a go.

3.Start the following Services

a.Start EventStore service

b.Start EventWarehouse service

c.Start Office 365 service

4.Perform Test Connection in the SIM O365, make sure it test connection successfully, then proceed in aggregation of O365.

.

5.Wait until aggregation completed

6.Check the logs from O365, EventWarehouse and EventStore for any error

7.Check the SQL in SLM

Use SnowLicenseManager

select * from o365.MigrationProgress

select * from o365.Import

select * from o365.[User]

select * from o365.Portal

Those table should have records on each

8.Check the SLM Web Portal O365