Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0002275 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 04. Warehouse management | minor | always | 2007-11-16 00:34 | 2008-07-04 17:18 | |||
| Reporter | user71 | View Status | public | |||||
| Assigned To | cromero | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | 2.40beta | |||
| Status | closed | Fix in branch | Fixed in SCM revision | |||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| 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. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0002669) cromero (viewer) 2007-11-23 13:53 edited on: 2008-06-12 09:23 |
Logged In: YES user_id=1500614 Originator: NO This bug has been fixed and you can find the solution in the subversion repository. Next releases will include it fixed. Thank you for your feedback Carlos Romero Openbravo Team |
|
(0005864) user71 2005-06-01 00:00 edited on: 2008-06-12 09:43 |
This bug was originally reported in SourceForge bug tracker and then migrated to Mantis. You can see the original bug report in: https://sourceforge.net/support/tracker.php?aid=1832818 [^] |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |