error when check installation

Products

• CA Service Management - Asset Portfolio Management

Issue/Introduction

When run installation check inv_devide_tracking error

missing foreign key constraint in table [in_device_tracking]: column [in_device_id]

Environment

Release : 17.3

Component : CA SOFTWARE ASSET MANAGER

Resolution

You should be able to resolve this issue by rebuilding the foreign key structure.
Go to Admin>Maintenance>Rebuild system tables>Database structure and click the Repair foreign key structure link