Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0011811 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 01. General setup | minor | always | 2009-12-17 12:50 | 2010-03-10 18:28 | |||
Reporter | networkb | View Status | public | |||||
Assigned To | iperdomo | |||||||
Priority | urgent | Resolution | fixed | Fixed in Version | 2.50MP12 | |||
Status | closed | Fix in branch | pi | Fixed in SCM revision | 075a157e924f | |||
Projection | none | ETA | none | Target Version | 2.50MP12 | |||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | 2.50MP9 | SCM revision | ||||||
Merge Request Status | ||||||||
Review Assigned To | ||||||||
OBNetwork customer | OBPS | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0011811: Alert recipient does not receive any email when an alert is created | |||||||
Description | When an alert rule is created, and one of its alert recipient are configured to receive an email notification, no email is sent. | |||||||
Steps To Reproduce | Enable 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. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
![]() |
|
![]() |
|
(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 (viewer) 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 (viewer) 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 (viewer) 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 [^] |
![]() |
|||
Date Modified | Username | Field | Change |
2009-12-17 12:50 | networkb | New Issue | |
2009-12-17 12:50 | networkb | Assigned To | => rafaroda |
2009-12-17 12:50 | networkb | OBNetwork customer | => Yes |
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 |