Unable to extract some search results from APM

Products

• CA IT Asset Manager Asset Portfolio Management

Issue/Introduction

Getting below error.  The same search export was working before.

The error message contains

Violation of PRIMARY KEY constraint 'xpkarg_mxl_string'. Cannot insert duplicate key in object 'dbo.arg_xml_string'. The duplicate key value is (1562345612,0). The statement has been terminated.

Environment

Release : 17.3

Resolution

Run these queries  in mdb

select * into arg_xml_string2 from arg_xml_string where id=1562345612

(this will create a new table arg_xml_string2 and add those two rows from arg_xml_string table)

delete from arg_xml_string where id=1562345612

(this will delete those two records from arg_xml_string table)

then run the export.