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!