Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class
624 views

Inventory Discovery By Scanner is failing

We are setting up inventory scans for the first time on our desktops and while we are successfully recieving scans for computers that have agents installed, the job is still failing.  It is not clear to me in the log what the problem is and the error.log and related logs contain no information. 

 

 

0 Likes
14 Replies
Absent Member.. Absent Member..
Absent Member..

You'll need to work with HP to get a version of the scanner that won't blow up UCMDB.

0 Likes
Cadet 2nd Class Cadet 2nd Class
Cadet 2nd Class

Sounds good.  I already have an open ticket.

0 Likes
Captain
Captain

Dears,
This issue happens due to size of column named "CI" in LOA table in UCMDB database. This field basically store the name of discovery job as value which you usually see in Last Discovered by field in CI property. If length of this value exceeds the pre-defined size of the field, you started getting the error in Inventory Scan.

To resolve, please follow below steps.

1. Stop UCMDB server
2. Change the column size in DB
For Oracle: ALTER TABLE LOA MODIFY CI varchar(255)
For MS-SQL: ALTER TABLE LOA ALTER COLUMN CI varchar(255)
3. Start the UCMDB Server.
4. Run the discovery again.
Note - It is recommended to take DB backup prior to change (Step 2).

Tags (4)
0 Likes
The opinions expressed above are the personal opinions of the authors, not of Micro Focus. By using this site, you accept the Terms of Use and Rules of Participation. Certain versions of content ("Material") accessible here may contain branding from Hewlett-Packard Company (now HP Inc.) and Hewlett Packard Enterprise Company. As of September 1, 2017, the Material is now offered by Micro Focus, a separately owned and operated company. Any reference to the HP and Hewlett Packard Enterprise/HPE marks is historical in nature, and the HP and Hewlett Packard Enterprise/HPE marks are the property of their respective owners.