Unable to delete the software installation record if amSAMInstCompAnalysis has a reference stored

Idea ID 1768682

Unable to delete the software installation record if amSAMInstCompAnalysis has a reference stored

Hi, 

We are using Asset manager 9.60 and SLOBestPracticePackage9.7.12.0.  We are facing issue while deleting the software installation record when Software compliance analysis (amSAMInstCompAnalysis) table stores the reference to the softinstall record.   Due to the link type used, when the user tries to delete (or) deleting through Connect-IT fails with the error message: 

"[(amComputerDst) amComputer] (16384) 'AssetCenter/Asset Manager' API error: 'Cannot delete record from table 'Software installations or utilizations (amSoftInstall)' because it is referenced by at least one record from table 'SoftInstall compliance detail (amSAMInstCompAnalysis) (link 'Software installation compliance analysis (InstallCompAnalysis)').\nUnknown error; rc=-2001'

In order to delete the software installation record, we need to delete the record from the amSAMInstCompAnalysis table first and then delete the software installation record.   

Due to the link type used between the amSAMInstCompAnalysis and amSoftInstall table, we are unable to delete the software installation directly.  

This is the OOTB link and hence, we cannot modify the link type in asset manager.  Looks like, changing the link type to delete the record from amSAMInstCompAnalysis or resettin the foreign key should help us to fix this issue.   

There are workarounds which can be used to delete the records.  But, we need to implement multiple workarounds to handle the deletion by user and Connect-IT scenario.  

We have disabled writing the data to the amSAMInstCompAnalysis for now.   However, customer is really interested to use this table for analysis purpose and want to know the feasibility of changing this link type to allow the software installation record to delete without manually deleting the record from amSAMInstCompAnalysis table.  

 

 

2 Comments
Micro Focus Frequent Contributor
Micro Focus Frequent Contributor
Status changed to: Waiting for Votes
 
Honored Contributor.
Honored Contributor.

We are also getting the same error even when we are trying to delete the software installation records manually.

 

Cannot delete record from table 'Software installations or utilizations (amSoftInstall)' because it is referenced by at least one record from table 'SoftInstall compliance detail (amSAMInstCompAnalysis) (link 'Software installation compliance analysis (InstallCompAnalysis)')

The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.