This website uses cookies. By clicking Accept, you consent to the use of cookies. Click Here to learn more about how we use cookies.
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
- Revenera Community
- :
- FlexNet Operations
- :
- FlexNet Operations Knowledge Base
- :
- FlexNet Operations On-Premises error: The INSERT statement conflicted with the FOREIGN KEY constrain...
Subscribe
- Mark as New
- Mark as Read
- Subscribe
- Printer Friendly Page
- Report Inappropriate Content
FlexNet Operations On-Premises error: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_E_ACT"
FlexNet Operations On-Premises error: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_E_ACT"
Summary
Flexnet Operations reporting transformation fails with the error "The INSERT statement conflicted with the FOREIGN KEY constraint "FK_E_ACT". "Symptoms
The following FlexNet Operations On-Premises error has been observed when performing a data transformation for Flexnet Operations reporting:The INSERT statement conflicted with the FOREIGN KEY constraint "FK_E_ACT".
Cause
Through testing it has been seen that the issue occurs when a product is in draft state and is not being pushed into the PRODUCT_DIMENSION table but is being pushed into the ENTITLEMENT_FACT table. This causes a conflict in Foreign keys in the reporting database and causes the transformation to fail.Resolution
To resolve the issue, locate the draft product that is associated with a test entitlement and set it to deployed. This will allow the transformation to proceed.
No ratings