Skip to main content
Level 2
Jun 10, 2020 12:32 PM UTC
Solved

Failure Reasons and Import Workflow

Hi,

Basically, I had two questions, since I am integrating my MTA server with adobe, upon delivery I need to trace back the stats back to adobe for reporting.

 

1. With resp to failure reasons, like mail box full, not connected, refused, unreachable, what table should I refer to insert the values? Would it be directly 'nmsdeliverylogstats'? Any other tables I need to take care?
Because the delivery success / failures I am inserting in 'nmsbroadlogrcp' table and they auto populate in 'nmsdeliverylogstats'.

 

2. Is it possible to import / create work-flow in a way to insert the entries in above 2-3 tables at the same time? Currently, my work-flow just inserts entries into 'nmsbroadlogrcp'. Any reference for example?

This post is no longer active and is closed to new replies. Need help? Start a new post to ask your question.
isahore
isahoreAccepted solution
Community Advisor
Jun 10, 2020 6:56 PM UTC

Hi @rohanpat-1 ,

You need to update the failure reasons in the nms:broadLogMsg schema, linked to the nms:broadLogRcp schema with msg-id field. Below screenshot should help.

 For your second question, the answer is yes. How exactly are you receiving the response from the custom MTA? API, files, or something else. Based on that you can build a mechanism to update all tables with proper linked items.

Cheers.

8 replies

isahore
Community Advisor
isahoreCommunity AdvisorAccepted solution
Community Advisor
Jun 10, 2020 6:56 PM UTC

Hi @rohanpat-1 ,

You need to update the failure reasons in the nms:broadLogMsg schema, linked to the nms:broadLogRcp schema with msg-id field. Below screenshot should help.

 For your second question, the answer is yes. How exactly are you receiving the response from the custom MTA? API, files, or something else. Based on that you can build a mechanism to update all tables with proper linked items.

Cheers.

Translate
Level 2
Jun 11, 2020 2:30 AM UTC
Hi @isahore, Thanks, will check out the first solution with resp to table. For import, the custom MTA is dumping the data in text files, which I map to corresponding fields in adobe for insertion in broadlogrcp table. But I didn't find a way or option to have import / insertions in multiple table at the same time. Could you please let me know the steps or attach a snap pic for better understanding.
Translate
Venu_Reddy
Level 6
Jun 11, 2020 1:13 PM UTC

Hi @rohanpat-1 ,

 

For the first question, the failure reasons will save automatically into Non Deliverable management (Location as Adminstration -- Campaign Management -- non deliverables and addresses).

 

You can find all the results here and hope it helps you.

Translate