Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0004829 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Openbravo ERP] 03. Procurement management | major | always | 2008-09-05 16:39 | 2008-12-03 18:43 | |||
| Reporter | rafaroda | View Status | public | |||||
| Assigned To | Hennadzi | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | ||||
| Status | closed | Fix in branch | Fixed in SCM revision | 10335 | ||||
| Projection | none | ETA | none | Target Version | 2.50 | |||
| OS | Linux 32 bit | Database | PostgreSQL | Java version | 1.5 | |||
| OS Version | Ubuntu 7.10 | Database version | 8.3 | Ant version | 1.7 | |||
| Product Version | pi | SCM revision | 6905 | |||||
| Review Assigned To | ||||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0004829: Requisition To Order does not work | |||||||
| Description | While trying to add a requisition to make and order, you get this error in the log: 15:38:13 [http-8382-Processor22] ERROR org.openbravo.erpCommon.ad_forms.RequisitionToOrderData - SQL error in query: UPDATE M_REQUISITIONLINE SET LOCKEDBY = ?, LOCKDATE = now(), LOCKQTY = null, LOCKPRICE = null, LOCKCAUSE = 'M' WHERE M_REQUISITIONLINE_ID IN ('C9E5ABAC118D4DC19DA0A49A09601793')Exception:org.postgresql.util.PSQLException: ERROR: COALESCE types character varying and integer cannot be matched 15:38:13 [http-8382-Processor22] ERROR org.openbravo.base.secureApp.HttpSecureAppServlet - Error captured: javax.servlet.ServletException: @CODE=0@ERROR: COALESCE types character varying and integer cannot be matched | |||||||
| Steps To Reproduce | 1) Create a requisition and complete it: Procurement Management || Transactions || Requisition 2) Add this requisition line to an order: Procurement Management || Transactions || Requisition To Order You can not: ERROR: COALESCE types character varying and integer cannot be matched | |||||||
| Tags | No tags attached. | |||||||
| Attached Files |  patch.diff [^] (1,935 bytes) 2008-09-07 23:55 [Show Content]
| |||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0008904) gkfabs (reporter) 2008-09-07 23:07 |
After running the query manually on my database, I get ERROR: COALESCE types character varying and integer cannot be matched CONTEXT: SQL statement "SELECT ((COALESCE( $1 , '0') <> COALESCE( $2 ,'0')) OR (COALESCE( $3 , -1) <> COALESCE( $4 , '-1')) OR (COALESCE( $5 , -1) <> COALESCE( $6 , '-1')) OR (COALESCE( $7 , -1) <> COALESCE( $8 , '-1')) OR (COALESCE( $9 , -1) <> COALESCE( $10 , -1)) OR (COALESCE( $11 , -1) <> COALESCE( $12 , -1)) OR (COALESCE( $13 , -1) <> COALESCE( $14 , -1 )) OR (COALESCE( $15 , -1) <> COALESCE( $16 , -1 )) OR (COALESCE( $17 , -1) <> COALESCE( $18 , -1 )) OR (COALESCE( $19 , '0') <> COALESCE( $20 , '0' )) OR (COALESCE( $21 , '0') <> COALESCE( $22 , '0' )) OR (COALESCE( $23 , '0') <> COALESCE( $24 , '0' )) OR (COALESCE( $25 , -1) <> COALESCE( $26 , -1 )) OR (COALESCE( $27 , -1) <> COALESCE( $28 , '-1' )) OR (COALESCE( $29 , TO_DATE('01-01-1900', 'DD-MM-YYYY')) <> COALESCE( $30 , TO_DATE('01-01-1900', 'DD-MM-YYYY'))))" PL/pgSQL function "m_requisitionline_trg" line 55 at IF |
|
(0008905) gkfabs (reporter) 2008-09-07 23:56 |
The patch I just added should solved this issue. |
|
(0010453) svnbot (reporter) 2008-11-20 16:20 |
Repository: openbravo Revision: 10335 Author: hennadzi Date: 2008-11-20 16:20:09 +0100 (Thu, 20 Nov 2008) Fixed bug 0004829: Requisition To Order does not work --- U trunk/src/org/openbravo/erpCommon/ad_forms/RequisitionToOrder_data.xsql U trunk/src-db/database/model/triggers/M_REQUISITIONLINE_TRG.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=10335&sc=1 [^] |
|
(0010617) psarobe (manager) 2008-11-25 11:37 |
To create the requisition do the same as in 0004718 but not create the purchase After that next steps: 1. The requisition must be completed to be able to see it in the requisition to order window 2. Move the line from up to down using the ADD button 3. Then select and click create button. 4. Select a date and click Ok. If the order has been created, then the bug is fixed |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-09-05 16:39 | rafaroda | New Issue | |
| 2008-09-05 16:39 | rafaroda | Assigned To | => gorkaion |
| 2008-09-05 16:39 | rafaroda | sf_bug_id | 0 => 2095125 |
| 2008-09-05 16:39 | rafaroda | Regression testing | => No |
| 2008-09-07 23:07 | gkfabs | Note Added: 0008904 | |
| 2008-09-07 23:55 | gkfabs | File Added: patch.diff | |
| 2008-09-07 23:56 | gkfabs | Note Added: 0008905 | |
| 2008-09-08 10:53 | psarobe | Priority | normal => high |
| 2008-09-08 10:53 | psarobe | Status | new => scheduled |
| 2008-09-08 10:53 | psarobe | Target Version | trunk => 2.50 |
| 2008-11-13 23:09 | rafaroda | Assigned To | gorkaion => Hennadzi |
| 2008-11-20 16:20 | svnbot | Checkin | |
| 2008-11-20 16:20 | svnbot | Note Added: 0010453 | |
| 2008-11-20 16:20 | svnbot | Status | scheduled => resolved |
| 2008-11-20 16:20 | svnbot | Resolution | open => fixed |
| 2008-11-20 16:20 | svnbot | svn_revision | => 10335 |
| 2008-11-25 11:37 | psarobe | Note Added: 0010617 | |
| 2008-12-03 18:43 | psarobe | Status | resolved => closed |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |