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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0002170
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 05. Production managementminoralways2007-10-26 15:192008-06-12 09:43
ReporterDowidView Statuspublic 
Assigned Tocromero 
PrioritynormalResolutionfixedFixed in Version2.35
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0002170: AT235: The Calculate Standard Costs doesn't work in Postgre

DescriptionEnviroment:
OS: Windows XP SP2
DB: Postgre SQL 8.2
Browser: FF2
Openbravo: 2.35
Language: English

Steps:
Go to Production Management -> Transactions -> Calculate Standard Costs
and click on button "Ok"

Error:
function ma_standard_cost_sequence(numeric, numeric, timestamp without time zone, numeric, character varying) does not exist

In the Oracle installations this works ok
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0002501)
cromero (reporter)
2007-10-30 12:49
edited on: 2008-06-12 09:22

Logged In: YES
user_id=1500614
Originator: NO

Fixed.

Postgre translator has been modified in order to make the correct translation for the procedure MA_STANDARD_COST_SEQUENCE.
Firstly, MA_STANDARD_COST_SEQUENCE. doesn't return any message, (that's why it was invoked with PERFORM). But at this moment that it's returning a message, procedure must be invoked in Postgre with a SELECT INTO clause.

Carlos Romero
Openbravo Team
(0002502)
rafaroda (developer)
2007-10-31 11:56
edited on: 2008-06-12 09:22

Logged In: YES
user_id=1892190
Originator: NO

Verification assigned to rafaroda.
(0005759)
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=1820662 [^]

- Issue History
Date Modified Username Field Change


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker