Skip to main content
Version: Adeptia Suite

Inserting Logs for the MDN Receipt Received on Sending a File

You can log the MDN Receipt details into the log database for all the files sent to the Trading Partners through AS2 protocol. To log MDN receipt details:

  1. Create a trigger with Event Type selected as "AS2 Receipt Received".

  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
    JdbcurlProvide the jdbc url of the Adeptia log database. 
    UsernameUsername of the Adeptia log database. 
    PasswordPassword for the Adeptia log database.

    Use the following QUERY in the SQL Query trigger action:

    INSERT INTO AU_AS2LOG( AU_AS2_FROM, AU_AS2_TO, AU_CLIENT_HOST, AU_CLIENT_PORT,
    AU_DISPOSITION_ACTION, AU_DISPOSITION_SENDING_MODE, AU_DISPOSITION_TYPE,
    AU_DOMAIN_NAME, AU_ORIGINAL_MESSAGEID, AU_RECEIPT_MESSAGEID, AU_TYPE, AU_TIMESTAMP)
    VALUES('%As2From%', '%As2To%', '%ClientHost%', '%ClientPort%', '%DispositionActionMode%',
    '%DispositionSendingMode%', '%DispositionType%', '%DomainName%', '%OriginalMessageId%',
    '%ReceiptId%', 'RECEIPT RECEIVED', unix_timestamp('%Year%-%Month%-%DayOfMonth% %Hour%:%Minute%:%Second%')*1000+%Millisecond%)

  6. Select the newly created trigger and click OK.