Error when using Database Trigger


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”.



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



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

Have more questions? Submit a request


Article is closed for comments.