CA Software Asset Manager Import Error ASP-I0

Products

• CA Service Management - Service Desk Manager

Issue/Introduction

SAM reprocess the data exchange jobs import and encounters  ASP-I0 error.

When checking logs, I see this error: handle_cron_results(): crontab with id: [5]: failed, error: [asp_db_bulk_delete_mssql->delete_by_copy(): failed. error: PK information could not be retrieved for table [inv_raw_arp_ib]

 

Environment

Release : 17.3

Component : Software Asset Management

Resolution

Please perform the following as a superuser (aka the admin user) in the system.

Admin->Maintenance->Rebuild System Tables.
In the left hand box, in the database structure section, click Rebuild Import Buffer Tables.

Then click on the Repair Foreign Key Structure.
Then Repair Indexes
Then Rebuild Indexes.

After this, you should be able to rerun your import