Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007281Openbravo ERP02. Master data managementpublic2009-01-30 16:362009-01-30 17:09
Reporternetworkb 
Assigned Togorkaion 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionout of date 
PlatformOS30OS Version
Product Version2.40 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0007281: 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
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
depends on backport 0007285 closed gorkaion The export buttons don't work on Product price tab on Price list tab 
related to defect 0007430 closed gorkaion Exportation to excel product price lists fails 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-01-30 16:36networkbNew Issue
2009-01-30 16:36networkbAssigned To => rafaroda
2009-01-30 16:36networkbsf_bug_id0 => 2549420
2009-01-30 16:36networkbOBNetwork customer => Yes
2009-01-30 16:36networkbRegression testing => No
2009-01-30 16:57networkbNote Added: 0012928
2009-01-30 17:03networkbNote Added: 0012929
2009-01-30 17:04rafarodaAssigned Torafaroda => gorkaion
2009-01-30 17:04rafarodaStatusnew => scheduled
2009-01-30 17:04rafarodafix_in_branch => trunk
2009-01-30 17:09rafarodaStatusscheduled => closed
2009-01-30 17:09rafarodaNote Added: 0012930
2009-01-30 17:09rafarodaResolutionopen => out of date
2009-02-09 12:35rafarodaRelationship addedrelated to 0007430

Notes
(0012928)
networkb   
2009-01-30 16:57   
In postgresql the error does not happen
(0012929)
networkb   
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   
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.