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:
Issue/Error:

 

Row size too large. The maximum row size for the used table type, not counting BLOBs, is 65535. You have to change some columns to TEXT or BLOBs

 

 

Solution:

 

To replicate data to a single table with a lot of varchar fields please follow the steps so as to create a table with varchar fields converted to text type. We need to drop the existing table and then recreate just the schema using 'Update schema' command, before this follow the steps mentioned below:

 

Instead of having a lot of varchar fields, you can simply convert them to text type so you can fit in a lot more fields, do the following.

1. Edit the system.properties file located at <<install-dir>>\dbsync-cdm\WEB-INF\db\conf and set the property

...

alter.

...

schema.size value to false and alter.schema.override to true.

2. Edit the file mysql.properties file and add a property varchar.default=text

3. Restart the tomcat and then drop the table if it is already existing in the database.

4. Run

...

update schema to create the table, do not run Cleancopy or incremental sync as data sync will lead to an error.

5. After the schema is created in MySQL then stop the tomcat, revert the above changes meaning reset the property value and then start the tomcat again.

6. Now run incremental or Cleancopy to download the data.