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

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0042265
TypeCategorySeverityReproducibilityDate SubmittedLast Update
feature request[Openbravo ERP] Y. DBSourceManagerminoralways2019-11-13 11:072020-03-23 12:26
Reporternicola_uvaView Statuspublic 
Assigned Toplatform 
PrioritynormalResolutionopenFixed in Version
StatusnewFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Versionpi
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionpiSCM revision 
Review Assigned To
Web browserGoogle Chrome
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0042265: Config Script problems on SQL Constraint

DescriptionI have a module with type "Industry Template".
I need the following change:

from:
  <unique name="OBMUPC_P_MULTIUPC_CLIENT_UPC">
        <unique-column name="AD_CLIENT_ID"/>
        <unique-column name="UPC"/>
      </unique>
to:
  <unique name="OBMUPC_P_MULTIUPC_CLIENT_UPC">
        <unique-column name="AD_ORG_ID"/>
        <unique-column name="UPC"/>
      </unique>

During the export.config.script command I got the following error:

Changes that couldn't be exported to the config script:
*******************************************************
RemoveUniqueChange. Name: OBMUPC_P_MULTIUPC_CLIENT_UPC
AddUniqueChange. Name: OBMUPC_P_MULTIUPC_CLIENT_UPC
Steps To Reproduce1) Create a Module with type Industry Template
2) Launch scripts :
 ALTER TABLE obmupc_prod_multiupc DROP CONSTRAINT obmupc_p_multiupc_client_upc;
  ALTER TABLE obmupc_prod_multiupc
 ADD CONSTRAINT obmupc_p_multiupc_client_upc UNIQUE(ad_org_id, upc);
3) Run script task "ant export.config.script"
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2019-11-13 11:07 nicola_uva New Issue
2019-11-13 11:07 nicola_uva Assigned To => platform
2019-11-13 11:07 nicola_uva Web browser => Google Chrome
2019-11-13 11:07 nicola_uva Modules => Core
2019-11-13 11:07 nicola_uva Triggers an Emergency Pack => No
2019-11-13 11:09 guillermogil Web browser Google Chrome => Google Chrome
2019-11-13 11:09 guillermogil Severity major => minor
2020-03-23 12:26 martinsdan Issue Monitored: martinsdan


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker