Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017159Openbravo ERP00. Application dictionarypublic2011-05-13 12:302022-02-01 08:08
ReporterXpand-IT 
Assigned ToTriage Platform Base 
PrioritynormalSeverityminorReproducibilityalways
StatusacknowledgedResolutionopen 
PlatformOS5OS Version
Product Version2.50MP24 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017159: AD_Alert bug in alert Definition
DescriptionA NullPointer Exception is return when trying to navigate to the alerts shortcut from the vertical Menu
Steps To ReproduceDefine a new Alert.

SQL:
select o.c_order_id as referencekey_id,
       o.documentno as record_id,
       0 as ad_role_id,
       salesrep_id as ad_user_id,
       null as m_warehouse_id,
       o.documentno || ' should be completed in less than 1 day.' as description,
       'Y' as isActive,
        o.ad_org_id,
        o.ad_client_id,
        now() as created,
        0 as createdBy,
        now() as updated,
        0 as updatedBy
  from c_order o
where o.docstatus = 'DR'
and o.datepromised < now()

Filter Clause: ad_user_id = @ad_user_id@

Error (from log): ERROR: column reference "ad_user_id" is ambiguous
Proposed SolutionWorkaround: Filter clause should be ad_alert.ad_user_id = @ad_user_id@
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-05-13 12:30Xpand-ITNew Issue
2011-05-13 12:30Xpand-ITAssigned To => alostale
2011-05-13 12:30Xpand-ITModules => Core
2011-05-16 08:55alostaleStatusnew => scheduled
2011-05-16 08:55alostalefix_in_branch => pi
2012-03-15 12:49alostaleNote Added: 0046453
2012-03-15 12:49alostaleTypedefect => design defect
2012-03-15 12:49alostalefix_in_branchpi =>
2012-09-24 21:19AugustoMauchNote Added: 0052446
2012-09-24 21:19AugustoMauchPrioritylow => normal
2017-03-31 14:36alostaleStatusscheduled => acknowledged
2017-04-10 14:34alostaleAssigned Toalostale => platform
2022-02-01 08:08alostaleAssigned Toplatform => Triage Platform Base

Notes
(0046453)
alostale   
2012-03-15 12:49   
Updating to design defect: as this was designed in this way, when fixing this issue the where clause should be parsed to identify whether alias is already in use not to duplicate it.
(0052446)
AugustoMauch   
2012-09-24 21:19   
Effort: 4
Impact: low
Plan: mid