ILMT import is getting failed

1

Hi Team,

We migrated the SQL DB from both BigFix and ILMT (Backup restore mode on new server). BigFix is working correctly, however ILMT does not want to do an import. I already tried a couple of steps (adding deleting datasources, reseting import sequence) but am kind of short with solution.

Please see the error below

2023-09-26 10:19:03 (+0:00:00.234) INFO: Data Source: Data Source-BIGFix, Bigfix Server Version: 9.5.14.73 with schema: 9.107, DB Version: 15.0.4322.2 RTM Standard Edition (64-bit)
2023-09-26 10:19:03 (+0:00:00.032) INFO: Check datasources connectivity: Success
2023-09-26 10:19:04 (+0:00:00.718) INFO: Calling Model.before_snapshot: Start
2023-09-26 10:19:04 (+0:00:00.360) INFO: Calling Model.before_snapshot: Failed
2023-09-26 10:19:04 (+0:00:00.000) ERROR: RuntimeError: datasource_sites_persistent needs a unique index on [:datasource_id, :tag]

Thanks in Advance…

2

The error

RuntimeError: datasource_sites_persistent needs a unique index on [:datasource_id, :tag]

suggests you are trying to create an already existing index… you might want to drop the table and restore it from the backup; or try to remove the index only, as it might be created by the application (I don’t know how ILMT manages its data).

3

Open a support case with IBM.