cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

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

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

(1) 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.

View solution in original post

(5) Replies

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
By Level 17 Champion
Level 17 Champion

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

Hello @mfranz 

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

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

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.