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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0007285
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 02. Master data managementmajoralways2009-01-30 16:362009-09-24 11:19
ReporternetworkbView Statuspublic 
Assigned Togorkaion 
PriorityimmediateResolutionfixedFixed in Version2.40MP3
StatusclosedFix in branch2.40Fixed in SCM revision34b558e62dc2
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

0007285: 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
Tagscomsup_sprint5
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to backport 0007440 closedgorkaion Exportation to excel product price lists fails 
related to backport 00107222.35MP15 closedshuehner Error "ORA-00918: column ambiguously defined" when you access to tab "price" 
blocks defect 0007281 closedgorkaion The export buttons don't work on Product price tab on Price list tab 

-  Notes
(0012931)
rafaroda (developer)
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 (reporter)
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 (developer)
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 (developer)
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 (developer)
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 (reporter)
2009-03-04 07:33

 This issue has been fixed.
(0020331)
hgbot (developer)
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
---

- Issue History
Date Modified Username Field Change
2009-01-30 17:04 rafaroda Type defect => backport
2009-01-30 17:04 rafaroda fix_in_branch => 2.40
2009-01-30 17:09 rafaroda Note Added: 0012931
2009-02-03 13:28 svnbot Checkin
2009-02-03 13:28 svnbot Note Added: 0013085
2009-02-03 13:28 svnbot Status scheduled => resolved
2009-02-03 13:28 svnbot Resolution open => fixed
2009-02-03 13:28 svnbot svn_revision => 12707
2009-02-03 13:31 gorkaion Note Added: 0013086
2009-02-06 01:17 gorkaion Tag Attached: comsup_sprint5
2009-02-09 09:56 networkb Status resolved => new
2009-02-09 09:56 networkb Resolution fixed => open
2009-02-09 09:56 networkb Note Added: 0013244
2009-02-09 10:00 rafaroda Relationship added related to 0007416
2009-02-09 11:30 gorkaion Status new => scheduled
2009-02-09 11:30 gorkaion fix_in_branch 2.40 => trunk
2009-02-09 11:33 gorkaion Status scheduled => resolved
2009-02-09 11:33 gorkaion Resolution open => fixed
2009-02-09 11:33 gorkaion Note Added: 0013252
2009-02-09 12:35 rafaroda fix_in_branch trunk => 2.40
2009-02-09 12:45 rafaroda Relationship deleted related to 0007416
2009-02-09 19:04 rafaroda Relationship added related to 0007440
2009-03-03 17:32 psarobe Fixed in Version => 2.40MP3
2009-03-04 07:33 arunkumar Status resolved => closed
2009-03-04 07:33 arunkumar Note Added: 0014355
2009-09-24 11:16 shuehner Relationship added related to 0010722
2009-09-24 11:19 hgbot Checkin
2009-09-24 11:19 hgbot Note Added: 0020331
2009-09-24 11:19 hgbot Fixed in SCM revision 12707 => http://code.openbravo.com/erp/stable/2.3x/rev/34b558e62dc2e0e492ecf4b6ac51d75bea8fdb38 [^]

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker