Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0010587 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 01. General setup | major | always | 2009-09-14 19:14 | 2009-09-23 00:00 | |||
Reporter | vmromanos | View Status | public | |||||
Assigned To | rafaroda | |||||||
Priority | normal | Resolution | duplicate | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.6 | |||
OS Version | Ubuntu 8.04 | Database version | 8.3.7 | Ant version | 1.7.0 | |||
Product Version | pi | SCM revision | ||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0010587: Some alerts in sourcedata are wrong | |||||||
Description | The SQL queries of some alerts provided in sourcedata are wrong. As a result, some other well-written alerts are not executed. The wrong alerts I've detected are: 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 I haven't reviewed more, so it's possible that there are more alerts wrong. | |||||||
Steps To Reproduce | Schedule the alert background process for Openbravo Admin and read the error log | |||||||
Proposed Solution | Review all the queries provided with sourcedata and ensure they are working fine | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | ||||||||
|
Notes | |
(0020195) rafaroda (developer) 2009-09-18 12:30 |
"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') |
(0020257) rafaroda (developer) 2009-09-22 10:55 |
This issue will be fixed when fixing 0010687 |
Issue History | |||
Date Modified | Username | Field | Change |
2009-09-14 19:14 | vmromanos | New Issue | |
2009-09-14 19:14 | vmromanos | Assigned To | => rafaroda |
2009-09-18 12:28 | rafaroda | Status | new => scheduled |
2009-09-18 12:30 | rafaroda | Note Added: 0020195 | |
2009-09-22 10:55 | rafaroda | Relationship added | duplicate of 0010687 |
2009-09-22 10:55 | rafaroda | Status | scheduled => closed |
2009-09-22 10:55 | rafaroda | Note Added: 0020257 | |
2009-09-22 10:55 | rafaroda | Duplicate ID | 0 => 10687 |
2009-09-22 10:55 | rafaroda | Resolution | open => duplicate |
2009-09-23 00:00 | anonymous | sf_bug_id | 0 => 2864617 |
Copyright © 2000 - 2009 MantisBT Group |