Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Value too long for type character varying(500)
Issue :
If the Formula field has the value more than 500 characters in the salesforce then DB does not allow you to insert the record. As in database Formula fields will be created as character varying(500) in database.It will not accept more than 500 characters.

Error in the tomcat/logs:
src="https://app.marketo.com/images/icons16/marketo16.png" alt="View in Marketo" border="0"/></a>',NULL,NULL,NULL,'0055w00000AjV5a','00Q5w00001ngoq7EAA',NULL,NULL,NULL,NULL,NULL,NULL,NULL) was aborted: ERROR: value too long for type character varying(500) Call getNextException to see other errors in the batch.


Solution:
In order to troubleshoot this issue please follow the below steps:

  1. Edit the system.properties file located at <<install-dir>>\dbsync-cdm\WEB-INF\db\conf and set the property <<Database>>.FORMULA.DATATYPE=varchar(4900)
  2. Restart the tomcat and then drop the table if it is already existing in the database.
  3. Run the update schema and incremental or run the clean copy.