Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0007285Openbravo ERP02. Master data managementpublic2009-01-30 16:362009-09-24 11:19
Reporternetworkb 
Assigned Togorkaion 
PriorityimmediateSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version
Product Version2.40 
Target VersionFixed in Version2.40MP3 
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
Summary0007285: 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
Tagscomsup_sprint5
Relationships
related to backport 0007440 closed gorkaion Exportation to excel product price lists fails 
related to backport 00107222.35MP15 closed shuehner Error "ORA-00918: column ambiguously defined" when you access to tab "price" 
blocks defect 0007281 closed gorkaion The export buttons don't work on Product price tab on Price list tab 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2009-01-30 17:04rafarodaTypedefect => backport
2009-01-30 17:04rafarodafix_in_branch => 2.40
2009-01-30 17:09rafarodaNote Added: 0012931
2009-02-03 13:28svnbotCheckin
2009-02-03 13:28svnbotNote Added: 0013085
2009-02-03 13:28svnbotStatusscheduled => resolved
2009-02-03 13:28svnbotResolutionopen => fixed
2009-02-03 13:28svnbotsvn_revision => 12707
2009-02-03 13:31gorkaionNote Added: 0013086
2009-02-06 01:17gorkaionTag Attached: comsup_sprint5
2009-02-09 09:56networkbStatusresolved => new
2009-02-09 09:56networkbResolutionfixed => open
2009-02-09 09:56networkbNote Added: 0013244
2009-02-09 10:00rafarodaRelationship addedrelated to 0007416
2009-02-09 11:30gorkaionStatusnew => scheduled
2009-02-09 11:30gorkaionfix_in_branch2.40 => trunk
2009-02-09 11:33gorkaionStatusscheduled => resolved
2009-02-09 11:33gorkaionResolutionopen => fixed
2009-02-09 11:33gorkaionNote Added: 0013252
2009-02-09 12:35rafarodafix_in_branchtrunk => 2.40
2009-02-09 12:45rafarodaRelationship deletedrelated to 0007416
2009-02-09 19:04rafarodaRelationship addedrelated to 0007440
2009-03-03 17:32psarobeFixed in Version => 2.40MP3
2009-03-04 07:33arunkumarStatusresolved => closed
2009-03-04 07:33arunkumarNote Added: 0014355
2009-09-24 11:16shuehnerRelationship addedrelated to 0010722
2009-09-24 11:19hgbotCheckin
2009-09-24 11:19hgbotNote Added: 0020331
2009-09-24 11:19hgbotFixed in SCM revision12707 => http://code.openbravo.com/erp/stable/2.3x/rev/34b558e62dc2e0e492ecf4b6ac51d75bea8fdb38 [^]

Notes
(0012931)
rafaroda   
2009-01-30 17:09   
In PostgreSQL the error does not happen.

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
(0013085)
svnbot   
2009-02-03 13:28   
Repository: openbravo
Revision: 12707
Author: gorkaion
Date: 2009-02-03 13:28:27 +0100 (Tue, 03 Feb 2009)

Fixed bug 7285. Modified the sql generation to include tablename.columnname in some cases.

---
U branches/r2.40/src/org/openbravo/erpCommon/utility/TableSQLData.java
---

https://dev.openbravo.com/websvn/openbravo/?rev=12707&sc=1 [^]
(0013086)
gorkaion   
2009-02-03 13:31   
This fix might cause some inconsistencies in the application.

I've tested that the grid and the export works fine in Oracle.
(0013244)
networkb   
2009-02-09 09:56   
The bug is not solved. When export is launched, this error appears:

javax.servlet.ServletException: Report design not valid :
         1. The columns and the margins do not fit the page width.
        at org.openbravo.erpCommon.utility.ExportGrid.doPost(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:709)
        at org.openbravo.base.HttpBaseServlet.serviceInitialized(Unknown Source)
        at org.openbravo.base.secureApp.HttpSecureAppServlet.service(Unknown Source)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:252)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.openbravo.utils.SessionExpirationFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.openbravo.utils.CharsetFilter.doFilter(Unknown Source)
        at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:202)
        at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:173)
        at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:213)
        at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:178)
        at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:126)
        at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:105)
        at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:107)
        at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:148)
        at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:869)
        at org.apache.coyote.http11.Http11BaseProtocol$Http11ConnectionHandler.processConnection(Http11BaseProtocol.java:664)
        at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint.java:527)
        at org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollowerWorkerThread.java:80)
        at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool.java:684)
        at java.lang.Thread.run(Thread.java:595)
(0013252)
gorkaion   
2009-02-09 11:33   
The issue was already fixed.

The new defect reported in the notes is a different error that only happen when the grid is exported to csv or pdf. Please, report it as a new issue.

Thanks.
(0014355)
arunkumar   
2009-03-04 07:33   
This issue has been fixed.
(0020331)
hgbot   
2009-09-24 11:19   
Repository: erp/stable/2.3x
Changeset: 34b558e62dc2e0e492ecf4b6ac51d75bea8fdb38
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Thu Sep 24 11:19:31 2009 +0200
URL: http://code.openbravo.com/erp/stable/2.3x/rev/34b558e62dc2e0e492ecf4b6ac51d75bea8fdb38 [^]

Fixed 10722: Fix ambigous column error on oracle
By applying patch committed into issue 7285.

---
M src/org/openbravo/erpCommon/utility/TableSQLData.java
---