Troubleshooting Tips > Inventory details not displayed after scanning

Inventory details not displayed after scanning

Tags:  
If there are some special characters in the Hardware or software assets scanned, they will not be displayed in the Assets report.
It is because of the limitation in the inbuilt MySQL. Please follow the steps to fix this.


1)Login to the scanfi database.

Open CMD prompt and move to folder probe/scanfi/mysql/bin

pls find the port number and password from the file probe/scanfi/conf/database_params.conf

bin:\>  mysql.exe -u root --port=<Port_No> --password=<password> scanfi

2) Run these queries in the mysql prompt:

  1. alter table SoftwareList modify SOFTWARENAME BINARY(250);
  2. alter table SoftwareList modify SOFTWARENAME VARCHAR(250) CHARACTER SET utf8;
Next two steps might differ based on the special character that got scanned(We can find them in scanFi logs)
  1. delete from SoftwareList where SOFTWARENAME like 'ValuAdder%Valuation Calculator%';
  2. delete from SoftwareList where SOFTWARENAME like 'T-Mobile Wing%Manual%';
3) Stop OpManager probe service and make sure that scanFi service is also stopped

4)Edit startDB.bat which is under /probe/scanfi/bin

@start "MySQL" /B "%DB_HOME%\bin\mysqld-nt" --no-defaults --standalone --basedir="%DB_HOME%" --port=%DB_PORT%
 --datadir="%DB_HOME%\data" --default-character-set=utf8

5)Edit database_params.conf which is under probe/scanfi/conf/
    1. url=jdbc\:mysql\://localhost\:43306/scanfi?useUnicode\=true&characterEncoding\=utf8
6)Start OpManager Probe service

7)Try to scan those devices again.



 RSS of this page

rtttrrb