2022
Value too long for type character varying(100)
Issue :
If picklist has the value more than 100 characters in the salesforce then DB does not allow you to insert the record. As in database picklist fields will be created as character varying(100) in database.It will not accept more than 100 characters.
Error in the tomcat/logs:
NULL,NULL,NULL,'0055w00000AjV5a','00Q5w00001mRS5dEAG',NULL,NULL,NULL,NULL,NULL,NULL,NULL) was aborted: ERROR: value too long for type character varying(100) Call getNextException to see other errors in the batch.
Solution:
In order to troubleshoot this issue please follow the below steps:
and uncomment picklist.default and set to varchar(765)