Defining a Misfire Handling Trigger

You can create a trigger in JSCAPE Server that can handle the misfire events. It can also be used to log the information of the files sent to the Trading Partner that are failed due to some exception. To configure misfire handling event:

1. Create a new trigger with Event type selected as "TriggerError".
   
   
   
   
2. Click Next and move forward to define the trigger action.

3. On the Trigger Action window, click Add.

4. Select the Trigger Action as "SQL Query" and click OK.

   
   

    

5. Define the SQL Query parameters and click OK.

   Parameter Name	Description
   Jdbcurl	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%'

6. Select the newly created trigger and click OK.