Not able to run the usm_sp_archive_data

Document ID : KB000108935
Last Modified Date : 31/07/2018
Show Technical Document Details
Question:
Not able to run the usm_sp_archice_data getting the following error INFO:started archiving request object ERROR:Error while archivingColumn name or number of supplied values does not match table definition. Msg 3903, Level 16, State 1, Procedure usm_sp_archive_data, Line 42 [Batch Start Line 2] The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION.
Answer:
Reviewed all the colums in all the concerned tables that this is used by this stored procedure and then noticed that the following columns were missing in the usm2request table req_for_uuid req_by_uuid After recreating these columns in the usm2request table and then run the stored procedure and the stored procedure was success full