Licenses import scripts doesn't work anymore. ASP-0 An error occurred" appears and it locks every import.

Products

• CA IT Asset Manager
• CA Software Asset Manager (CA SAM)
• ASSET PORTFOLIO MGMT- SERVER
• CA Service Management - Asset Portfolio Management
• CA Service Management - Service Desk Manager

Issue/Introduction

In the log we can see:

----------------- Step 4/4 -----------------
Table: 'license_import_pool'
Strategy: 'incremental'
Mode: 'transaction'
File list:
 - import_lic_XXX.csv (UTF-8) (Headline validation: loose)
Data sources: none
Import feed ID: XXX data
Restricted import: no
Â
Statistics:
 ASP-0: An error occurred

 

Cause

After an upgrade a Rebuild of the Import Buffer tables need to be handled.

Environment

CA Software Asset Manager

Resolution

Rebuild import buffer tables
To do that, login to CA SAM console and select: 
Admin>Maintenance>Rebuild system tables > Rebuild import buffer tables

 

<Please see attached file for image>

src="/servlet/servlet.FileDownload?file=0150c000004AKHpAAO" alt="ScreenHunter_319 Jun. 19 14.37.jpg" width="1211" height="534">