I am running into an issue when running an update using the mass data loader. I run the same update twice per week, however, this week, a new validation rule that I created is throwing a validation error. The catch is that it is finding errors where none exist. I navigated to the error records and manually Edited and Saved, and no validation error is being thrown.

Additionally, it is weird b/c I updated 2848 records and the first 2600 threw 0 errors, and the 148 errors all came in the last 248 records updated.

Any idea what could be causing this?

FYI: I de-activated the validation rule and the update ran without errors, however, the validation rule is relatively simple and was only a slight modification to another existing (and functioning) rule, so I'm not sure what's causing the error.

The error-causing rule:

AND( 
  ISPICKVAL( Status__c , 'Ready for Submission'), 
  ISPICKVAL( Investment_Powers__c , '' ) 
)

Another rule that does not cause an error:

AND( 
  ISPICKVAL( Status__c , 'Ready for Submission'), 
  ISPICKVAL( Branch_Code__c ,'') 
)

Additionally, all of the records that caused errors had the status 'Open', so I'm not sure what's going on here.

Thanks in advance!

Attribution to: jackerman09

Possible Suggestion/Solution #1

It sounds like the status__c is getting changed to 'Ready for Submission' in the load. If that is definitely not happening I would change the second part to

ISBLANK(TEXT(Investment_Powers__c))

I have had issues with ISPICKVAL( Investment_Powers__c , '' ) style before.

If these do not work, can you set the debug log and copy the section of when this runs?

Attribution to: Kris Moyse
This content is remixed from stackoverflow or stackexchange. Please visit https://salesforce.stackexchange.com/questions/3473