Inventory Discovery By Scanner is failing

[adamcole]

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. 

[AdamCorsaw]

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

[adamcole]

Sounds good.  I already have an open ticket.

[Rohit_N]

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).