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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0010687
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 01. General setupminoralways2009-09-22 10:342009-10-23 00:00
ReporternetworkbView Statuspublic 
Assigned Torafaroda 
PriorityhighResolutionfixedFixed in Version2.50MP7
StatusclosedFix in branchFixed in SCM revision4b516ef751ac
ProjectionnoneETAnoneTarget Version2.50MP8
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP5SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010687: Some alerts are wrong defined

DescriptionSome alerts defined in the application does not work. Some of them do not work just in Postgre, and other ones, in both databases.

Here, you are the ones that do not work in both databases (AD_Alertrule_ID):
*1000018,1000020, FDA0D6B303CD4F289A04FA41844C4B0C

And this ones, do not work just in Postgre:
*800003, 1000007, 1000021, 1000022
Steps To ReproduceConnect directly with the database and execute:

select * from ad_alertrule

Obtain "SQL" column from the query, taking into account only the AD_Alertrule_ID provided above.

Try to execute the query. Different errors will appear.
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
has duplicate defect 0010587 closedrafaroda Some alerts in sourcedata are wrong 

-  Notes
(0020256)
rafaroda (developer)
2009-09-22 10:53

 More wrong alerts:
1- "Columns with search reference and reference value null". It is necessary to change: WHERE AD_REFERENCE_ID = 30 by WHERE AD_REFERENCE_ID = '30'
2- "Process Execution Failed". The view ad_process_run_v doesn't exist
3- "Vendor or Customer BPs without Bill To address" SQL is wrong, replace it by:

select c_bpartner_id as referencekey_id,
       name as record_id,
       0 as ad_role_id,
       null as ad_user_id,
       name ||'has not bill to address' 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_bpartner bp
where (isvendor='Y' or iscustomer='Y')
and not exists (select 1
                  from c_bpartner_location l
                where l.c_bpartner_id = bp.c_bpartner_id
                and isbillto='Y')
(0020292)
rafaroda (developer)
2009-09-23 07:49

 A collateral issue related is that, if any of these wrong alerts is active, it will break the alert background process.
(0020619)
hgbot (developer)
2009-10-01 10:12

 Repository: erp/devel/pi
Changeset: 4b516ef751acabdda4f3dc8bfecda7d0966ae7b7
Author: Jeneive Malar Kodi <jeneive.malarkodi <at> openbravo.com>
Date: Thu Oct 01 13:41:13 2009 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/4b516ef751acabdda4f3dc8bfecda7d0966ae7b7 [^]

Fixed Issue 10687: Some alerts are wrong defined

---
M src-db/database/sourcedata/referencedData/AD_ALERTRULE.xml
---
(0020623)
jeneivemalarkodi (reporter)
2009-10-01 11:28

 * Nine alert quries are modified out of 20 records in OB

Test Cases:

1. Enable all alerts in OB (General Setup -> Application -> Alert)
2. Ensure that all alerts have 'Alert Recipient' Entry
3. Create new process request(General Setup -> Process Scheduling -> Process Request)
4. Can view alerts in 'Alert Management' (General Setup -> Application -> Alert management)
5. Have to test in both the databases
(0021308)
arunkumar (reporter)
2009-10-22 09:25

 Tested & Working fine.

- Issue History
Date Modified Username Field Change
2009-09-22 10:34 networkb New Issue
2009-09-22 10:34 networkb Assigned To => rafaroda
2009-09-22 10:34 networkb version => 2.50MP5
2009-09-22 10:53 rafaroda Note Added: 0020256
2009-09-22 10:53 rafaroda Priority immediate => high
2009-09-22 10:53 rafaroda Status new => scheduled
2009-09-22 10:55 rafaroda Relationship added has duplicate 0010587
2009-09-22 15:14 galderromo Issue Monitored: galderromo
2009-09-23 07:49 rafaroda Note Added: 0020292
2009-10-01 10:12 hgbot Checkin
2009-10-01 10:12 hgbot Note Added: 0020619
2009-10-01 10:12 hgbot Status scheduled => resolved
2009-10-01 10:12 hgbot Resolution open => fixed
2009-10-01 10:12 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4b516ef751acabdda4f3dc8bfecda7d0966ae7b7 [^]
2009-10-01 11:28 jeneivemalarkodi Note Added: 0020623
2009-10-22 09:25 arunkumar Status resolved => closed
2009-10-22 09:25 arunkumar Note Added: 0021308
2009-10-22 09:25 arunkumar Fixed in Version => 2.50MP7
2009-10-23 00:00 anonymous sf_bug_id 0 => 2884249

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker