CA Software Asset Manager Import Error ASP-I0
search cancel

CA Software Asset Manager Import Error ASP-I0


Article ID: 219675


Updated On:


CA Service Management - Service Desk Manager


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]



Release : 17.3

Component : Software Asset Management


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