Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0042265Openbravo ERPY. DBSourceManagerpublic2019-11-13 11:072022-02-01 08:07
Reporternicola_uva 
Assigned ToTriage Platform Base 
PrioritynormalSeverityminorReproducibilityalways
StatusnewResolutionopen 
PlatformOS5OS Version
Product Versionpi 
Target VersionpiFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customerGold
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0042265: 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"
Proposed Solution
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2019-11-13 11:07nicola_uvaNew Issue
2019-11-13 11:07nicola_uvaAssigned To => platform
2019-11-13 11:07nicola_uvaOBNetwork customer => No
2019-11-13 11:07nicola_uvaWeb browser => Google Chrome
2019-11-13 11:07nicola_uvaModules => Core
2019-11-13 11:07nicola_uvaTriggers an Emergency Pack => No
2019-11-13 11:09guillermogilOBNetwork customerNo => Gold
2019-11-13 11:09guillermogilWeb browserGoogle Chrome => Google Chrome
2019-11-13 11:09guillermogilSeveritymajor => minor
2020-03-23 12:26martinsdanIssue Monitored: martinsdan
2022-02-01 08:07alostaleAssigned Toplatform => Triage Platform Base

There are no notes attached to this issue.