Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
BedrockMission!

Learn More

View all

Sign in to view all badges

Delivery is not working for a new installation

Avatar

Avatar
Validate 1
Level 2
Aalokitoaami
Level 2

Likes

14 likes

Total Posts

29 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
Aalokitoaami
Level 2

Likes

14 likes

Total Posts

29 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
Aalokitoaami
Level 2

02-06-2019

I am setting up a new environment and having issues with delivery. None of the delivery is completing

When an workflow is creating a delivery, the bulk external delivery (new routing using Delivery Mode = External) or email delivery (using OTB routing for email) is coming as “In preparation(target ready)” with Pending Approval as expected. Then once it is approved the status is changed to “Extraction Pending” for External delivery and for Email Delivery, it is initially “To Approve” and then once approved, it is getting into “Preparation pending” state.

In the Target tab of  Delivery, I can see 2 recipient records are sitting with Reason = "not defined". In the delivery audit, the last log is "06/02/2019 6:22:05 PM Analysis successfully completed in 0s (2 message(s) waiting)."

No error in web, mta or any other log file. So not sure what is happening.

No data is inserted into the BroadlogRcp table either. I used few proofs, and I can see them in the broadlog table, but nothing from the actual delivery.

Any help is greatly appreciated.

Thanks!!

Replies

Avatar

Avatar
Establish
MVP
wodnicki
MVP

Likes

960 likes

Total Posts

1,090 posts

Correct Reply

508 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile

Avatar
Establish
MVP
wodnicki
MVP

Likes

960 likes

Total Posts

1,090 posts

Correct Reply

508 solutions
Top badges earned
Establish
Affirm 500
Contributor
Shape 1
Give Back 100
View profile
wodnicki
MVP

12-06-2019

Hi,

Enable the mta process in the instance configuration by setting <mta autostart="true"/>, then restart the nlserver6 service.

Thanks,

-Jon

Avatar

Avatar
Give Back 5
Level 4
aneeta45259594
Level 4

Likes

46 likes

Total Posts

67 posts

Correct Reply

27 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 10
Give Back
Boost 5
View profile

Avatar
Give Back 5
Level 4
aneeta45259594
Level 4

Likes

46 likes

Total Posts

67 posts

Correct Reply

27 solutions
Top badges earned
Give Back 5
Give Back 3
Give Back 10
Give Back
Boost 5
View profile
aneeta45259594
Level 4

13-06-2019

Aalokitoaami

Can you please confirm that you've configured the relay settings in the configuration files and that the mta and stat server is turned on ?

It appears that the analysis is complete, which means the web module is turned on but it's not able to forward the content to mta to send it out. You can monitor logs under <campaign install directory>/var/default/log/web.log and watchdog.log.

Best Regards,

Aneet

Avatar

Avatar
Validate 1
Level 2
Aalokitoaami
Level 2

Likes

14 likes

Total Posts

29 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
Aalokitoaami
Level 2

Likes

14 likes

Total Posts

29 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
Aalokitoaami
Level 2

24-06-2019

I have the mta and stats running.

1778861_pastedImage_0.png

This is my config file

1778862_pastedImage_1.png

Also note that the delivery with external type where it is supposed to create a file, not an actual email delivery, is also not working. Not sure what is happening.

Avatar

Avatar
Validate 1
Level 2
Aalokitoaami
Level 2

Likes

14 likes

Total Posts

29 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile

Avatar
Validate 1
Level 2
Aalokitoaami
Level 2

Likes

14 likes

Total Posts

29 posts

Correct Reply

3 solutions
Top badges earned
Validate 1
Boost 5
Boost 3
Boost 10
Boost 1
View profile
Aalokitoaami
Level 2

24-06-2019

I was doing some more research and captured the query that the MTA is periodically running to get the data.

One of the critical part of the SQL is the iState IN (51,55,61,62,71,81)  If I compare these integer with the deliveryState enum the values are as (Start Pending, In Process, Retry Pending, Retry In Process, Pause Requested, Stop Requested). None of these values look promising from the point of view of my error. I checked the DB and the status of the deliveries in stuck stage is 15 (Target Ready)

SELECT iDeliveryId, iState, sLabel, iPriority, tsBroadStart, tsValidity, iDeliveryMode,sIPAffinity

FROM NmsDelivery

WHERE iDeliveryMode=1

AND iState IN (51,55,61,62,71,81)

AND iDeleteStatus=0 AND iIsModel=0 AND sIPAffinity IN ('default')

AND

(

iState IN (55,62,71,81)

OR (iState = 61 AND (tsNextPass IS NULL OR tsNextPass <= SYSDATETIMEOFFSET()))

OR (iState = 51 AND (tsContact IS NULL OR tsContact <= SYSDATETIMEOFFSET()))

) ORDER BY iState