ALERT: Some images may not load properly within the Knowledge Base Article. If you see a broken image, please right-click and select 'Open image in a new tab'. We apologize for this inconvenience.

Software Portal does not show any published software for some users

book

Article ID: 172652

calendar_today

Updated On:

Products

Software Management Solution

Issue/Introduction

For some users, no software is shown in the software portal when they log onto it. There are no errors in the server logs to indicate a problem.

Cause

This is caused by one of the published software belonging to two resource types.

Resolution

To resolve this issue, follow these steps:
Use the below SQL for the steps:

select name, guid, count (Guid)
from vRM_Software_Component_Item
group by Name, Guid
having count (Guid) > 1

  1. Run the above SQL using SQL Enterprise Manager or similar tool. If there are results, continue with the steps. If there are no results, the cause of the issue is not the one documented here.
  2. For each guid from the results of the query, run the following query to clear the base resource type.

delete from RM_ResourceSoftware_Component
where guid = 'insert_guid_here'


Once this is done, the Portal should work properly. Make sure to have the affected user close down the portal so it does not use the local cache before trying again.

As a more general fix, you can update the function used to fetch the resources, so it only returns one. This update will be undone if a configuration is run against Software Management Solution, or an upgrade/update occurs.

alter function [dbo].[fnSwpDisplayIconUrl] (@softwareGuid as uniqueidentifier, @publishingType as varchar(20))

    returns nvarchar(1024)

    as

    begin

        if (@publishingType = 'SoftwareComponent')

            return (select top 1 DisplayIconUrl from vSoftwareComponentIcon where SoftwareComponentGuid = @softwareGuid order by 1 desc)

        return dbo.fnSwmMdpDisplayIconUrl(@softwareGuid)

    end