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 | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| 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 ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0020195) rafaroda (viewer) 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 (viewer) 2009-09-22 10:55 |
This issue will be fixed when fixing 0010687 |
|
Notes |
|
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-14 19:14 | vmromanos | OBNetwork customer | => No |
| 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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |