The writers phase of the inventory import may fail while executing the step ApplicationDeletion.
When this issue occurs, logging similar to the following will be found in the import log:
2020-07-06 07:24:01,819 [INFO ] All retries have been attempted for Writer 'ApplicationDeletion' 2020-07-06 07:24:01,835 [ERROR] System.Data.SqlClient.SqlException (0x80131904): The DELETE statement conflicted with the REFERENCE constraint "FK_OracleFeature_ScannedInstanceID". The conflict occurred in database "FNMP4", table "dbo.OracleFeature_MT". The DELETE statement conflicted with the REFERENCE constraint "FK_OracleFeature_ScannedInstanceID". The conflict occurred in database "FNMSCompliance", table "dbo.OracleFeature_MT". Removed 0 allocation records for instances which are about to be deleted Removed 0 instance history records for instances which are about to be deleted Removed 0 instance users for instances which are about to be deleted Removed 0 instance attributes for instances which are about to be deleted Removed 0 Oracle instances for instances which are about to be deleted Unassigned 0 instances from their parent instances which are about to be deleted Unassigned 0 instances from their manager instances which are about to be deleted The statement has been terminated. Removed 0 Installed Application Instances that no longer exist in source database connections. Installed Application Instance: Removed 0 Installed Application Instances that no longer exist in source database connections. The statement has been terminated.
If you believe that this problem may be affecting you, contact Flexera Support to discuss whether a hotfix or workaround may be available that is applicable to your situation.
This issue has been fixed in the following FlexNet Manager Suite releases: 2020 R2 (On Premises), 2020 R2 / Nov 2020 (Cloud)
Affected components: Inventory import (read/write/export), SAM for Oracle
Master issue ID: IOJ-2126421
Also known as: FNML-71136
Apr 20, 2022 02:28 PM - edited Jun 12, 2022 03:48 AM