KB-1440 Post Event to Feed smart service errors out with unexpected error

Symptoms

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.

Cause

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.

Action

Use less characters in the smart service to avoid hitting the limit.

Affected Versions

This article applies to all versions of Appian.

Last Reviewed: December 2017

Related
Recommended