Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0002080Openbravo ERP01. General setuppublic2007-10-11 15:312008-06-12 09:43
Reporteruser71 
Assigned Toalostale 
PrioritynormalSeverityminorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in Version2.35 
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
Summary0002080: Periodic alert process doesn't work in Postgre
DescriptionWhen you create a new alert, background process (PeriodicAlert) that inserts the alerts does not take this new alert.
I think this is in Postgre database only.

Gentoo
Postgre 8.2.4
Openbravo 2.34
Tomcat 5.5
Ant 1.7.0
jdk 1.5.0_12
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange

Notes
(0005669)
user71   
2005-06-01 00:00   
(edited on: 2008-06-12 09:43)
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis.

You can see the original bug report in:
https://sourceforge.net/support/tracker.php?aid=1811547 [^]
(0002355)
user71   
2007-10-11 15:37   
(edited on: 2008-06-12 09:22)
Logged In: YES
user_id=1500670
Originator: YES

There are two errors in this process when Openbravo is under Postgre. Both are in /ad_background/PeriodicAlert_data.xsql file.
- In existsReference method, the sql needs an alias (of course you need to add this alias to the first sql method).
- In InsertAlert method you need to add to_number if you want to insert a number in a column.

Regards
(0002356)
pjuvara   
2007-10-31 14:31   
(edited on: 2008-06-12 09:22)
Logged In: YES
user_id=1871571
Originator: NO

Assigned to pjuvara for verification.
(0002357)
pjuvara   
2007-10-31 14:39   
(edited on: 2008-06-12 09:22)
Logged In: YES
user_id=1871571
Originator: NO

Verified