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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0018116
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 00. Application dictionarymajorhave not tried2011-07-28 17:152011-08-06 05:33
ReporteradrianromeroView Statuspublic 
Assigned Tomarvintm 
PriorityurgentResolutionfixedFixed in Version
StatusclosedFix in branchFixed in SCM revision0951c9cfecef
ProjectionnoneETAnoneTarget Version3.0MP2
OSLinux 32 bitDatabasePostgreSQLJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0018116: The process that creates fields in a table based on a database table does not name properly fields

DescriptionTaking 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.
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
related to defect 0011528 closedmarvintm Export validation fails after table creation 

-  Notes
(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 (developer)
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 (developer)
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

- Issue History
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-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
Powered by Mantis Bugtracker