Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0015983 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] 01. General setup | minor | always | 2011-02-15 11:48 | 2011-03-16 19:08 | |||
| Reporter | jonalegriaesarte | View Status | public | |||||
| Assigned To | adrianromero | |||||||
| Priority | high | Resolution | fixed | Fixed in Version | 2.50MP28 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 92881081acbe | ||||
| Projection | none | ETA | none | Target Version | 2.50MP28 | |||
| OS | Any | Database | PostgreSQL | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | 2.50MP26 | SCM revision | ||||||
| Merge Request Status | ||||||||
| Review Assigned To | ||||||||
| OBNetwork customer | OBPS | |||||||
| Web browser | ||||||||
| Modules | Core | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0015983: When importing a big number of POS orders (500 different orders with 2 lines each) an appears | |||||||
| Description | When importing a big number of POS orders (500 different orders with 2 lines each) an appears. The error is: ERROR org.openbravo.erpCommon.ad_process.ImportProcessData - SQL error in query: UPDATE AD_PInstance SET IsProcessing='N', Updated=to_date(now()), Result=to_number(?), ErrorMsg=TO_CHAR(?) WHERE AD_PInstance_ID = ?Exception:org.postgresql.util.PSQLException: ERROR: value too long for type character varying(2000) ERROR org.openbravo.erpCommon.ad_process.ImportProcess - Unable to unlock instance - javax.servlet.ServletException: @CODE=0@ERROR: value too long for type character varying(2000) The problem is in the ErrorMsg column, because the message is bigger than the column size. | |||||||
| Steps To Reproduce | - Master Data Management || Import Data || Import Orders - Import 1000 lines (500 different orders) - The process fails | |||||||
| Proposed Solution | The column type MsgText could be changed to LONG | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0034906) hgbot (developer) 2011-03-15 17:39 |
Repository: erp/stable/2.50 Changeset: 92881081acbef84ab097df0546c155b3e39df06b Author: Adrián Romero <adrianromero <at> openbravo.com> Date: Tue Mar 15 17:38:23 2011 +0100 URL: http://code.openbravo.com/erp/stable/2.50/rev/92881081acbef84ab097df0546c155b3e39df06b [^] Fixes issue 0015983: When importing a big number of POS orders (500 different orders with 2 lines each) an appears It has been protected the import code to not to save more than 2000 characters in the ErrorMsg field --- M src-db/database/sourcedata/AD_MESSAGE.xml M src/org/openbravo/erpCommon/ad_process/ImportOrder.java M src/org/openbravo/erpCommon/ad_process/ImportProcess.java --- |
|
(0034908) adrianromero (viewer) 2011-03-15 17:42 |
*Testing the issue Follow the steps to test and verify that now it does not appear the error and the message generated is less than 2000 characters. * Other areas affected No other areas affected. It has only been modified the Import classes. It has been implemented this fix instead of changing the type of the ErrorMsg field to long because the implemented fix is a local fix that does not affect any other area. To change the type of the ErrorMsg field would be more risky because it will affect globally to the execution of processes all over the application |
|
(0034964) jonalegriaesarte (viewer) 2011-03-16 19:08 |
Verified |
|
(0034965) jonalegriaesarte (viewer) 2011-03-16 19:08 |
Verified |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2011-02-15 11:48 | jonalegriaesarte | New Issue | |
| 2011-02-15 11:48 | jonalegriaesarte | Assigned To | => adrianromero |
| 2011-02-15 11:48 | jonalegriaesarte | Modules | => Core |
| 2011-02-15 11:48 | jonalegriaesarte | OBNetwork customer | => Yes |
| 2011-02-15 12:54 | jonalegriaesarte | Issue Monitored: networkb | |
| 2011-03-15 17:35 | adrianromero | Status | new => scheduled |
| 2011-03-15 17:35 | adrianromero | Type | defect => backport |
| 2011-03-15 17:37 | adrianromero | Issue cloned | 0016313 |
| 2011-03-15 17:37 | adrianromero | Relationship added | depends on 0016313 |
| 2011-03-15 17:39 | hgbot | Checkin | |
| 2011-03-15 17:39 | hgbot | Note Added: 0034906 | |
| 2011-03-15 17:39 | hgbot | Status | scheduled => resolved |
| 2011-03-15 17:39 | hgbot | Resolution | open => fixed |
| 2011-03-15 17:39 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/stable/2.50/rev/92881081acbef84ab097df0546c155b3e39df06b [^] |
| 2011-03-15 17:42 | adrianromero | Note Added: 0034908 | |
| 2011-03-16 19:08 | jonalegriaesarte | Note Added: 0034964 | |
| 2011-03-16 19:08 | jonalegriaesarte | Note Added: 0034965 | |
| 2011-03-16 19:08 | jonalegriaesarte | Status | resolved => closed |
| 2011-03-16 19:08 | jonalegriaesarte | Fixed in Version | => 2.50MP28 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |