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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0015983
TypeCategorySeverityReproducibilityDate SubmittedLast Update
backport[Openbravo ERP] 01. General setupminoralways2011-02-15 11:482011-03-16 19:08
ReporterjonalegriaesarteView Statuspublic 
Assigned Toadrianromero 
PriorityhighResolutionfixedFixed in Version2.50MP28
StatusclosedFix in branchFixed in SCM revision92881081acbe
ProjectionnoneETAnoneTarget Version2.50MP28
OSAnyDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product Version2.50MP26SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0015983: When importing a big number of POS orders (500 different orders with 2 lines each) an appears

DescriptionWhen 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 SolutionThe column type MsgText could be changed to LONG
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
depends on defect 0016313 closedadrianromero When importing a big number of POS orders (500 different orders with 2 lines each) an appears 

-  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 (manager)
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 (reporter)
2011-03-16 19:08

 Verified
(0034965)
jonalegriaesarte (reporter)
2011-03-16 19:08

 Verified

- 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 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

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker