Failed to link an inventory to an asset

[#1]

Summary

When users try to link a computer from the inventory list to an existing asset, error message is returned saying "1 of the selected computers failed to link to the matched asset" 1 of the selected computers failed to link to the matched asset

Symptoms

When users try to link a computer from the inventory list to an exsiting asset, the following pop up error may appear:

1 of the selected computers failed to link to the matched asset

Cause

This error could be caused by assets existing in the ECM database without their placeholder inventory records (dummy records).

These assets can be identified by running the following query against the FNMP database. Any computers returned from this query will raise this error:
----------------
SELECT a.*

FROM Asset AS a

INNER JOIN AssetType AS at ON at.AssetTypeID = a.AssetTypeID

LEFT OUTER JOIN ComplianceComputer AS cc ON cc.AssetID = a.AssetID

WHERE cc.ComplianceComputerID IS NULL

AND at.ManagedType = 1
-----------------

Resolution

If the computer in question is indeed in the returned list of the SQL query above, the following query will create a dummy record for each asset that do not have an entry in compliancecomputer table associate with it.

------------------

INSERT INTO ComplianceComputer (AssetID, SerialNo, ComputerName, ComplianceComputerTypeID, ComplianceComputerStatusID, AssetComplianceStatusID)

SELECT

a.AssetID,

a.SerialNumber,

a.ShortDescription,

1,

4,

NULL

FROM

dbo.Asset AS a

INNER JOIN dbo.AssetType AS ast

ON ast.AssetTypeID = a.AssetTypeID

WHERE

ast.ManagedType = 1

AND NOT EXISTS (

SELECT '1' FROM dbo.ComplianceComputer AS cc

WHERE cc.AssetID = a.AssetID

)

------------------