Duplicate application entries while searching in Package Feed Module

Duplicate application entries while searching in Package Feed Module

Summary:

Duplicate application entries while searching in Package Feed Module

Symptoms:

While searching for applications in the Package Feed, duplicate entries are seen for some of the applications.

Steps To Reproduce:

To check the duplicate entries present in the Application catalog:
1. Install the latest build of Adminstudio 2019/2019 R1/2019R2.
2. Launch Application Manager from the start menu
3. Create a new catalog and connect to the created catalog.
4. Click on Package Feed Button from the ribbon and wait till the data is updated.Search Panel for an application in Package Feed.jpg

5. Once the data is updated, enter the product name and click on the Search button. Duplicate entries are displayed as shown below.

Duplicate Entries showing for an Application.JPG

6. Run the following SQL query against the Application catalog.

Note: The following SQL Script – Identifies and prints the number of duplicate records (does not delete).

***SQL Script***

DECLARE @duplicateCount int;

WITH PacakgeFeedCTE AS
(
SELECT *, Row_Number() OVER (PARTITION BY PackageFeedId ORDER BY OID) AS RowNumber FROM ASPackageFeed
)
SELECT @duplicateCount = count(*) FROM PacakgeFeedCTE WHERE RowNumber > 1

PRINT 'Duplicate record count: ' + + CAST(@duplicateCount AS VARCHAR)

GO

All the Duplicate Record count showing in the Package Feed Table.JPG

Resolution:

 Run the following SQL query against the Application catalog.
(Refer the attached screenshot "Duplicate records got deleted.JPG" for more details).

Note: The following SQL Script -Identifies and deletes all the duplicate records.

***SQL Script***

WITH PacakgeFeedCTE AS
(
SELECT *, Row_Number() OVER (PARTITION BY PackageFeedId ORDER BY OID) AS RowNumber FROM ASPackageFeed
)
DELETE FROM PacakgeFeedCTE WHERE RowNumber > 1
GO

Duplicate records got deleted.JPG

Affected AdminStudio Versions
The following versions of Adminstudio that are affected:

AdminStudio 2019

AdminStudio 2019 R1

AdminStudio 2019 R2

Additional Information
If there are any additional issues, please contact our Technical Support team

Labels (1)
Was this article helpful? Yes No
100% helpful (1/1)
Version history
Revision #:
5 of 5
Last update:
‎Mar 19, 2020 07:59 AM
Updated by:
 
Contributors