Remove failed transactions from MAP
We have several transactions in a MAP that continue to fail for various reasons. These transactions are no longer relevant so I would like to delete them so they do not appear in MAP logs. What is the best method for doing this? I’ve tried deleting the records from the “Fix” screen in the process errors window but that doesn’t prevent the transactions from attempting to integrate each time the MAP is run.
If these records are old and not relevant – you would need to exclude them from the source data so they aren’t being pulled and then attempted to be integrated.
You’d have to look at the data source of this map. It could be a SQL Query, it could be an Excel File, could be a query on CRM – etc. You’d have to look at the source and see what it would take to no longer show up when you press “Preview” on the data.
That could be editing a SQL table to mark as “processed” or adding a criteria, etc.
Thank you for this response. Can the data be edited in the “Fix” grid before re-running the MAP so the integration is successful? Or is the Fix grid just informational?
Yes – that is why I said you could possibly Fix the data there.
You can edit the data in that grid however you want and when you run the map FROM THAT WINDOW, SC will take the edited data and re-submit it. If you close the window and then re-run the map from scratch, SmartConnect would re-run the source query and pull that same problem data and you’ll just repeat the cycle.
If you would like to submit an answer or comment, please sign in to the eOne portal.