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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0012193
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] Z. Otherscriticalhave not tried2010-02-09 23:222010-03-10 18:29
ReportershuehnerView Statuspublic 
Assigned Toalostale 
PriorityimmediateResolutionfixedFixed in Version
StatusclosedFix in branchpiFixed in SCM revisionfd9d74a9c8cf
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012193: Api check build 284 fails

DescriptionThis api build fails:

http://builds.openbravo.com/job/erp_devel_pi-module-integrity-test/284/console [^]

Problem is:
+++++++++++++++++++++++++++++++++++++++++++++++++++
  Errors in API model validation
+++++++++++++++++++++++++++++++++++++++++++++++++++
  Column size decreased from 60 to 30: column: AD_PROCESS.PROCEDURENAME
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 00121032.50MP12 closedalostale The procedure C_Debt_Payment_Balancing_Replace on DB is C_Debt_Payment_Balancing_Rep 

-  Notes
(0024073)
shuehner (administrator)
2010-02-09 23:22

Note: as explained by alostale looks like a technical necessity (oracle can only have 30 character object names) now enforced in by our model.
(0024079)
alostale (manager)
2010-02-10 07:41

AD_Process.ProcedureName column is used to store the PL/SQL procedure name implementing a process. As DB objects in Oracle cannot be longer than 30 characters, and DBSourceManager truncates actual procedure names to 30 characters, it is useless to be able to introduce longer procedure names in this column.

Furthermore, it is error prone, as happened in issue 0012103. It is possible that the procedure name in AD to be longer than 30 characters and when exporting from PG this name is truncated, if the developer does not notice the process will not work the next time database is updated.
(0024094)
hgbot (developer)
2010-02-10 13:11

Repository: erp/devel/pi
Changeset: fd9d74a9c8cf9db187b19f4805c89f341239a6b3
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Feb 10 13:12:53 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/fd9d74a9c8cf9db187b19f4805c89f341239a6b3 [^]

related to issue 12103, related to issue 12193
       Rollback physical column size change done in previous commit, as it introduces an
       error when updating database

---
M src-db/database/model/tables/AD_PROCESS.xml
---
(0024095)
alostale (manager)
2010-02-10 13:13

This column has been changed back to 60 character long in DB, but in AD is kept as 30. In this way it will not be possible to enter longer names by UI.

Being 30 in DB caused error messages in update.database though the process completed successfully.
(0024321)
hudsonbot (developer)
2010-02-15 17:37

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/fd9d74a9c8cf [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/2596487a564c [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16391.obx [^]

- Issue History
Date Modified Username Field Change
2010-02-09 23:22 shuehner New Issue
2010-02-09 23:22 shuehner Assigned To => rafaroda
2010-02-09 23:22 shuehner Assigned To rafaroda => alostale
2010-02-09 23:22 shuehner Note Added: 0024073
2010-02-10 07:37 alostale Relationship added related to 0012103
2010-02-10 07:41 alostale Note Added: 0024079
2010-02-10 07:42 alostale Assigned To alostale => pjuvara
2010-02-10 13:09 alostale Assigned To pjuvara => alostale
2010-02-10 13:11 hgbot Checkin
2010-02-10 13:11 hgbot Note Added: 0024094
2010-02-10 13:11 hgbot Fixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/fd9d74a9c8cf9db187b19f4805c89f341239a6b3 [^]
2010-02-10 13:13 alostale Note Added: 0024095
2010-02-11 11:18 alostale Status new => scheduled
2010-02-11 11:18 alostale fix_in_branch => pi
2010-02-11 11:18 alostale Status scheduled => resolved
2010-02-11 11:18 alostale Resolution open => fixed
2010-02-11 11:18 alostale Status resolved => closed
2010-02-12 00:00 anonymous sf_bug_id 0 =>
2010-02-15 17:37 hudsonbot Checkin
2010-02-15 17:37 hudsonbot Note Added: 0024321
2010-03-10 18:29 anonymous sf_bug_id => 2968037


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker