Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0018682Openbravo ERP01. General setuppublic2011-10-04 09:362011-10-25 12:31
Reporterjecharri 
Assigned Toegoitz 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target Version3.0MP5Fixed in Version3.0MP5 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0018682: The trigger asociated to alert creation is not working properly
DescriptionIf you create an alert, automatically System Role is added to alert recipient.
And you can not delete it.
Steps To ReproduceCreate an alert and go to tab alert recipient.
Proposed SolutionChange the trigger AD_ALERTRULE_TRG.xml
Line:

--insert permissions
      FOR Cur_Role in (SELECT DISTINCT AD_Role_ID, AD_CLIENT_ID, AD_ORG_ID
      FROM AD_Role
      WHERE isManual='N') loop
Additional Information
TagsNo tags attached.
Relationships
depends on backport 00186832.50MP35 closed egoitz The trigger asociated to alert creation is not working properly 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-10-04 09:36jecharriNew Issue
2011-10-04 09:36jecharriAssigned To => jonalegriaesarte
2011-10-04 09:36jecharriWeb browser => Google Chrome
2011-10-04 09:36jecharriModules => Core
2011-10-04 09:36jecharriResolution time => 1320447600
2011-10-04 09:36jecharriStatusnew => scheduled
2011-10-04 09:36jecharrifix_in_branch => pi
2011-10-04 10:52jecharriNote Added: 0041481
2011-10-19 09:14jonalegriaesarteAssigned Tojonalegriaesarte => egoitz
2011-10-20 11:41hgbotCheckin
2011-10-20 11:41hgbotNote Added: 0041949
2011-10-20 11:41hgbotStatusscheduled => resolved
2011-10-20 11:41hgbotResolutionopen => fixed
2011-10-20 11:41hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3a6f19206961b8ef4908a8604656f62da178759b [^]
2011-10-23 13:42hudsonbotCheckin
2011-10-23 13:42hudsonbotNote Added: 0042027
2011-10-25 12:31jecharriNote Added: 0042092
2011-10-25 12:31jecharriStatusresolved => closed
2011-10-25 12:31jecharriFixed in Version => 3.0MP5

Notes
(0041481)
jecharri   
2011-10-04 10:52   
If you execute the next sql in your database you will delete all alertrecipient with bad roles asociated:

DELETE FROM ad_alertrecipient WHERE ad_alertrecipient_id in (SELECT ad_alertrecipient_id
FROM ad_alertrecipient aa INNER JOIN ad_alertrule ar ON aa.ad_alertrule_id=ar.ad_alertrule_id
WHERE aa.ad_client_id <> ar.ad_client_id)
(0041949)
hgbot   
2011-10-20 11:41   
Repository: erp/devel/pi
Changeset: 3a6f19206961b8ef4908a8604656f62da178759b
Author: Jon Alegría <jon.alegria <at> openbravo.com>
Date: Thu Oct 20 11:40:23 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/3a6f19206961b8ef4908a8604656f62da178759b [^]

Fixes issue 0018682: The trigger asociated to alert creation is not working
properly

---
M src-db/database/model/triggers/AD_ALERTRULE_TRG.xml
---
(0042027)
hudsonbot   
2011-10-23 13:42   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/35bf0a7aa166 [^]

Maturity status: Test
(0042092)
jecharri   
2011-10-25 12:31   
Verified