...
- Define the trigger condition and proceed to define trigger action.
Add a trigger action as "SQL Query" and configure the parameters as defined below.
SQL Query Action parameters:
Jdbc url: Provide the jdbc url of the Adeptia Log Database
Username: Username of the Adeptia Log Database
Password: Password for the Adeptia Log database
Use the following QUERY in the SQL Query trigger action:
UPDATE AU_AS2LOG SET AU_ERROR_MESSAGE='%ActionMessage%', AU_STATUS='ERROR' WHERE AU_FILE_NAME='%TriggerErrorMessage%'- After that click on Ok.
- Select the newly created Trigger from Trigger manage page and click on "Apply" to make the new changes into effect.
...