Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0002080 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 01. General setup | minor | always | 2007-10-11 15:31 | 2008-06-12 09:43 | |||
| Reporter | user71 | View Status | public | |||||
| Assigned To | alostale | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.35 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | No | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0002080: Periodic alert process doesn't work in Postgre | |||||||
| Description | When 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 | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(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 (viewer) 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 (viewer) 2007-10-31 14:39 edited on: 2008-06-12 09:22 |
Logged In: YES user_id=1871571 Originator: NO Verified |
|
(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 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |