Here is the fix. Run the following under Host > SQL as script provided you are running DMX 03.02.x
IF EXISTS (select * from dbo.sysobjects where id = object_id(N'{databaseOwner}{objectQualifier}DMX_GetAllPortalCollections') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
DROP PROCEDURE {databaseOwner}{objectQualifier}DMX_GetAllPortalCollections
GO
CREATE PROCEDURE {databaseOwner}{objectQualifier}DMX_GetAllPortalCollections
@PortalId Int
AS
SELECT {objectQualifier}DMX_Entries.Description+' ('+ISNULL(p.Description, 'Root')+')' AS Description, {objectQualifier}DMX_Entries.EntryId, {objectQualifier}DMX_Entries.CollectionId, {objectQualifier}DMX_Entries.EditRoles, {objectQualifier}DMX_Entries.ViewRoles, {objectQualifier}DMX_Extensions.ResourceFile, {objectQualifier}DMX_Extensions.Icon16
FROM ({objectQualifier}DMX_Entries LEFT JOIN {objectQualifier}DMX_Extensions ON {objectQualifier}DMX_Entries.EntryType={objectQualifier}DMX_Extensions.ExtensionKey) LEFT JOIN {objectQualifier}DMX_Entries AS p ON {objectQualifier}DMX_Entries.CollectionId=p.EntryId
WHERE (((LEFT({objectQualifier}DMX_Entries.EntryType,10)='Collection') Or (LEFT({objectQualifier}DMX_Entries.EntryType,17)='Custom.Collection')) And (({objectQualifier}DMX_Entries.Deleted)=0) And (({objectQualifier}DMX_Entries.PortalId)=@PortalId)
And (({objectQualifier}DMX_Extensions.PortalId)=@PortalId))
ORDER BY {objectQualifier}DMX_Entries.Description
GO