Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0012193 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] Z. Others | critical | have not tried | 2010-02-09 23:22 | 2010-03-10 18:29 | |||
Reporter | shuehner | View Status | public | |||||
Assigned To | alostale | |||||||
Priority | immediate | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | pi | Fixed in SCM revision | fd9d74a9c8cf | |||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Merge Request Status | ||||||||
Review Assigned To | ||||||||
OBNetwork customer | No | |||||||
Web browser | ||||||||
Modules | Core | |||||||
Support ticket | ||||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0012193: Api check build 284 fails | |||||||
Description | This 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 | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
![]() |
||||||||
|
![]() |
|
(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 (viewer) 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 (viewer) 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 (viewer) 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 [^] |
![]() |
|||
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 | OBNetwork customer | => No |
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 |