Openbravo Issue Tracking System - Openbravo ERP | |||||
| View Issue Details | |||||
| ID | Project | Category | View Status | Date Submitted | Last Update |
| 0042265 | Openbravo ERP | Y. DBSourceManager | public | 2019-11-13 11:07 | 2022-02-01 08:07 |
| Reporter | nicola_uva | ||||
| Assigned To | Triage Platform Base | ||||
| Priority | normal | Severity | minor | Reproducibility | always |
| Status | new | Resolution | open | ||
| Platform | OS | 5 | OS Version | ||
| Product Version | pi | ||||
| Target Version | pi | Fixed in Version | |||
| Merge Request Status | |||||
| Review Assigned To | |||||
| OBNetwork customer | |||||
| Web browser | Google Chrome | ||||
| Modules | Core | ||||
| Support ticket | |||||
| Regression level | |||||
| Regression date | |||||
| Regression introduced in release | |||||
| Regression introduced by commit | |||||
| Triggers an Emergency Pack | No | ||||
| Summary | 0042265: Config Script problems on SQL Constraint | ||||
| Description | I 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 Reproduce | 1) 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 | |||||
| Tags | No tags attached. | ||||
| Relationships | |||||
| Attached Files | |||||
| 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 | |||
| 2022-02-01 08:07 | alostale | Assigned To | platform => Triage Platform Base | ||
| There are no notes attached to this issue. |