SQL Query to Log Data into Log Table

You need to set up the triggers in the JSCAPE MFT Server to store the logs in the database (related to the AS2 data transfer) with the help of provided SQL Queries.

Prerequisites

Ensure that:

JSCAPE server v9.0.2.112 is installed and is in the running mode.
You have access credentials for Adeptia Log database and AU_AS2Logs table created in the Log database.
You have all the SQL queries for AS2 log insertion.

Following are the major subsections:

Section Name	Description
Inserting logs for File Uploaded through AS2 on JSCAPE Server	Instructions to insert logs through AS2 on JSCAPE Server.
Inserting Logs for the MDN Receipt Sent on Reception of File	Intructions to insert logs for MDN receipt sent on the reception of the file.
Inserting Logs for the Files Sent to the Trading Partner	Instructions to insert logs for the files sent to the Trading Partner.
Inserting Logs for the MDN Receipt Received on Sending a File	Instructions to insert logs for MDN Receipt received on sending a file.
Defining a Misfire Handling Trigger	Instructions to define a misfire trigger.