Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0011448Openbravo ERP09. Financial managementpublic2009-11-20 16:522009-12-02 00:00
Reportershuehner 
Assigned Toshuehner 
PrioritynormalSeverityminorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Versionpi 
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
Summary0011448: ReportVatRegisterJR does not work on postgresql 8.3 and this report and the CreateVatRegister process have unused sql code
DescriptionThis report conatains one query updatePageNo which is missing a to_number call so will fail on postgresql 8.3.

In addition this report and the related process contain unused sql in non-public xsql files so it can be removed.
Steps To Reproduce
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
related to feature request 0006698 closed shuehner Partial list of broken/not useful xsql methods which are currently not used 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-11-20 16:52shuehnerNew Issue
2009-11-20 16:52shuehnerAssigned To => shuehner
2009-11-20 16:52shuehnerRelationship addedrelated to 0006698
2009-11-20 17:07hgbotCheckin
2009-11-20 17:07hgbotNote Added: 0022072
2009-11-20 17:07hgbotStatusnew => resolved
2009-11-20 17:07hgbotResolutionopen => fixed
2009-11-20 17:07hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/c67ddb0e0407b5c355b5c372eee3674a6b7fcd26 [^]
2009-12-01 10:36dalsasuaNote Added: 0022282
2009-12-01 10:36dalsasuaStatusresolved => closed
2009-12-01 10:36dalsasuaFixed in Version => pi
2009-12-02 00:00anonymoussf_bug_id0 => 2907163

Notes
(0022072)
hgbot   
2009-11-20 17:07   
Repository: erp/devel/pi
Changeset: c67ddb0e0407b5c355b5c372eee3674a6b7fcd26
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Fri Nov 20 17:07:19 2009 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/c67ddb0e0407b5c355b5c372eee3674a6b7fcd26 [^]

Fixed 11448: add missing to_number to make report working on pgsql 8.3
remove lots of unused xsql methods

---
M src/org/openbravo/erpCommon/ad_actionButton/TaxRegister.xsql
M src/org/openbravo/erpReports/TaxRegister_data.xsql
---
(0022282)
dalsasua   
2009-12-01 10:36   
Tested. Working fine.