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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0010732
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 00. Application dictionaryminoralways2009-09-24 11:242012-09-10 16:04
ReporterFrancescoFinamoreView Statuspublic 
Assigned Tomarvintm 
PrioritynormalResolutionout of dateFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSLinux 32 bitDatabasePostgreSQLJava version1.6.0_11
OS VersionrPath LinuxDatabase version8.3.5Ant version1.7.1
Product Version2.50MP5SCM revision2.50.14827 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0010732: Config Script problems

DescriptionI have a module with type "Industry Template",
I have launched this script on db :

ALTER TABLE c_city ADD CONSTRAINT it_nomecitta UNIQUE(c_country_id, c_region_id, name);
ALTER TABLE c_tax ALTER COLUMN isnotaxable SET NOT NULL;

When i launch task "ant export.config.script" i have at the end of the log this message :

Changes that couldn't be exported to the config script:
*******************************************************
AddUniqueChange. Name: IT_NOMECITTA
ColumnRequiredChange. Column: ISNOTAXABLE

But if isn't possible, it's a big limit for a Config Script, i can't customize the existing tables .


--- Added by rafaroda
Besides, disabling or removing an existing unique constraint does not get reflected in the config.script. For instance, remove C_DOCTYPE_NAME unique constraint from C_DOC_TYPE table.
Steps To Reproduce1) Create a Module with type Industry Template
2) Launch scripts :
ALTER TABLE c_city ADD CONSTRAINT it_nomecitta UNIQUE(c_country_id, c_region_id, name);
ALTER TABLE c_tax ALTER COLUMN isnotaxable SET NOT NULL;
3) ALTER TABLE C_DOCTYPE DISABLE CONSTRAINT C_DOCTYPE_NAME
4) Run script task "ant export.config.script"
Tagsdev-platform-quick-wins
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
(0051965)
alostale (manager)
2012-09-10 16:04

*Required is already exported to config script
*Unique cannot be exported as it is a new artifact that can be included in a module

- Issue History
Date Modified Username Field Change
2009-09-24 11:24 FrancescoFinamore New Issue
2009-09-24 11:24 FrancescoFinamore Assigned To => rafaroda
2009-09-29 23:03 psarobe Assigned To rafaroda => iciordia
2009-09-29 23:03 psarobe Status new => scheduled
2010-10-07 09:52 marvintm Assigned To iciordia => marvintm
2010-12-10 09:16 rafaroda Description Updated View Revisions
2010-12-10 09:16 rafaroda Steps to Reproduce Updated View Revisions
2010-12-10 09:16 rafaroda Issue Monitored: rafaroda
2010-12-10 09:16 rafaroda Tag Attached: dev-platform-quick-wins
2012-05-08 16:37 marvintm Type defect => design defect
2012-09-10 16:04 alostale Note Added: 0051965
2012-09-10 16:04 alostale Status scheduled => closed
2012-09-10 16:04 alostale Resolution open => out of date


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker