Due to the size of the test database server , we have restore to a new database server . All the registry entry for database have been updated , but the batch server is not trigger the reconcilation.
Even running the command line by hand via the command prompt . It not trigger any log file at all.
Any suggestion ?
‎Jun 17, 2022 02:31 PM
Sounds like your database server name has changed?
In this case, you have to update the database server name in the [Server] column in the [ComplianceConnection] table.
Without this modification, FNMS will not find the source databases for importing any inventory data.
‎Jun 25, 2022 10:32 AM
Hello, I was wondering after you changed the databases did you re-run the config scripts?
https://docs.flexera.com/FlexNetManagerSuite2022R1/EN/WebHelp/PDF%20Documents/On-Prem/Installing%20FNMS%202022%20R1%20On-Premises.pdf#page=54
You would want to re-run the .\Config.ps1 so you can re-configure FNMS but you must run it with the following switch.
.\Config.ps1 "Config\FNMS Windows Authentication Config.xml" forceUpdateConfig
This will prompt you to re-enter the database information where you can input the new database.
I hope that helps.
‎Jun 17, 2022 07:53 PM
‎Jun 18, 2022 05:52 AM
Tried that fix… no success… issue is with reconcile script only … the only issue before this happened is the large number of files being processed
‎Jun 18, 2022 07:46 AM
I would suggest following:
A) Check logs for errors
- BatchProcessor.log, BatchProcessScheduler.log
B) Check entries in Compliance DB tables
Table BatchProcessor
- 1 entry might point to old DB server
Table ComplianceSetting
- 4 entries might point to old DB server
Restart BatchProcessor Services after changing DB entries to new DB server
‎Jun 20, 2022 01:41 AM
Checked the above … nothing unusual appeared in the logs.
Within the batch processor execution table, I needed to set the job from 3 (running) to 5 ( failed).
then trigger again
‎Jun 25, 2022 02:55 AM
The job sometimes does not update straight away
‎Jun 25, 2022 02:56 AM
Sounds like your database server name has changed?
In this case, you have to update the database server name in the [Server] column in the [ComplianceConnection] table.
Without this modification, FNMS will not find the source databases for importing any inventory data.
‎Jun 25, 2022 10:32 AM
Did that last week, it’s running now. Thanks …
‎Jun 25, 2022 05:51 PM