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.

Adding computer to Filter results in an error "An error has occurred while displaying data" if the same resource is added twice.

book

Article ID: 195231

calendar_today

Updated On:

Products

Management Platform (Formerly known as Notification Server)

Issue/Introduction

The customer have created a custom computer filter.

And after adding a resource the 2nd time into the same filter, he is getting an error:

"An error has occurred while displaying data. Check server logs for details."

 

Steps for reproducing the issue:

  1. Create a simple Computer Filter.
  2. Add New resource (or use an existing one in current filter resource) into this filter, so it would be added separately in Include list:

  3. Now if you would try to add this resource again using Right-Click on Computer > Add to Filter  - and adding to the same filter - you will receive the error message referenced above. Technically now this filter has this resource added 2 times (filtered by name, and then by resource GUID).

 

 

In a Profiler trace you can see that we try to add the same GUID a second time. Something like this:

EXECUTE spCollectionIncludesResourceInsert @CollectionGuid='f49a25e1-3cd3-4f39-b7a3-d2d05a7b4846', @ResourceGuidList=N'e6d221d0-10c6-44b5-b6d0-e999a1bcb684e6d221d0-10c6-44b5-b6d0-e999a1bcb684', @cleanImport=1

Thus full error actually is:

Item save to DB failed: f49a25e1-3cd3-4f39-b7a3-d2d05a7b4846, (fromClone=False, user=domain\smpservice)

Violation of PRIMARY KEY constraint 'PK_CCollectionIncludeResource'. Cannot insert duplicate key in object 'dbo.CollectionIncludeResource'. The duplicate key value is (f49a25e1-3cd3-4f39-b7a3-d2d05a7b4846, a116b6b0-d314-4a91-b7a6-4d9fcdebcf00).
The statement has been terminated.

 

Might require to review the Stored procedure to exclude existing resources to be re-added or/and provide more detailed error/explanation why it fails (as this resource have been already added into this filter)

Cause

Known issue. There was an issue with ensuring the uniqueness for all include/exclude values.

Environment

ITMS 8.5 RU3, RU4

Resolution

This issue has been reported to the Symantec Development team. A fix for this is currently targeted to the next release after ITMS 8.5 RU4.

There is a workaround for this issue.  There are 4 updated stored procedures that needs to be applied:

  • spCollectionIncludesResourceInsert.sql
  • spCollectionIncludesCollectionInsert.sql
  • spCollectionExcludesResourceInsert.sql
  • spCollectionExcludesCollectionInsert.sql

Download the attached "UpdatedStoredProcedures.zip" and run them in Microsoft SQL Management Studio. These will drop the existing ones and recreate them with the necessary fixes.

Attachments

1594850790940__UpdatedStoredProcedures.zip get_app