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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0007281
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 02. Master data managementmajoralways2009-01-30 16:362009-01-30 17:09
ReporternetworkbView Statuspublic 
Assigned Togorkaion 
PriorityimmediateResolutionout of dateFixed in Version
StatusclosedFix in branchpiFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 64 bitDatabaseOracleJava version
OS VersionDatabase versionAnt version
Product Version2.40SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0007281: The export buttons don't work on Product price tab on Price list tab

DescriptionThe exports button don't work on Product price tab on Price list tab.

You get the following error:
      
Error: Error
java.lang.NullPointerException


Steps To ReproduceGo to master data management-> Pricing -> Price List

Go to "Price List Version" tab and then to "Product Price" tab.

Export to Excel or csv or pdf.

You get the following error:

      
Error: Error
java.lang.NullPointerException
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on backport 0007285 closedgorkaion The export buttons don't work on Product price tab on Price list tab 
related to defect 0007430 closedgorkaion Exportation to excel product price lists fails 

-  Notes
(0012928)
networkb (developer)
2009-01-30 16:57

 In postgresql the error does not happen
(0012929)
networkb (developer)
2009-01-30 17:03

 The error you get is the following:

16:55:09 [ajp-8009-8] ERROR org.openbravo.erpCommon.utility.ExecuteQuery - SQL error in query: SELECT SUM(PriceList) AS TOTAL
FROM M_ProductPrice
left join (SELECT M_PriceList_Version_ID, Name FROM M_PriceList_Version) td0 on M_ProductPrice.M_PriceList_Version_ID = td0.M_PriceList_Version_ID
 
left join (SELECT M_Product_ID, Name FROM M_Product) td1 on M_ProductPrice.M_Product_ID = td1.M_Product_ID
 
left join (SELECT AD_Language, M_Product_ID, Name FROM M_Product_Trl) td_trl2 on td1.M_Product_ID = td_trl2.M_Product_ID AND td_trl2.AD_Language = ?
WHERE (M_ProductPrice.M_PriceList_Version_ID, M_ProductPrice.M_Product_ID) IN (SELECT M_PriceList_Version_ID, M_Product_ID
 FROM M_ProductPrice
left join (SELECT M_PriceList_Version_ID, Name FROM M_PriceList_Version) td0 on M_ProductPrice.M_PriceList_Version_ID = td0.M_PriceList_Version_ID
 
left join (SELECT M_Product_ID, Name FROM M_Product) td1 on M_ProductPrice.M_Product_ID = td1.M_Product_ID
 
left join (SELECT AD_Language, M_Product_ID, Name FROM M_Product_Trl) td_trl2 on td1.M_Product_ID = td_trl2.M_Product_ID AND td_trl2.AD_Language = ?
 WHERE M_ProductPrice.AD_Client_ID IN (0,1000000)
 AND M_ProductPrice.AD_Org_ID IN (0,1000000,1000002,1000003,1000004,1000005,1000006,1000008,1000009,1000007)
 AND M_ProductPrice.M_PriceList_Version_ID = ?
 AND M_ProductPrice.M_Product_ID IN ('1000005')
)
Exception:java.sql.SQLException: ORA-00918: column ambiguously defined
(0012930)
rafaroda (developer)
2009-01-30 17:09

 This defect does not reproduce in trunk source code nor in PostgreSQL nor Oracle. Backport to Openbravo ERP 2.40 remains open.

- Issue History
Date Modified Username Field Change
2009-01-30 16:36 networkb New Issue
2009-01-30 16:36 networkb Assigned To => rafaroda
2009-01-30 16:36 networkb sf_bug_id 0 => 2549420
2009-01-30 16:36 networkb Regression testing => No
2009-01-30 16:57 networkb Note Added: 0012928
2009-01-30 17:03 networkb Note Added: 0012929
2009-01-30 17:04 rafaroda Assigned To rafaroda => gorkaion
2009-01-30 17:04 rafaroda Status new => scheduled
2009-01-30 17:04 rafaroda fix_in_branch => trunk
2009-01-30 17:09 rafaroda Status scheduled => closed
2009-01-30 17:09 rafaroda Note Added: 0012930
2009-01-30 17:09 rafaroda Resolution open => out of date
2009-02-09 12:35 rafaroda Relationship added related to 0007430

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker