When SD.DataServices is trying to retrieve all collections from SMP, GetAllCollections method fails due to the error in All Collections Query report.
Error message that appears in SMP logs:
The RawSqlDataSource 'def00d55-2c5a-410b-af05-3a5725a17fc7' was not able to run.
[Altiris.DataSource.Exceptions.DataSourceSchemaException: An unexpected SQL error occurred when retrieving the schema from the RawSqlDataSource. --->
System.Data.SqlClient.SqlException: The multi-part identifier "v1.Description" could not be bound.
Incorrect syntax of the report query.
This will be fixed in ServiceDesk 8.0 HF2.
To fix this in ServiceDesk 8.0 or 8.0 HF1, please download the attached report file and import this in Symantec Management Console (not Process Manager Portal).