Summary

JIRA issue event add event fails when JQL exceeds the character limit.

Steps to Reproduce

1. Create several custom fields and apply them to the project.
2. Create issues.
3. Install Team Calendar in Confluence.
4. Add event JIRA issue dates event in your calendar and include several custom fields.

Expected Results

The event is added without failure.

Actual Results

The event fails to add if the JQL along with custom field names exceeds 255 characters

0 Caused by: java.sql.BatchUpdateException: Batch entry 0 INSERT INTO "AO_950DC3_TC_JIRA_REMI_EVENTS" ("KEY_ID", "SUB_CALENDAR_ID", "USER_ID", "JQL", "TICKET_ID", "ASSIGNEE", "STATUS", "TITLE", "DESCRIPTION", "EVENT_TYPE", "UTC_START", "UTC_END", "ALL_DAY", "ISSUE_LINK", "ISSUE_ICON_URL") VALUES 
caused by:
2017-04-18 13:28:42.265376500 org.postgresql.util.PSQLException: ERROR: value too long for type character varying(255)

Notes

JQL is limited to 255 Characters (AO_950DC3_TC_JIRA_REMI_EVENTS") for Jira Issue Events for Team Calendar. Checking a few custom fields can end up hitting the limit along with the syntax i.e. Project and custom-field=date ect.

Workaround

Create several JIRA issue events on the same calendar to divide the JQL so it doesn't exceed 255 characters.