Hey @sanjayknp !
To better guide in getting you help here, are you referring to inserting data via Data Insertion API or through Data Sources? Or is a different method in play?
You are much better off verifying / preventing duplicate data upload then trying to rectify it retroactively. If you are submitting through Bulk Data Insertion API (https://express.adobe.com/page/0jhQHMs74AtYz/) or (https://developer.adobe.com/analytics-apis/docs/2.0/guides/endpoints/bulk-data-insertion/faq/), there is an option to "Validate" when you submit to ensure that your data is formatted correctly and there are no issues. There are also error codes you should receive if the data isn't successfully received that should give you more context on whether the data was rejected or processed.
What I would recommend, is verifying by taking a bit of the sample offline data as a hit that was uploaded before failing and see if you can find in inside Workspace. If you can, you might have already successfully uploaded the data.
Hope this helps and best of luck!!
Andy