If you try to bulk update the pipeline of an opportunity or a problem, the pipeline that you are updating this to needs to contain the status that is currently set on all the records. If one of the statuses set on the records is not in the pipeline you are trying to update to it will cause the bulk update to fail with this error.
No primary key value for foreign key 'lead_pipeline_status' in table 'lead'
When updating the pipeline on an individual record, it will do one of two things. If the pipeline that it is changing to contains the same status, the status will be kept and the pipeline updated. If the status does not exist in the pipeline, you are updating to it will just set the status to be the first status in that pipeline. When bulk updating the pipeline we should follow this same process.
