Error when using Database Trigger

Error:

java.sql.SQLDataException: data exception: string data, right truncation

This happens every time I trigger the event. If I do activate it and set it to kick off every 30 seconds I still get the above error. One for every DB record it tries to pick up.

The table the DB Event pulls from had two new columns added to it about two weeks ago. The schema we are using does not include the updates though the SQL query is a “SELECT * FROM”.

Cause:

You have added two columns in your table that you have used for DB Event, without updating the activities using that table

Solution:

You have to deactivate the DB event and update all the activities using the same updated table. Then you can reactivate the trigger.