Hardware Inventory Report Issue

Usage and Config BFI
1

Hi,

Getting below warning message while opening Hardware inventory in BFI.

image
image962×526 22.1 KB

SQL server is accessible and running

Tema log…

[11/6/19 15:04:00:165 UTC] 00000060 com.ibm.ws.webcontainer.webapp I SRVE0292I: Servlet Message - [tema]:.[WARN] Exception happens while preparing response #<Sequel::DatabaseError: DBNAME: temadb - Java::ComMicrosoftSqlserverJdbc::SQLServerException: Arithmetic overflow error converting bigint to data type numeric.> [“com.microsoft.sqlserver.jdbc.SQLServerException.makeFromDatabaseError(com/microsoft/sqlserver/jdbc/SQLServerException.java:258)”,

Regards,
Shaban

1 Like
2

Hello

Please let me know if you were able to find an solution to this error.
We are also facing the same issue now.

3

I got the temporary solution from the developer site to fix this issue, I run below SQL query on my Inventory SQL database and It will be working until the next import will be completed.

update adm.current_hardware_inventory set no_processors_agt = no_processors_agt/10 where no_processors_agt > 100000

Still I am working with PMR team for permanent fix.

Regards,
Shaban

1 Like
4

Thank you Shahban. It worked!!

Please let me know in case you get the permanent fix for this. I am unable to get any other information on this.

Regards,
Arun Prakash

5

Still I am working on this hence share some logs to support team for review , I will share the solution once get it.

Regards,
Shaban

1 Like
6

Hello Shahban

Please let me know if you have got the permanent fix for this issue.

Still we have the same issue and unable to identify the fix.

Thanks
Arun Prakash

7

Hi Arun,

I believe your scanner version is coming 9.2.17 that’s need to revert on 9.2.16, this is scanner version bug need to wait new scanner version 9.2.18 to permanent fix.

Regards,
Shaban