The list of available software in the Software Portal is empty for all users despite having software or policies published to the portal.
MainController failure. Invalid column name 'Category'. Invalid column name 'Category'. Invalid column name 'Category'. ORDER BY items must appear in the select list if SELECT DISTINCT is specified. [System.Data.SqlClient.SqlException @ .Net SqlClient Data Provider] at System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
During the upgrade the SQL updates did not apply.
To fix the issue, follow these steps:
Log onto the Symantec Management Platform (SMP) server as the Application identity.
Launch an administrative command prompt.
Change directory to D:\Program Files\Altiris\Notification Server\Bin (drive letter may differ).
Run the following command, but NOTE that the drive or path may be different based on install choices: AeXConfig.exe /configure "D:\Program Files\Altiris\SoftwareManagementSolution\Config\SoftwareManagementSolution.config"
Also run the following command: AeXConfig.exe /configure "D:\Program Files\Altiris\SoftwareManagementSolution\Config\SoftwareManagementSolution_hotfix.config"
Note that services will be restarted during this process.
Subscribing will provide email updates when this Article is updated. Login is required.