Hi,
I wonder if someone run into the same problem after upgrade.
The upgrade itself went smoothly but when we run reconciliation afterwards we got following error in the logs:
Failed to execute Writer 'CreateVDIUserConnections' from file C:\ProgramData\Flexera Software\Compliance\ImportProcedures\Inventory\Writer\VDI.xml, at step line 78
Error: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_VDIUserConnection_ComplianceUser". The conflict occurred in database "FNMSCompliance", table "dbo.ComplianceUser_MT", column 'ComplianceUserID'.
Removed 0 VDI user connection records for users who no longer have access to VDIs
Updated inventory date for 0 VDI user connection records.
Anyone?
Best regards,
Paweł
Apr 22, 2022 03:07 AM
See the following article for information about this issue: CreateVDIUserConnections writer step may fail with error: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_VDIUserConnection_ComplianceUser". (IOJ-2258826)
@ppyrzynski - thanks for working with Flexera Support to diagnose this!
Apr 27, 2022 02:49 AM
We have plan on coming week. Will share feedback on this.
Apr 22, 2022 03:58 AM
See the following article for information about this issue: CreateVDIUserConnections writer step may fail with error: The INSERT statement conflicted with the FOREIGN KEY constraint "FK_VDIUserConnection_ComplianceUser". (IOJ-2258826)
@ppyrzynski - thanks for working with Flexera Support to diagnose this!
Apr 27, 2022 02:49 AM