Re: Problem sending mass notifications (146 Views)
Reply
Frequent Advisor
AlfredoMonasi
Posts: 55
Registered: ‎12-03-2013
Message 1 of 9 (177 Views)
Accepted Solution

Problem sending mass notifications

Hi guys,

 

I'm facing a weird issue when trying to send mass notifications through a loop in a workflow. A client required to send to each responsible of a project a mal with a summary of the projects without any update on the last 10 days or more, so I create a couple temporary tables, one to do the calculations and html detail of each row and one for the summary according the reponsible.

 

The package is called from the workflow and works fine, the problem stars when looping from each record, the steps recover the data from the temporary table and save it to the request with a ksc_store (the body is splitted in many parts to have more than 4000 characters) and the user ids to send are save in other fields.

 

When its time to send the notification I used the settings "Use a user defined token" and specified the token [REQD.TO_EMAIL] which has the value of the user, but every loop the mail is not send but if I specify a user name and declare a user of the system the mail is sent.

 

The field had a text field validation but then I changed to a Autocomplete validation but that didn't work either.

 

Another thing I could realized, it seems if the mail is too big is also not send. Do anyone knows if exists a limitation with this?, the mail could contain more than 40 000 characters.

 

Any help will be appreciated,

 

Regards

 

Alfredo

Please use plain text.
Trusted Contributor
kwood55
Posts: 131
Registered: ‎04-09-2012
Message 2 of 9 (146 Views)

Re: Problem sending mass notifications

You have a token [REQD.TO_EMAIL] thus it is a field in a request type.

- Determine where the field storage is. ParameterX and Visible_Parameterx

- After the email attempt go look at the data. (save the request#)

- Open the workbench and open SQL Runner

  Select * from KCRT_request_details where request_id = request#

- Now verify your data looks as expected it should either be

     User_id#@#User_id... or email_addr#@#emailAddr...

 

- also check notification config-UserDefinedToken recipient type UserID or UserDefinedToken recipient type email address

Please use plain text.
Honored Contributor
Jim Esler
Posts: 712
Registered: ‎05-09-2008
Message 3 of 9 (140 Views)

Re: Problem sending mass notifications

[REQD.TO_EMAIL] is not a valid token name. You must specify whether you want the hidden or visible value for the field. The correct value would be either [REQD.P.TO_EMAIL] or [REQD.VP.TO_EMAIL].

Please use plain text.
Frequent Advisor
AlfredoMonasi
Posts: 55
Registered: ‎12-03-2013
Message 4 of 9 (127 Views)

Re: Problem sending mass notifications

Hi Guys!

 

Where are you looking that I'm using [REQD.TO_EMAIL] instead of using [REQD.P.TO_EMAIL], in the screenshot I send I'm using (and I just checked again) and I'm using [REQD.P.TO_EMAIL] when configurating the notifications or is in another place.

 

Regards

 

Alfredo

Please use plain text.
Honored Contributor
Jim Esler
Posts: 712
Registered: ‎05-09-2008
Message 5 of 9 (119 Views)

Re: Problem sending mass notifications

Our comments were based on your description of your problem: "When its time to send the notification I used the settings "Use a user defined token" and specified the token [REQD.TO_EMAIL]".

 

In looking at your screenshot, I think your problem is that you have checked the box for "Don't send if obsolete". I am not sure what the complete label is in your instance but it starts as "No enviar s...". This option suppresses the notification if it is no longer relevant because the workflow has moved on.

Please use plain text.
Frequent Advisor
AlfredoMonasi
Posts: 55
Registered: ‎12-03-2013
Message 6 of 9 (115 Views)

Re: Problem sending mass notifications

Hi Jim,

 

You were right, after disable the No send if obsolete, notifications were send it again Now I'm facing a second problem, this is a loop, if I set in automatic the steps inside the loop, not all notifications are sent (probably the PPM is busy calculating or sending emails, but if I do it manually each loop all notifications are sent.

 

What do you think could be happening?

 

Regards

 

Alfredo

 

Please use plain text.
Honored Contributor
Jim Esler
Posts: 712
Registered: ‎05-09-2008
Message 7 of 9 (104 Views)

Re: Problem sending mass notifications

My guess at this point is that PPM is looking at only the last instance of execution for the workflow step. Try adding a sleep command to the execution step so it waits at least as long as the cycle time on the notification service.

Please use plain text.
Frequent Advisor
AlfredoMonasi
Posts: 55
Registered: ‎12-03-2013
Message 8 of 9 (98 Views)

Re: Problem sending mass notifications

Is there any ksc command to wait?. Since I'm not the DBA I cant use the DBMS_LOCK package. What I did was an execute to do a while for 15K times before continue :S not a clean solutions but it works

Please use plain text.
Honored Contributor
Jim Esler
Posts: 712
Registered: ‎05-09-2008
Message 9 of 9 (94 Views)

Re: Problem sending mass notifications

We use the following to wait a given number of seconds:

 

ksc_local_exec sleep 45

Please use plain text.
The opinions expressed above are the personal opinions of the authors, not of HP. By using this site, you accept the Terms of Use and Rules of Participation