0

I tried to delete Account Records using workbench and it gives me this error:

Failed: InvalidBatch : Referenced file "request.txt" is missing or is a directory

I am not able to understand how to create "request.txt" and what my zip file should include. As in, my Zip file should include csv file containing Ids of the Account records that I want to delete or every records itself?

  • 1
    You don't need to provide any zip file, you can select the csv file directly while deleting, which has all the ids of the records to be deleted – Hemant Jain Aug 3 '18 at 11:26
  • I have tried that, but it gives me error "The file uploaded is too large. Please try again. (Error 1)". So I tried with the zipped file. @HemantJain – Jahnvi Jasani Aug 3 '18 at 11:41
1

First of you need to export a .csv file with extract of Account records only with Ids as follows

SELECT Id FROM Account WHERE Recordtype.Name='<your recordtype name>';

Then from workbench select the .csv and proceed with Delete

delete

Here to delete from file, the file should be either .csv or .xml-formatted manifest called request.txt.

May be you didn't select correct file that's why the error is.

Update

I think workbench can process max 50,000 records in a csv.

It is recommended to use Dataloader for this kind of deletion process.

  • I added proper .csv file but its shows error "The file uploaded is too large. Please try again. (Error 1)" – Jahnvi Jasani Aug 3 '18 at 11:54
  • how many records are there in the file? whats the size of the file? – Santanu Boral Aug 3 '18 at 11:59
  • Total Records are - 170735 file size - 3,335 kb – Jahnvi Jasani Aug 3 '18 at 12:02
  • why don't to use dataloader? – Santanu Boral Aug 3 '18 at 12:03
  • 1
    You just a create files with recordId max 50000 records and process from workbench – Santanu Boral Aug 3 '18 at 12:11
0

I got this to work by renaming my CSV data file to: request.txt The file contains ID's to delete. The file is zipped and uploaded to workbench.

The job ran okay, but I hit a limit on how many records I could process (this is a partial-org).

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.