Openbravo Issue Tracking System - Openbravo ERP | ||||||||||||
View Issue Details | ||||||||||||
ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
0010587 | Openbravo ERP | 01. General setup | public | 2009-09-14 19:14 | 2009-09-23 00:00 | |||||||
Reporter | vmromanos | |||||||||||
Assigned To | rafaroda | |||||||||||
Priority | normal | Severity | major | Reproducibility | always | |||||||
Status | closed | Resolution | duplicate | |||||||||
Platform | OS | 20 | OS Version | Ubuntu 8.04 | ||||||||
Product Version | pi | |||||||||||
Target Version | Fixed in Version | |||||||||||
Merge Request Status | ||||||||||||
Review Assigned To | ||||||||||||
OBNetwork customer | ||||||||||||
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 | |||||||||||
Additional Information | ||||||||||||
Tags | No tags attached. | |||||||||||
Relationships |
| |||||||||||
Attached Files | ||||||||||||
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 |
Notes | |||||
|
|||||
|
|
||||
|
|||||
|
|