Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0011811
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupminoralways2009-12-17 12:502010-03-10 18:28
ReporternetworkbView Statuspublic 
Assigned Toiperdomo 
PriorityurgentResolutionfixedFixed in Version2.50MP12
StatusclosedFix in branchpiFixed in SCM revision075a157e924f
ProjectionnoneETAnoneTarget Version2.50MP12
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP9SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0011811: Alert recipient does not receive any email when an alert is created

DescriptionWhen an alert rule is created, and one of its alert recipient are configured to receive an email notification, no email is sent.

Steps To ReproduceEnable Alert process. Go to General Management > Process Scheduling > Process Request. Select Alert process, active, run inmediate. Save it and schedule it.
Create a new alert. Go to General Management > Application > Alert.
IE, select c_bankstatement_id as referencekey_id,
       name as record_id,
       0 as ad_role_id,
       null as ad_user_id,
       'Not processed bankstatement: '||name||' with older than 10 days' as description,
       'Y' as isActive,
        ad_org_id,
        ad_client_id,
        now() as created,
        0 as createdBy,
        now() as updated,
        0 as updatedBy
 from c_bankstatement bs.
Go to Alert recipient tab, and select SmalBazaar Admin, and Openbravo Admin. Also check "Send email".
Go to General Setup > Security > User. Fill Email Server Username and Email Server Password.
Go to General Setup > Client > Client > Email configuration.
Please use a real email configuration.

When some alerts were created, check the email, nothing in INBOX.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0023199)
shuehner (administrator)
2010-01-04 20:33

Please verify if all the following fields of the client have been filled with correct and working values for sending email via smtp:

- mail host (smtp servername)
- request email (from address for the mails)
- Request user/Request User Password (smtp login data for sending mails)

In addition the email-adress of the user who receives the alerts needs to be setup-properly.

The fields: emailuser, emailuserpw in the user window are not used by the send mail for alerts process.
(0024385)
hgbot (developer)
2010-02-16 10:08

Repository: erp/devel/pi
Changeset: 49b12b1b1e491f95164dec2babfe953e32375b32
Author: Iván Perdomo <ivan.perdomo <at> openbravo.com>
Date: Tue Feb 16 10:06:58 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/49b12b1b1e491f95164dec2babfe953e32375b32 [^]

Fixes issue 11811: Changed query and logic to get email recipients

---
M src-core/src/org/openbravo/utils/CryptoUtility.java
M src/org/openbravo/erpCommon/ad_process/AlertProcess.java
M src/org/openbravo/erpCommon/ad_process/AlertProcess_data.xsql
---
(0024460)
alostale (manager)
2010-02-17 08:43

It's working fine when setting as alert recipient a role, but in case it is set a single user emails are sent to all users that user's role.

Add to the select in the second union:
and ar.ad_user_id = u.ad_user_id
(0024462)
hgbot (developer)
2010-02-17 09:04

Repository: erp/devel/pi
Changeset: 075a157e924f82540f045b090c50a2d4450d2679
Author: Iván Perdomo <ivan.perdomo <at> openbravo.com>
Date: Wed Feb 17 09:04:48 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/075a157e924f82540f045b090c50a2d4450d2679 [^]

Fixes issue 11811: Changed query get email recipients

---
M src/org/openbravo/erpCommon/ad_process/AlertProcess_data.xsql
---
(0024526)
hudsonbot (developer)
2010-02-18 00:30

A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/49b12b1b1e49 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/7c1b489fb0a0 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16459.obx [^]
(0024551)
hudsonbot (developer)
2010-02-18 00:31

A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/075a157e924f [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/7c1b489fb0a0 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16459.obx [^]

- Issue History
Date Modified Username Field Change
2009-12-17 12:50 networkb New Issue
2009-12-17 12:50 networkb Assigned To => rafaroda
2009-12-30 18:46 psarobe Status new => scheduled
2009-12-30 18:46 psarobe Assigned To rafaroda => iperdomo
2009-12-30 18:46 psarobe fix_in_branch => pi
2009-12-30 18:46 psarobe Priority immediate => urgent
2009-12-30 18:46 psarobe fix_in_branch pi =>
2010-01-04 20:33 shuehner Note Added: 0023199
2010-01-04 20:34 shuehner Issue Monitored: shuehner
2010-02-16 10:08 hgbot Checkin
2010-02-16 10:08 hgbot Note Added: 0024385
2010-02-16 10:08 hgbot Status scheduled => resolved
2010-02-16 10:08 hgbot Resolution open => fixed
2010-02-16 10:08 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/49b12b1b1e491f95164dec2babfe953e32375b32 [^]
2010-02-17 08:43 alostale Note Added: 0024460
2010-02-17 08:43 alostale Status resolved => new
2010-02-17 08:43 alostale Resolution fixed => open
2010-02-17 09:01 iperdomo Status new => scheduled
2010-02-17 09:01 iperdomo fix_in_branch => pi
2010-02-17 09:04 hgbot Checkin
2010-02-17 09:04 hgbot Note Added: 0024462
2010-02-17 09:04 hgbot Status scheduled => resolved
2010-02-17 09:04 hgbot Resolution open => fixed
2010-02-17 09:04 hgbot Fixed in SCM revision http://code.openbravo.com/erp/devel/pi/rev/49b12b1b1e491f95164dec2babfe953e32375b32 [^] => http://code.openbravo.com/erp/devel/pi/rev/075a157e924f82540f045b090c50a2d4450d2679 [^]
2010-02-17 09:23 alostale Status resolved => closed
2010-02-17 09:23 alostale Fixed in Version => 2.50MP12
2010-02-18 00:00 anonymous sf_bug_id 0 =>
2010-02-18 00:30 hudsonbot Checkin
2010-02-18 00:30 hudsonbot Note Added: 0024526
2010-02-18 00:31 hudsonbot Checkin
2010-02-18 00:31 hudsonbot Note Added: 0024551
2010-03-10 18:28 anonymous sf_bug_id => 2967964


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker