When using the 'Post Event to Feed' smart service, it fails with the following system alert:
There is a problem with task “Post Event to Feed” in the process “PROCESS_NAME”. An unexpected error prevented adding a feed entry (error: [org.hibernate.exception.DataException: could not insert: [com.appiancorp.tempo.rdbms.EventFeedEntry]]). The event was not sent.
The following error is seen in the server log:
ERROR org.hibernate.util.JDBCExceptionReporter - Data truncation: Data too long for column 'assoc_data' at row 1.
There is a limit imposed by the table definition for the tp_feed_entry table. This limit for the assoc_data column is 4000 characters including any metadata tags added by Appian. To confirm the limit in your Appian version, review the definition of the assoc_data column in the tp_feed_entry table of your Primary Data Source.
tp_feed_entry
assoc_data
Use less characters in the smart service to avoid hitting the limit.
This article applies to all versions of Appian.
Last Reviewed: December 2017