jordan.tait

Troubleshooting the Office 365 Connector

Discussion created by jordan.tait on Jun 27, 2019
Latest reply on Jun 27, 2019 by kishan.pant@chemtrolsinfotech.com

Applicable to the following Snow versions:

Snow License Manager 8.1 or above
Snow Integration Manager 5.3 or above

Snow Inventory Server 5.x or above

 

Please use the information available in this article to help troubleshoot the Office 365 connector. This will assist with understanding both why no data is present and why data hasn’t updated.

SNOW SERVICES THAT NEED TO BE RUNNING

Office 365 release uses Event Sourcing as the technology to handle changes of data in the application. Event Sourcing means that the master data is stored as a series of events happening over the lifetime of a certain entity.

 

For Office 365 data to be displayed correctly within the SLM portal, the following services will need to be started and running on the SLM application server.

 

If Office 365 data is unavailable, please review their accompanying log files in the directories below.

  • %:\Program Files\Snow Software\Snow License Manager\Services\EventStoreSnow
  • %:\Program Files\Snow Software\Snow License Manager\Services\Office365

 

WHAT TO REVIEW WHEN RUNNING THE CONNECTOR

 

When manually running the Office 365 connector from the Snow Integration Manager, logs and SQL tables can be reviewed to check whether data is being successfully pulled from the Office 365 portal.

It is recommended to raise the log level of the SIM to “ALL” when troubleshooting the Office 365 connector.

 

Snow Integration Manager Logging

 

The two tables to review during a manual aggregation of the connector:

 

API Import and API Import Command

 

API Import and API Import Command Results

 

This data will only be available during the manual aggregation of the connector. If there are issues with either the Event Store or Office 365 services, data will remain in these tables. Take note of the “ImportId” column above.

 

 

Once the aggregation has completed, a successful run would show the following in the SIM log file:

C:\Program Files\Snow Software\Logs\Snow Integration Manager

 

ImportId

 

 

Providing the Event Store and Office 365 services are running without errors, the API import tables are empty and the SIM log references a successful run, Office 365 data will now be available in the SLM portal.

 

WHAT SNOW SUPPORT WILL REQUIRE IF YOU EXPERIENCE ANY ISSUES

 

  • Zip of %:\Program Files\Snow Software\Logs\Snow Integration Manager (this is from the Server where Snow Integration Manager Office 365 connector is installed. %:\Program Files\Snow Software\Snow License Manager\Services\Office365

 

  • Zip of C:\Program Files\Snow Software\Logs\EventStoreService (this is from the Server where Snow License Manager is installed)

 

  • Zip of C:\Program Files\Snow Software\Logs\Office365Service (this is from the Server where Snow License Manager is installed)

 

  • Zip of the EventStore C:\ProgramData\SnowSoftware\LicenseManager\EventStore\Database (this is from the Server where Snow License Manager is installed)

 

Outcomes