Bigfix Inventory SUA import taking too Long

Hi Team,

We have upgraded the Bigfix SUA to 9.2.6. After upgrading the initial import was completed in 7 hours . but the regular schedule import takes 18-19 hours to complete.

Need to help on this.

The import takes long time in below process:
2017-03-12 02:38:57 (+0:00:00.000) INFO: ETL from InventoryBuilder: Start
2017-03-12 20:49:55 (+18:10:57.830) INFO: (ImportThread) com.ibm.license.mgmt.etl.core.actions.RunInventoryBuilderAction::doAction::STATISTICS: 131105 product instances were processed.
2017-03-12 20:49:55 (+0:00:00.000) INFO: ETL from InventoryBuilder: Success

Hi Team,

I’m having the same problem. Can somebody help us?

Regards.

Anything in tema.log on the BigFix Inventory server that might shed light on this issue?

–Mark

How many endpoints are being imported at a time?

Its the Normal Scheduled Import . We usually scan our systems over weekened 8K endpoints.
But regular schduled scan is also taking 18 Hrs.

Hi,

To analyze there is a need to check import log. As it may contain sensitive data it is better idea to create a PMR in such case.

Regards,
Andrzej

We have already opened the PMR.

Hi,

Please give me your PMR number. If you need you can you private message.

Regards,
Andrzej

Hi swap041,

Has there been any update to this PMR?

Regards
Lima.croberto

Hi,

Can you send a PMR number?

Regards,
Andrzej

I my case the development team analyzed the Databases and told us to replace the jar file. PMR team would help you once you share logs

Hi swap041,

Can you tell me your database version?

If you can send me information on how you resolved this issue, send me a private message. I wonder if the import time has decreased after you update the JAR.

Apologies for the Delayed response.!!!
Once i replace the jar file. It worked find and import was normal.

Hi swap041,

What’s name of jar file you replaced and the import time now?