Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0005634Openbravo ERP05. Production managementpublic2008-10-23 18:312009-04-21 11:07
Reporterrafaroda 
Assigned Torafaroda 
PrioritynormalSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
Product Versionpi 
Target VersionFixed in Version 
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
Summary0005634: Standard Costs Report does not work
DescriptionStandard Costs Report does not work with error:
ERROR org.openbravo.erpCommon.ad_reports.ReportStandardCostJR - Error captured: javax.servlet.ServletException: Error executing SQL statement for : ReportStandardCostsJR
Steps To Reproduce1) Create a Plan: Production Management || Transactions || Process Plan
2) Create a Work Requirement: Production Management || Transactions || Work Requirement
3) Create a Work Effort: Production Management || Transactions || Work Effort
4) Select the previous created data in 'Production Management || Analysis Tools || Standard Costs Report' and run the report.

Error executing SQL statement for : ReportStandardCostsJR

This is a regression since it worked in Openbravo ERP 2.40.
Proposed Solution
Additional Information
TagsUUID project
Relationships
related to defect 0005698 closed  Standard Costs Report returns null data in subreports 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-10-23 18:31rafarodaNew Issue
2008-10-23 18:31rafarodaAssigned To => rafaroda
2008-10-23 18:31rafarodasf_bug_id0 => 2189843
2008-10-23 18:31rafarodaRegression testing => No
2008-10-27 10:03psarobeStatusnew => scheduled
2008-10-27 10:03psarobefix_in_branch => trunk
2008-10-28 10:35rafarodaTag Attached: UUID project
2008-10-28 13:12svnbotCheckin
2008-10-28 13:12svnbotNote Added: 0009798
2008-10-28 13:12svnbotStatusscheduled => resolved
2008-10-28 13:12svnbotResolutionopen => fixed
2008-10-28 13:12svnbotsvn_revision => 9313
2008-10-28 15:44rafarodaRelationship addedrelated to 0005698
2008-12-13 19:52psarobeStatusresolved => new
2008-12-13 19:52psarobeResolutionfixed => open
2008-12-14 12:56rafarodaStatusnew => scheduled
2008-12-14 12:56rafarodaStatusscheduled => resolved
2008-12-14 12:56rafarodaResolutionopen => fixed
2008-12-14 12:56rafarodaNote Added: 0011302
2009-04-21 11:07psarobeStatusresolved => closed

Notes
(0009798)
svnbot   
2008-10-28 13:12   
Repository: openbravo
Revision: 9313
Author: rafaroda
Date: 2008-10-28 13:12:49 +0100 (Tue, 28 Oct 2008)

Fixes bug 0005634 Changed Sequence_ID to string in 'Standard Costs Report'.

---
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportStandardCostsJR.jrxml
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportStandardCostsJR_srptcosts.jrxml
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportStandardCostsJR_subreport0.jrxml
---

https://dev.openbravo.com/websvn/openbravo/?rev=9313&sc=1 [^]
(0011302)
rafaroda   
2008-12-14 12:56   
Works in trunk.