Some users may experience issues accessing the case portal. For more information, please click here.

This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Accept
Reject
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Show  only  | Search instead for 
Did you mean: 
sasikumar_r
Level 7
‎Apr 23, 2020 01:37 AM

Duplicate records in Inventory Database Post Upgrade to 2019 R2

Hi,

we recently upgraded our multi-tenant environment from 2019R1.3 to 2019R2. After the upgrade we are able to see 2 records on computer table(inventory DB) for a same device. 1 entry with older date(date we upgraded the application) & 2nd entry with latest date,the 2nd entry should have got created post upgrade.Issue is only with version 13.5, for 13.1\13.2 & 14.1 we see only one entry. Agents which are all on 13.5 has got duplicate entries.
Analyzing further i suspect below mentioned 2 stored procedures is causing this issue,

BindFastToComputerAndUser
BindToComputerAndUser

looks like below condition has been added on these Stored procedures which has created 2nd entry without Agentid.

-- Determine if the computer was reported by an agent whose
-- version is less than 13.6. If so, set the AgentID to NULL.

these duplicate entry in inventory DB causing inaccurate information on the compliance DB. Raised a case already and shared my findings,please assist if anyone come across similar issue.

Thank you

This thread has been automatically locked due to inactivity.

To continue the discussion, please start a new thread.
1 Reply
darwin_hammons
Level 3
‎Dec 21, 2020 01:45 PM

Yes, Agree there is some problem after upgrading to 2019 R2 on-prem. The Inventory process is not running as it should. Importing seems to be not working.
DarwinH
0 Kudos