I am trying to activate a database event but receiving an error. It seems that the version of MySQL doesn't yet support the multiple triggers with same action time and event.
Error in activating Database Event "UpdateSendEvent_DatabaseEvent";com.adeptia.indigo.services.ServiceException: Error in EventScheduler service : Error while creating database trigger job : Error in creating trigger for database Event service This version of MySQL doesn't yet support 'multiple triggers with the same action time and event for one table'
Here is the SQL trigger
DBTrigger_214 UPDATE au_groupdata BEGIN IF (new.DISPLAYSTATUS = 'SENT' and old.FLOWTYPE = 'OUTBOUND' and old.GS01 = 'AD' and old.PARTNERNAME = 'Adeptia') THEN INSERT INTO dbeventtriggertable(ID,STATUS) VALUES ( '123487687871234',concat('Query = WHERE ID =',''',new.ID,''' )); END IF; END
This error is thrown by the MySQL database when a similar database trigger already exists within the database.
1) Identify triggers that already exist on the table
SHOW TRIGGERS WHERE `table` = 'au_groupdata'
2) If the existing trigger matches the one that is in the Database Event, drop the existing trigger from the table
DROP TRIGGER DBTrigger_214;
Note: If you'd like to backup the trigger before dropping it, you can run this statement
SHOW CREATE TRIGGER DBTrigger_214;
Then save the resulting script.
3) Activate the Database Event within Adeptia