cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Known Issue: Inventory import step "Remove local installer evidence linked to Flexera installer evidence" may fail with conflicted reference constraint FK_IBMLicenseService*ProductData_InstallerEvidenceID_MT after ARL evidence is created for IBM License Service data (IOK-706964)

Known Issue: Inventory import step "Remove local installer evidence linked to Flexera installer evidence" may fail with conflicted reference constraint FK_IBMLicenseService*ProductData_InstallerEvidenceID_MT after ARL evidence is created for IBM License Service data (IOK-706964)

Symptoms

The “Remove local installer evidence linked to Flexera installer evidence” import writer step fails with either of the following errors:

Error: The DELETE statement conflicted with the REFERENCE constraint "FK_IBMLicenseServiceProductData_InstallerEvidenceID_MT". The conflict occurred in database "FNMP182", table "dbo.IBMLicenseServiceProductData_MT".

Or:

Error: The DELETE statement conflicted with the REFERENCE constraint "FK_IBMLicenseServiceBundledProductData_InstallerEvidenceID_MT". The conflict occurred in database "FNMP3", table "dbo.IBMLicenseServiceBundledProductData_MT".

Details

This issue may occur after importing data from IBM License Service, if evidence imported from that service is subsequently added to the application recognition library (ARL) that is published by Flexera.

Mitigation

This mitigation can be applied to FlexNet Manager Suite 2022 R1 (on premises) deployments.

Open the C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Writer\InstallerEvidence.xml file on the batch server in a text editor.

Add the following SQL query content before the line “DELETE ie FROM InstallerEvidence_T ie" (line 574) in the writer named “Remove local installer evidence linked to Flexera installer evidence”:

UPDATE bpd
SET InstallerEvidenceID = NULL, SoftwareTitleID = NULL
FROM dbo.IBMLicenseServiceBundledProductData bpd
WHERE EXISTS (
  SELECT 'x' FROM #InstallerEvidenceToDelete d
  WHERE d.InstallerEvidenceID = bpd.InstallerEvidenceID
)
PRINT N'Updated ' + CAST(@@ROWCOUNT AS nvarchar(255)) + N' IBM License Service bundled product consumption rows where installer evidence is being removed.'
 
UPDATE pd
SET InstallerEvidenceID = NULL, SoftwareTitleID = NULL
FROM dbo.IBMLicenseServiceProductData pd
WHERE EXISTS (
  SELECT 'x' FROM #InstallerEvidenceToDelete d
  WHERE d.InstallerEvidenceID = pd.InstallerEvidenceID
)
PRINT N'Updated ' + CAST(@@ROWCOUNT AS nvarchar(255)) + N' IBM License Service product consumption rows where installer evidence is being removed.'

Fix status

This issue has been fixed in the following FlexNet Manager Suite release: 2022 R1.3 / Jul 2022 (Cloud)

This issue is planned to be addressed in the following future FlexNet Manager Suite release: 2022 R2 (On Premises)

Other information

Affected components: Inventory import (read/write/export), SAM for IBM

Master issue ID: IOK-706964

Also known as: FNML-76080

Labels (1)
Was this article helpful? Yes No

Tip: If you have been impacted by this issue, please click the KUDOS button above. This helps to track the relative significance and importance of issues. Clicking on an option against "Was this article helpful?" also helps assess and improve the usefulness of content.

No ratings
Version history
Last update:
‎Sep 07, 2022 02:30 PM
Updated by: