Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0002275 | Openbravo ERP | 04. Warehouse management | public | 2007-11-16 00:34 | 2008-07-04 17:18 |
| Reporter | user71 | ||||
| Assigned To | cromero | ||||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | closed | Resolution | fixed | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | |||||
| Target Version | Fixed in Version | 2.40beta | |||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | No | ||||
| Web browser | |||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0002275: Error adding shipment in line | ||||
| Description | I've encountered an error trying to add a product to a shipment in line in OpenBravo 2.35. Warehouse Management || Transactions || Incoming Shipment || Shipment in >> Shipment in line I've only encountered this error in my local install, not using the live demo, and since it's an sql error I suspect it's a Postgresql specific issue (postgresql-8.2.5-1.fc7 and postgresql-jdbc-8.2.504-1jpp.fc7) Steps to reproduce: 1) Create a new shipment in, set only the Business Partner (I used Adib ,Company but I don't think it matters) and save. 2) Go to Shipment in line and hit new, use the Article selector and perform a search. Regardless of whether you select a product in the article select, or hit Ok or cancel, when the page reloads after you leave the selector the error occurs. All the buttons in the editing menu are unresponsive and you need to use the application menu. The following error shows up in the apache log 51191015 [http-8080-Processor24] ERROR org.openbravo.erpCommon.ad_callouts.SLInOutLineProductData - SQL error in query: SELECT COALESCE(count (*),0) FROM M_INOUTLINE WHERE M_INOUTLINE_ID=?Exception:org.postgresql.util.PSQLException: The column name COALESCE(COUNT(*),0) was not found in this ResultSet. The actual query appears to be in ./src/org/openbravo/erpCommon/ad_callouts/SL_InOutLine_Product_data.xsql Note that the actual sql query runs fine, instead it appears to be a problem with processing the result set. | ||||
| Steps To Reproduce | |||||
| Proposed Solution | |||||
| Additional Information | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| Issue History | |||||
| Date Modified | Username | Field | Change | ||
| 2008-07-04 17:18 | plujan | Status | resolved => closed | ||
| 2008-07-04 17:18 | plujan | Fixed in Version | 2.40alpha-r2 => 2.40beta | ||
| Notes | |||||
|
|
|||||
|
|
||||
|
|
|||||
|
|
||||