Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011811Openbravo ERP01. General setuppublic2009-12-17 12:502010-03-10 18:28
Reporternetworkb 
Assigned Toiperdomo 
PriorityurgentSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version2.50MP9 
Target Version2.50MP12Fixed in Version2.50MP12 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0011811: 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.
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-12-17 12:50networkbNew Issue
2009-12-17 12:50networkbAssigned To => rafaroda
2009-12-17 12:50networkbOBNetwork customer => Yes
2009-12-30 18:46psarobeStatusnew => scheduled
2009-12-30 18:46psarobeAssigned Torafaroda => iperdomo
2009-12-30 18:46psarobefix_in_branch => pi
2009-12-30 18:46psarobePriorityimmediate => urgent
2009-12-30 18:46psarobefix_in_branchpi =>
2010-01-04 20:33shuehnerNote Added: 0023199
2010-01-04 20:34shuehnerIssue Monitored: shuehner
2010-02-16 10:08hgbotCheckin
2010-02-16 10:08hgbotNote Added: 0024385
2010-02-16 10:08hgbotStatusscheduled => resolved
2010-02-16 10:08hgbotResolutionopen => fixed
2010-02-16 10:08hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/49b12b1b1e491f95164dec2babfe953e32375b32 [^]
2010-02-17 08:43alostaleNote Added: 0024460
2010-02-17 08:43alostaleStatusresolved => new
2010-02-17 08:43alostaleResolutionfixed => open
2010-02-17 09:01iperdomoStatusnew => scheduled
2010-02-17 09:01iperdomofix_in_branch => pi
2010-02-17 09:04hgbotCheckin
2010-02-17 09:04hgbotNote Added: 0024462
2010-02-17 09:04hgbotStatusscheduled => resolved
2010-02-17 09:04hgbotResolutionopen => fixed
2010-02-17 09:04hgbotFixed in SCM revisionhttp://code.openbravo.com/erp/devel/pi/rev/49b12b1b1e491f95164dec2babfe953e32375b32 [^] => http://code.openbravo.com/erp/devel/pi/rev/075a157e924f82540f045b090c50a2d4450d2679 [^]
2010-02-17 09:23alostaleStatusresolved => closed
2010-02-17 09:23alostaleFixed in Version => 2.50MP12
2010-02-18 00:00anonymoussf_bug_id0 =>
2010-02-18 00:30hudsonbotCheckin
2010-02-18 00:30hudsonbotNote Added: 0024526
2010-02-18 00:31hudsonbotCheckin
2010-02-18 00:31hudsonbotNote Added: 0024551
2010-03-10 18:28anonymoussf_bug_id => 2967964

Notes
(0023199)
shuehner   
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   
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   
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   
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   
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   
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 [^]