Inserting Logs for the MDN Receipt Sent on Reception of File
Whenever a file is uploaded to your JSCAPE server it automatically sends an MDN receipt of that file to the Trading Partner that uploaded the file to your server. To insert the logs of the MDN receipts:
-
Create a trigger in the JSCAPE Server with Event Type selected as "AS2 Receipt Sent".
-
Click Next and move forward to define the trigger action.
-
On the Trigger Action window, click Add.
-
Select the Trigger Action as "SQL Query" and click OK.
-
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:
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 SENT',
unix_timestamp('%Year%%Month%%DayOfMonth% %Hour%:%Minute%:%Second%')*1000+%Millisecond%) -
Select the newly created trigger and click OK.