Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0018116 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] 00. Application dictionary | major | have not tried | 2011-07-28 17:15 | 2011-08-06 05:33 | |||
Reporter | adrianromero | View Status | public | |||||
Assigned To | marvintm | |||||||
Priority | urgent | Resolution | fixed | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | 0951c9cfecef | ||||
Projection | none | ETA | none | Target Version | 3.0MP2 | |||
OS | Linux 32 bit | Database | PostgreSQL | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | pi | 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 | 0018116: The process that creates fields in a table based on a database table does not name properly fields | |||||||
Description | Taking a new created table in the database with the following fields: AD_ORG_ID AD_CLIENT_ID CREATED CREATEDBY UPDATED UPDATEDBY ISACTIVE Some of these columns are named incorrectly and the window created using this table does now work properly until all columns are properly named. The correct names for these columns are: Organization Client Creation Date Created By Updated Updated By Active | |||||||
Steps To Reproduce | * Create a new table in the database with the fields listed in the Description. * As System Administrator, create a new table in Openbravo for the database table created. * Execute the process "Create Columns from DB" and verify the columns created. * Create a new Window, Tab and fields for the new table created, and a menu option. * Generate the entitys and as Administrator open the window and try to save. Verify that the record cannot be saved and errors appear. * Change the name of the columns according to the description. Regenerate the entity and verify that now the window works and records can be saved, deleted, etc. | |||||||
Tags | No tags attached. | |||||||
Attached Files | ||||||||
![]() |
||||||||
|
![]() |
|
(0039748) hgbot (developer) 2011-08-01 17:13 |
Repository: erp/devel/pi Changeset: 0951c9cfecef7cdd3cf59b4f79cfff5b4f842bfa Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Mon Aug 01 17:04:08 2011 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/0951c9cfecef7cdd3cf59b4f79cfff5b4f842bfa [^] Fixed issue 18116. Names of common columns will now be generated correctly --- M src-db/database/model/functions/AD_TABLE_IMPORT.xml --- |
(0039876) hgbot (developer) 2011-08-04 18:07 |
Repository: erp/devel/pi Changeset: 7f7af04a2913f34fe7cb22d753c215ddfa875432 Author: Antonio Moreno <antonio.moreno <at> openbravo.com> Date: Thu Aug 04 18:06:49 2011 +0200 URL: http://code.openbravo.com/erp/devel/pi/rev/7f7af04a2913f34fe7cb22d753c215ddfa875432 [^] Related to issue 18116. Restored wrongly changed part of sql query --- M src-db/database/model/functions/AD_TABLE_IMPORT.xml --- |
(0039891) shuehner (administrator) 2011-08-05 11:18 |
Reviewed/test on pi/pgsql (rev-id: 7f7af04a2913). process now creates column with correct name (which is != columnname) so dal naming conventions are directly fine (tested with defining tab ontop of newly created table). Verified that existing 'table is missing common column' error message is still working correct. Running process on oracle also works without error and created the ad_column entries with the correct names. |
(0039926) hudsonbot (viewer) 2011-08-06 05:32 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/5744448753e7 [^] Maturity status: Test |
(0039970) hudsonbot (viewer) 2011-08-06 05:33 |
A changeset related to this issue has been promoted main and to the Central Repository, after passing a series of tests. Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/5744448753e7 [^] Maturity status: Test |
![]() |
|||
Date Modified | Username | Field | Change |
2011-07-28 17:15 | adrianromero | New Issue | |
2011-07-28 17:15 | adrianromero | Assigned To | => iperdomo |
2011-07-28 17:15 | adrianromero | Modules | => Core |
2011-07-28 17:15 | adrianromero | OBNetwork customer | => No |
2011-08-01 11:39 | psarobe | Priority | normal => urgent |
2011-08-01 11:39 | psarobe | Status | new => scheduled |
2011-08-01 11:49 | psarobe | Assigned To | iperdomo => marvintm |
2011-08-01 11:50 | psarobe | Relationship added | related to 0011528 |
2011-08-01 12:13 | psarobe | Target Version | 3.0MP3 => 3.0MP2 |
2011-08-01 17:13 | hgbot | Checkin | |
2011-08-01 17:13 | hgbot | Note Added: 0039748 | |
2011-08-01 17:13 | hgbot | Status | scheduled => resolved |
2011-08-01 17:13 | hgbot | Resolution | open => fixed |
2011-08-01 17:13 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/0951c9cfecef7cdd3cf59b4f79cfff5b4f842bfa [^] |
2011-08-04 18:07 | hgbot | Checkin | |
2011-08-04 18:07 | hgbot | Note Added: 0039876 | |
2011-08-05 11:18 | shuehner | Note Added: 0039891 | |
2011-08-05 11:18 | shuehner | Status | resolved => closed |
2011-08-06 05:32 | hudsonbot | Checkin | |
2011-08-06 05:32 | hudsonbot | Note Added: 0039926 | |
2011-08-06 05:33 | hudsonbot | Checkin | |
2011-08-06 05:33 | hudsonbot | Note Added: 0039970 |
Copyright © 2000 - 2009 MantisBT Group |