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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0013356
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2010-05-18 09:522010-05-20 11:15
ReporternetworkbView Statuspublic 
Assigned Toadrianromero 
PriorityimmediateResolutionfixedFixed in Version2.50MP18
StatusclosedFix in branchFixed in SCM revision7203ab098ac5
ProjectionnoneETAnoneTarget Version2.50MP18
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP17SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0013356: Error when updating from 2.50mp14 to 2.50mp17.

DescriptionError when updating from 2.50mp14 to 2.50mp17 if you have defined a new documenttype for the good shipments or receipts ( docbasetype 'MMR' or'MMS')
using a name with lengh bigger than 44.

This is because the CreateDoctypeTemplate modulescripts tries to insert on the table c_poc_doctype_template a new entrie but using as name the name of the document + " Report Template" so this new string excedes the maximum lenght
of the column name on the c_poc_doctype_template table.
Steps To Reproduce-On 2.50mp14 release define a new document with docbasetype 'MMR' or'MMS' using a name with lengh bigger than 44.

-Upate the application to 2.50mp17

-You get the following error:

[java] 222633 INFO - Executing moduleScript: org.openbravo.modulescript.CreateDoctypeTemplate
[java] 222959 ERROR - SQL error in query: INSERT INTO c_poc_doctype_template( c_poc_doctype_template_id, ad_client_id, ad_org_id, isactive, created, createdby, updated, updatedby, c_doctype_id, name, templatelocation, reportfilename, templatefilename) VALUES (?, ?, '0', 'Y', now(), '0', now(), '0', ?, ?, ?, ?, ?)Exception:org.postgresql.util.PSQLException: ERROR: value too long for type character varying(60)
[java] 222962 ERROR - Error executing moduleScript org.openbravo.modulescript.CreateDoctypeTemplate: @CODE=0@ERROR: value too long for type character varying(60)
[java] 222964 ERROR - Error executing moduleScript: org.openbravo.modulescript.CreateDoctypeTemplate
[java] Execution of moduleScript org.openbravo.modulescript.CreateDoctypeTemplatefailed.
[java] at org.openbravo.modulescript.ModuleScriptHandler.execute(ModuleScriptHandler.java:68)
[java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:164)
[java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:87)
[java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:34)
[java] Exception in thread "main" Execution of moduleScript org.openbravo.modulescript.CreateDoctypeTemplatefailed.
[java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:202)
[java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:87)
[java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:34)
[java] Caused by: Execution of moduleScript org.openbravo.modulescript.CreateDoctypeTemplatefailed.
[java] at org.openbravo.modulescript.ModuleScriptHandler.execute(ModuleScriptHandler.java:68)
[java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:164)
[java] ... 2 more
[java] --- Nested Exception ---
[java] Execution of moduleScript org.openbravo.modulescript.CreateDoctypeTemplatefailed.
[java] at org.openbravo.modulescript.ModuleScriptHandler.execute(ModuleScriptHandler.java:68)
[java] at org.openbravo.ddlutils.task.AlterDatabaseDataAll.doExecute(AlterDatabaseDataAll.java:164)
[java] at org.openbravo.ddlutils.task.BaseDatabaseTask.execute(BaseDatabaseTask.java:87)
[java] at org.openbravo.ddlutils.task.AlterDatabaseJava.main(AlterDatabaseJava.java:34)
TagsRegression
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 00119962.50MP14 closedadrianromero The jasper report linked to MM Shipment/Receipt is not printed 

-  Notes
(0027416)
hgbot (developer)
2010-05-18 13:08

 Repository: erp/devel/pi
Changeset: 7203ab098ac5957a682e284557c2996530ae8c70
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Tue May 18 16:37:46 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/7203ab098ac5957a682e284557c2996530ae8c70 [^]

Fixes Issue 13356 Before, a string is appended along with the name.Now this is removed.

---
M src-util/modulescript/build/classes/org/openbravo/modulescript/CreateDoctypeTemplate.class
M src-util/modulescript/src/org/openbravo/modulescript/CreateDoctypeTemplate.java
---
(0027417)
harikrishnan (viewer)
2010-05-18 13:10

 Steps to test:

Give doc-type name as 60 characters and run update.database.

Root Cause:

Before, a string is appended along with the name.Now this is removed.

Impact.

Their is no impact because of this fix.
(0027431)
psarobe (viewer)
2010-05-18 14:56

 Testing doing code review. The fix is correct
(0027592)
hudsonbot (viewer)
2010-05-20 11:15

 A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/7203ab098ac5 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/a7901e097e1a [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17407.obx [^]

- Issue History
Date Modified Username Field Change
2010-05-18 09:52 networkb New Issue
2010-05-18 09:52 networkb Assigned To => alostale
2010-05-18 09:52 networkb OBNetwork customer => Yes
2010-05-18 09:53 networkb Target Version => 2.50MP18
2010-05-18 10:56 alostale Status new => scheduled
2010-05-18 10:56 alostale Assigned To alostale => adrianromero
2010-05-18 10:56 alostale fix_in_branch => pi
2010-05-18 11:03 psarobe Tag Attached: Regression
2010-05-18 11:04 psarobe version 2.50MP14 => 2.50MP17
2010-05-18 11:04 psarobe fix_in_branch pi =>
2010-05-18 12:25 adrianromero Relationship added related to 0011996
2010-05-18 13:08 hgbot Checkin
2010-05-18 13:08 hgbot Note Added: 0027416
2010-05-18 13:08 hgbot Status scheduled => resolved
2010-05-18 13:08 hgbot Resolution open => fixed
2010-05-18 13:08 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/7203ab098ac5957a682e284557c2996530ae8c70 [^]
2010-05-18 13:10 harikrishnan Note Added: 0027417
2010-05-18 14:56 psarobe Note Added: 0027431
2010-05-18 14:56 psarobe Status resolved => closed
2010-05-18 14:56 psarobe Fixed in Version => 2.50MP18
2010-05-19 00:01 anonymous sf_bug_id 0 => 3003691
2010-05-20 11:15 hudsonbot Checkin
2010-05-20 11:15 hudsonbot Note Added: 0027592

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker