search cancel

error when check installation

book

Article ID: 230144

calendar_today

Updated On:

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