Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004858Openbravo ERP07. Sales managementpublic2008-09-08 17:062009-02-20 12:21
Reporterrafaroda 
Assigned ToHennadzi 
PriorityhighSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS20OS VersionUbuntu 7.10
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
Summary0004858: 'Sales Report by Partner and Product' report does not work
Description'Sales Report by Partner and Product' does not work with message: Could not load object from location : /home/openbravo/workspaces/multi-currency-reports/openbravo/WebContent/src-loc/design/org/openbravo/erpCommon/ad_reports/ReportSalesPartnerProduct_srpt.jasper

This is a regression since in Openbravo ERP 2.40 production it worked.
Steps To Reproduce1) Go to 'Sales Management || Analysis Tools || Sales Report by Partner and Product'
2) select an output type then click on 'OK' button.

You get the following error: Could not load object from location : /home/openbravo/workspaces/multi-currency-reports/openbravo/WebContent/src-loc/design/org/openbravo/erpCommon/ad_reports/ReportSalesPartnerProduct_srpt.jasper
Proposed Solution
Additional Information
TagsUUID project
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-09-08 17:06rafarodaNew Issue
2008-09-08 17:06rafarodaAssigned To => cromero
2008-09-08 17:06rafarodasf_bug_id0 => 2100421
2008-09-08 17:06rafarodaRegression testing => No
2008-09-10 13:30rafarodaAssigned Tocromero => rafaroda
2008-09-10 13:30rafarodaStatusnew => scheduled
2008-09-10 16:07rafarodaNote Added: 0008979
2008-09-25 15:53rafarodaTag Attached: UUID project
2008-09-25 17:46svnbotCheckin
2008-09-25 17:46svnbotNote Added: 0009205
2008-09-25 17:46svnbotStatusscheduled => resolved
2008-09-25 17:46svnbotResolutionopen => fixed
2008-09-25 17:46svnbotsvn_revision => 7918
2008-12-08 16:22psarobeStatusresolved => new
2008-12-08 16:22psarobeResolutionfixed => open
2008-12-08 16:22psarobeNote Added: 0011024
2008-12-09 13:04pheenanAssigned Torafaroda => Hennadzi
2008-12-11 14:16HennadziNote Added: 0011183
2008-12-11 14:16HennadziStatusnew => scheduled
2008-12-11 14:16Hennadzifix_in_branch => trunk
2008-12-11 14:17HennadziResolutionopen => unable to reproduce
2008-12-11 14:17Hennadzifix_in_branchtrunk =>
2008-12-11 14:18HennadziNote Edited: 0011183
2008-12-14 12:17rafarodaStatusscheduled => resolved
2008-12-14 12:17rafarodaResolutionunable to reproduce => fixed
2008-12-14 12:17rafarodaNote Added: 0011301
2009-02-20 12:21sureshbabuStatusresolved => closed
2009-02-20 12:21sureshbabuNote Added: 0013825
2009-02-20 12:21sureshbabuFixed in Version => trunk

Notes
(0008979)
rafaroda   
2008-09-10 16:07   
Once 'ReportSalesPartnerProduct_srpt.jasper' restored (iw as wrongly deleted in [1]), the error message is: net.sf.jasperreports.engine.JRException: Incompatible java.lang.String value assigned to parameter PARTNER in the ReportSalesPartnerProduct_srpt dataset.

15:03:14 [http-8883-Processor25] ERROR net.sf.jasperreports.engine.fill.JRFillSubreport - Fill 10507790: exception
net.sf.jasperreports.engine.JRException: Incompatible java.lang.String value assigned to parameter PARTNER in the ReportSalesPartnerProduct_srpt dataset.
    at net.sf.jasperreports.engine.fill.JRFillDataset.setParameter(JRFillDataset.java:897)
    at net.sf.jasperreports.engine.fill.JRFillDataset.setFillParameterValues(JRFillDataset.java:654)
    at net.sf.jasperreports.engine.fill.JRFillDataset.setParameterValues(JRFillDataset.java:603)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.setParameters(JRBaseFiller.java:891)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:716)
    at net.sf.jasperreports.engine.fill.JRBaseFiller.fill(JRBaseFiller.java:669)
    at net.sf.jasperreports.engine.fill.JRFillSubreport.fillSubreport(JRFillSubreport.java:522)
    at net.sf.jasperreports.engine.fill.JRSubreportRunnable.run(JRSubreportRunnable.java:63)
    at net.sf.jasperreports.engine.fill.JRThreadSubreportRunner.run(JRThreadSubreportRunner.java:209)
    at java.lang.Thread.run(Thread.java:595)
15:03:14 [http-8883-Processor25] ERROR org.openbravo.erpCommon.utility.PrintJR - Error captured: javax.servlet.ServletException: net.sf.jasperreports.engine.JRException: Incompatible java.lang.String value assigned to parameter PARTNER in the ReportSalesPartnerProduct_srpt dataset.

[1] https://dev.openbravo.com/websvn/openbravo/?rev=6607&sc=1 [^]
(0009205)
svnbot   
2008-09-25 17:46   
Repository: openbravo
Revision: 7918
Author: rafaroda
Date: 2008-09-25 17:46:26 +0200 (Thu, 25 Sep 2008)

Fixes bug 0004858 Restored 'ReportSalesPartnerProduct_srpt.jasper' and converted PARTNER parameter to String.

---
A trunk/src/org/openbravo/erpCommon/ad_reports/ReportSalesPartnerProduct_srpt.jasper
U trunk/src/org/openbravo/erpCommon/ad_reports/ReportSalesPartnerProduct_srpt.jrxml
U trunk/src-db/database/sourcedata/AD_PROCESS_PARA.xml
---

https://dev.openbravo.com/websvn/openbravo/?rev=7918&sc=1 [^]
(0011024)
psarobe   
2008-12-08 16:22   
Error: Error executing SQL statement for : ReportSalesPartnerProduct
(0011183)
Hennadzi   
2008-12-11 14:16   
(edited on: 2008-12-11 14:18)
I am unable to reproduce this bug in the trunk. If this is still an issue for you please contact me, as for now I've set the status of this bug to "unable to reproduce".
(0011301)
rafaroda   
2008-12-14 12:17   
'Sales Report by Partner and Product' now works in trunk.
(0013825)
sureshbabu   
2009-02-20 12:21   
Retested in context 79.125.56.185/openbravotrunk