Reconciliation Failed after upgrading FNMS to 2023 R1 - Invalid column name TenantID

[avi0408]

Hi Team, Please see below errors for recon failure -

Failed to import inventory devices with error message 'Invalid column name 'TenantID'. Invalid column name 'TenantID'. Invalid column name 'TenantID'. Invalid column name 'TenantID'.' Let us know how to fix these known.

attached debug log where it gives error on step "createvditemplate" and vdi.xml which writer is using.

Thanks, Awadh

[iSchmidt]

After updating from FNMS 2021 R2 to FNMS 2023 R1 (both on prem) we have a similar problem with "ExternalDeviceID".
The update completed without any problems, but afterwards the reconcile does not work.
(Thanks god, it is "only" the test environment!)

[mfranz]

Did you install a Beacon on your FNMS Application Server, or is it on another machine?

[avi0408]

Hello @mfranz 

We have multibeacon (single tenant) environment and beacons are present on another servers.

[SinghJ]

Did you check your connections on beacon? check there test connection. might be that will help !

[avi0408 · Accepted solution]

Hello, this issue was not linked with beacon, there was config issue happened during db upgrade in compliance db schema, which was fixed after re upgrading the entire platform. Thanks.