TL;DR: Trying to bulk update one field in Account but being told Id is of incorrect type. Have checked and am positive it is of the correct type.
I am trying to perform an Account bulk update with dataloader. Each file is 500,000 records.
This update is to modify a single new field. The CSV is structed as such:
001XXXXXXXXXXXXXXX, 'New Value'
The update keeps failing with the following error message:
Account ID: id value of incorrect type: 001XXXXXXXXXXXXXXX
This seems straight forward enough but I can say with 100% confidence that the ID is correct. For each failure, I did a SOQL query to check the existence of the Id and all have returned. The Ids were exported with Dataloader before I began trying to update this field. The only thing I can think of is that a lot of these will be Person Account records but there is no SF docs saying this is a problem and Dataloader does not offer an option to update by Person Account.
The field being updated is a simple string field; no look ups or formulas involved. It is the same string in all cases and only six characters long. And the primary SF Id is being used, no external Ids.
Has anyone else encountered this problem?