Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011449Openbravo ERPA. Platformpublic2009-11-20 18:012009-11-24 00:00
Reportershuehner 
Assigned Toshuehner 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
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
Summary0011449: 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.

Steps To Reproduce
Proposed SolutionReplace the deprecated pl-function call by the non-deprecated equivalent.
Additional Information
TagsUUID project
Relationships
related to feature request 0004795 acknowledged Triage Platform Base Remove deprecated ad_get_next_sequence calls and use get_uuid instead (in r2.5x) 
related to defect 0011459 closed shuehner If an entry is added in Available Updates in Butler, when heartbeat requests an update there is an error because of UUIDs 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-11-20 18:01shuehnerNew Issue
2009-11-20 18:01shuehnerAssigned To => shuehner
2009-11-20 18:01shuehnerOBNetwork customer => No
2009-11-20 18:02shuehnerNote Added: 0022074
2009-11-20 18:04shuehnerNote Added: 0022075
2009-11-20 18:07shuehnerTag Attached: UUID project
2009-11-20 18:08hgbotCheckin
2009-11-20 18:08hgbotNote Added: 0022076
2009-11-20 18:08hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/e1df242e1210418e4795b0be16a8e7a541535670 [^]
2009-11-20 18:09shuehnerStatusnew => scheduled
2009-11-20 18:09shuehnerfix_in_branch => pi
2009-11-20 18:10shuehnerStatusscheduled => resolved
2009-11-20 18:10shuehnerResolutionopen => fixed
2009-11-23 13:09marvintmNote Added: 0022109
2009-11-23 13:09marvintmStatusresolved => closed
2009-11-23 13:57shuehnerRelationship addedrelated to 0004795
2009-11-24 00:00anonymoussf_bug_id0 => 2902800
2009-11-25 12:35shuehnerRelationship addedrelated to 0011459

Notes
(0022074)
shuehner   
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   
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   
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   
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.