Symptoms

Office 365. readCSPAccounts.py script fails:

Unable to prepare the import data because of error: The appropriate service plan can not be found.

More specific error could be found in the sitelog:

DEBUG aps_endpoint: Unable to use the service plan '1234' because it contains a resource rate of a resource which is not an Office 365 resource.

Cause

Checking the mentioned Service Plan it appears it exactly contains a Resource Rate based on non-Office 365 Resource - for instance, pure Billing Resource, which is not created on the Operations side.

Resolution

Set the following settings on the Billing side for the Resource Rate in question:

Show in Store   No
Show in CP      No

and repeat the data collection procedure. Then switch the settings back.

Documentation improvement request #APSA-19539: "[Documentation] Office 365: readCSPAccounts.py script does not support non-Office 365 Resources in Billing" has been created to reflect it in the Provider's Guide.

Internal content