Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0011449
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajorhave not tried2009-11-20 18:012009-11-24 00:00
ReportershuehnerView Statuspublic 
Assigned Toshuehner 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisione1df242e1210
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0011449: Alert_data.xsql does not work with postgresql 8.3 (save method)

Descriptionthe save method is missing some quotes around the deprecated pl-function call ad_get_next_sequence.

Proposed SolutionReplace the deprecated pl-function call by the non-deprecated equivalent.
TagsUUID project
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to feature request 0004795 acknowledgedTriage Platform Base Remove deprecated ad_get_next_sequence calls and use get_uuid instead (in r2.5x) 
related to defect 0011459 closedshuehner If an entry is added in Available Updates in Butler, when heartbeat requests an update there is an error because of UUIDs 

-  Notes
(0022074)
shuehner (administrator)
2009-11-20 18:02

Note: This probably means that incoming update-notifications from butler/heartbeat do not work on pgsql >=8.3
(0022075)
shuehner (administrator)
2009-11-20 18:04

Error message when save is executed:
org.postgresql.util.PSQLException: ERROR: function ad_get_next_sequence(unknown, integer) does not exist
as quotes around second parameter in the method invocation are missing.
(0022076)
hgbot (developer)
2009-11-20 18:08

Repository: erp/devel/pi
Changeset: e1df242e1210418e4795b0be16a8e7a541535670
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Fri Nov 20 18:07:33 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/e1df242e1210418e4795b0be16a8e7a541535670 [^]

Issue 11449: Fix pgsql83/uuid issue in incoming update alerts

---
M src/org/openbravo/erpCommon/utility/Alert_data.xsql
---
(0022109)
marvintm (developer)
2009-11-23 13:09

Tested with stage butler. With previous version, it failed. With newest version in PI, it worked, so the issue was correctly resolved.

- Issue History
Date Modified Username Field Change
2009-11-20 18:01 shuehner New Issue
2009-11-20 18:01 shuehner Assigned To => shuehner
2009-11-20 18:02 shuehner Note Added: 0022074
2009-11-20 18:04 shuehner Note Added: 0022075
2009-11-20 18:07 shuehner Tag Attached: UUID project
2009-11-20 18:08 hgbot Checkin
2009-11-20 18:08 hgbot Note Added: 0022076
2009-11-20 18:08 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e1df242e1210418e4795b0be16a8e7a541535670 [^]
2009-11-20 18:09 shuehner Status new => scheduled
2009-11-20 18:09 shuehner fix_in_branch => pi
2009-11-20 18:10 shuehner Status scheduled => resolved
2009-11-20 18:10 shuehner Resolution open => fixed
2009-11-23 13:09 marvintm Note Added: 0022109
2009-11-23 13:09 marvintm Status resolved => closed
2009-11-23 13:57 shuehner Relationship added related to 0004795
2009-11-24 00:00 anonymous sf_bug_id 0 => 2902800
2009-11-25 12:35 shuehner Relationship added related to 0011459


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker