Title

Known Issue: ApplicationDeletion import writer step may fail with error: 'The DELETE statement conflicted with the REFERENCE constraint "FK_OracleFeature_ScannedInstanceID".' (IOJ-2126421)

Description

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.

Resolution

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.

Fix status

This issue has been fixed in the following FlexNet Manager Suite releases: 2020 R2 (On Premises), 2020 R2 / Nov 2020 (Cloud)

Other information

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

Master issue ID: IOJ-2126421

Also known as: FNML-71136

Was this helpful?

Support Hub

Product

FlexNet Manager Suite

Deployment type

On-premises

Visibility

Guest

URL Name

known-issue-applicationdeletion-import-writer-step-may-fail-with-error-the-delete-statement-conflicted-with-the-reference-constraint-fk-oraclefeature-scannedinstanceid-ioj-2126421

Are you sure you want to cancel the case creation?

Case closed successfully

Action performed successfully

Upload Attachment

Maximum file size allowed is 3 MB.

File type not supported.

Supported file types:

Documents (.txt, .doc, .docx, .pdf), Images (.jpg, .png), Comma Separated Files (.csv) Speadsheets (.xlsx, .xls)

Are you sure you want to close this case

Get Hotline support

Products	Region	Phone Numbers
FlexNet Operations FlexNet Embedded FlexNet Publisher FlexNet Connect FlexNet Code Insight InstallAnywhere InstallShield	North America *	+1 630-332-2513 (toll) +1 877-279-2853 (toll-free in North America)
	Europe *	+44 1925 944367 (toll) +44 800 047 8642 (toll-free in Europe)
	Japan *	+81 3-4540-5335 (select option 2)
	Australia *	+61 3 9895 2177 +61 1800 560 603 (toll-free in Australia)
Usage Intelligence (formerly Revulytics) Compliance Intelligence	Please use the Case Portal to submit your support ticket or reach out to your Revenera contact.

Description

Resolution

Fix status

Other information

Related Articles

Please wait...

Case id: 00001065