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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0018682
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupmajoralways2011-10-04 09:362011-10-25 12:31
ReporterjecharriView Statuspublic 
Assigned Toegoitz 
PriorityurgentResolutionfixedFixed in Version3.0MP5
StatusclosedFix in branchpiFixed in SCM revision3a6f19206961
ProjectionnoneETAnoneTarget Version3.0MP5
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browserGoogle Chrome
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0018682: 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
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 00186832.50MP35 closedegoitz The trigger asociated to alert creation is not working properly 

-  Notes
(0041481)
jecharri (developer)
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 (developer)
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 (developer)
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 (developer)
2011-10-25 12:31

 Verified

- Issue History
Date Modified Username Field Change
2011-10-04 09:36 jecharri New Issue
2011-10-04 09:36 jecharri Assigned To => jonalegriaesarte
2011-10-04 09:36 jecharri Web browser => Google Chrome
2011-10-04 09:36 jecharri Modules => Core
2011-10-04 09:36 jecharri Resolution time => 1320447600
2011-10-04 09:36 jecharri Status new => scheduled
2011-10-04 09:36 jecharri fix_in_branch => pi
2011-10-04 10:52 jecharri Note Added: 0041481
2011-10-19 09:14 jonalegriaesarte Assigned To jonalegriaesarte => egoitz
2011-10-20 11:41 hgbot Checkin
2011-10-20 11:41 hgbot Note Added: 0041949
2011-10-20 11:41 hgbot Status scheduled => resolved
2011-10-20 11:41 hgbot Resolution open => fixed
2011-10-20 11:41 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3a6f19206961b8ef4908a8604656f62da178759b [^]
2011-10-23 13:42 hudsonbot Checkin
2011-10-23 13:42 hudsonbot Note Added: 0042027
2011-10-25 12:31 jecharri Note Added: 0042092
2011-10-25 12:31 jecharri Status resolved => closed
2011-10-25 12:31 jecharri Fixed in Version => 3.0MP5

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker