I am involved in the Process of Workflow Archiving. As per sap documentation we can archive only completed and canceled workitems. In my Production system there are lot of workflows which are in error status. Is it possible to archive these workflows with status "Error"? If not if I delete these workflows using tcode "SWWL" will it cause any issue. Please advice.
You can use the archiving functionality to get rid of your workitems (tx SARA, object WORKITEM).
If you have many workflows in error and want to get rid of those as well you might have to set them to status 'CANCELLED' first. Unfortunately there is no standard SAP functionality to do that in mass. But you can easily develop your own program to do it, using function module SAP_WAPI_ADM_WORKFLOW_CANCEL.