Idea ID: 1768682

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

Status : Waiting for Votes
over 2 years ago

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.  

 

 

Tags:

  • 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)')