Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010587Openbravo ERP01. General setuppublic2009-09-14 19:142009-09-23 00:00
Reportervmromanos 
Assigned Torafaroda 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionduplicate 
PlatformOS20OS VersionUbuntu 8.04
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0010587: Some alerts in sourcedata are wrong
DescriptionThe 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 ReproduceSchedule the alert background process for Openbravo Admin and read the error log
Proposed SolutionReview all the queries provided with sourcedata and ensure they are working fine
Additional Information
TagsNo tags attached.
Relationships
duplicate of defect 00106872.50MP8 closed rafaroda Some alerts are wrong defined 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-09-14 19:14vmromanosNew Issue
2009-09-14 19:14vmromanosAssigned To => rafaroda
2009-09-14 19:14vmromanosOBNetwork customer => No
2009-09-18 12:28rafarodaStatusnew => scheduled
2009-09-18 12:30rafarodaNote Added: 0020195
2009-09-22 10:55rafarodaRelationship addedduplicate of 0010687
2009-09-22 10:55rafarodaStatusscheduled => closed
2009-09-22 10:55rafarodaNote Added: 0020257
2009-09-22 10:55rafarodaDuplicate ID0 => 10687
2009-09-22 10:55rafarodaResolutionopen => duplicate
2009-09-23 00:00anonymoussf_bug_id0 => 2864617

Notes
(0020195)
rafaroda   
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   
2009-09-22 10:55   
This issue will be fixed when fixing 0010687