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.
5. Once the data is updated, enter the product name and click on the Search button. Duplicate entries are displayed as shown below.
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
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
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
Related Articles
Request an application to be added to the Package Feed Module 47Number of Views Activating Package Feed Module 30Number of Views How should requests to add new Package Feed Module entries be submitted? 35Number of Views How do we validate Package Feed Module setup files are safe? 5Number of Views How can we add new packages to the Package Feed Module 35Number of Views
Hi, I am Reva - Ask me anything.
No new updates
Thanks for the feedback!
Your feedback has been saved.Rate this response:
Add Additional feedback ( Optional )
Are you sure you want to cancel
the case creation?
Are you sure you want to cancel the case creation?
Are you sure you want to close this case
| Products | Region | Phone Numbers |
|---|---|---|
| FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield |
North America * |
+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America) |
| Europe * |
+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe) |
|
| Japan * | +81 3-4540-5335 (select option 2) | |
| Australia * |
+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia) |
|
|
Usage Intelligence (formerly
Revulytics) Compliance Intelligence |
Please use the Case Portal to submit your support ticket or reach out to your Revenera contact. | |
Case id: 00001065
Activity: Status change: 2 hours ago