Database Event Error

Error:

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

 

Cause:

This error is thrown by the MySQL database when a similar database trigger already exists within the database.

 

Solution:

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

Have more questions? Submit a request

0 Comments

Article is closed for comments.