Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0010993Openbravo ERPA. Platformpublic2009-10-15 17:302012-05-09 09:04
Reporterroklenardic 
Assigned Tovmromanos 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionunable to reproduce 
PlatformOS5OS Version
Product Version2.50MP6 
Target VersionFixed in Version2.50MP9 
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
Summary0010993: Some predefined alerts are not working
DescriptionIf you schedule the Alert background process and then see the Process Monitor after the alert process executed at least once, the log will say:

2009-10-15 15:21:57.784 - Starting Alert Backgrouond Process. Loop 0
2009-10-15 15:21:57.785 - Processing rule Columns with search reference and reference value null
2009-10-15 15:21:57.787 - Error processing: @CODE=0@ERROR: operator does not exist: character varying = integer
2009-10-15 15:21:57.787 - Processing rule Updates Available
2009-10-15 15:21:57.787 - Processing rule Process Execution Failed
2009-10-15 15:21:57.788 - Error processing: @CODE=0@ERROR: relation "ad_process_run_v" does not exist

The two alerts (Process Execution Failed and Columns with search reference and reference value null) seem to have a problem out of the box.
Steps To Reproduce
Proposed Solution
Additional Information
TagsVMA-Reviewed
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-10-15 17:30roklenardicNew Issue
2009-10-15 17:30roklenardicAssigned To => rafaroda
2009-10-16 13:58psarobeAssigned Torafaroda => alostale
2009-10-16 13:58psarobeStatusnew => scheduled
2009-10-16 13:58psarobeCategory01. General setup => A. Platform
2009-10-16 13:58psarobeFixed in Version => 2.50MP9
2009-10-19 15:13roklenardicAssigned Toalostale => iciordia
2009-10-20 14:32iciordiaAssigned Toiciordia => shuehner
2009-10-20 14:34iciordiaNote Added: 0021208
2012-02-20 11:39shuehnerAssigned Toshuehner => vmromanos
2012-04-11 12:07vmromanosTag Attached: VMA-Reviewed
2012-05-09 09:04naiaramartinezNote Added: 0048487
2012-05-09 09:04naiaramartinezStatusscheduled => closed
2012-05-09 09:04naiaramartinezResolutionopen => unable to reproduce

Notes
(0021208)
iciordia   
2009-10-20 14:34   
Stefan,

please look at this problem. It would be perfect if we can add validation for alert rules (junit test?)

Thanks,

Ismael
(0048487)
naiaramartinez   
2012-05-09 09:04   
All the alerts that existed for F&B were deleted. A new demo data was created and we introduced new alerts. You can see in this issues (https://issues.openbravo.com/view.php?id=20296 [^]) which alerts were inserted and which ones are actived or not.

So, with the new demo data we schedule the Alert background process and in process monitor we can see the following log:

2012-05-09 09:00:00.059 - Starting Alert Backgrouond Process. Loop 0
2012-05-09 09:00:00.061 - Processing rule Columns with search reference and reference value null
2012-05-09 09:00:00.21 - updated alerts: 0
2012-05-09 09:00:00.21 - Processing rule Updat

The alerts are working correctly. That's why we've decided to close this issue.