Openbravo Issue Tracking System - Openbravo ERP | |||||||||||||||||||
| View Issue Details | |||||||||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | ||||||||||||||
| 0029142 | Openbravo ERP | A. Platform | public | 2015-03-05 13:11 | 2022-02-01 08:09 | ||||||||||||||
| Reporter | alostale | ||||||||||||||||||
| Assigned To | Triage Platform Base | ||||||||||||||||||
| Priority | high | Severity | major | Reproducibility | sometimes | ||||||||||||||
| Status | acknowledged | Resolution | open | ||||||||||||||||
| Platform | OS | 5 | OS Version | ||||||||||||||||
| Product Version | |||||||||||||||||||
| Target Version | Fixed in Version | ||||||||||||||||||
| Merge Request Status | |||||||||||||||||||
| Review Assigned To | |||||||||||||||||||
| OBNetwork customer | |||||||||||||||||||
| Web browser | |||||||||||||||||||
| Modules | Core | ||||||||||||||||||
| Support ticket | |||||||||||||||||||
| Regression level | |||||||||||||||||||
| Regression date | |||||||||||||||||||
| Regression introduced in release | |||||||||||||||||||
| Regression introduced by commit | |||||||||||||||||||
| Triggers an Emergency Pack | No | ||||||||||||||||||
| Summary | 0029142: update.database does not remove invalid rows with multiple level of cascaded FKs | ||||||||||||||||||
| Description | When updating database the step "removing invalid rows" tries to emulate FK cascade deletion (for cascaded FKs) for those tables where FKs are deactivated. FK deactivation can occur: * For AD tables: all of them are deactivated * Other tables: they are recreated on The problem is that this step does not take into account recreated tables nor FK dependencies with multiple levels. | ||||||||||||||||||
| Steps To Reproduce | - Remove script implemented to fix 0029127 -Install PR14Q3 -Open Costing Rules window -Create a new Record -Execute Validate Costing Rule process -Update to PR14Q4 -> This error appears: [java] 87780 WARN - SQL Command failed with: ERROR: insert or update on table "ad_process_run" violates foreign key constraint "ad_process_run_ad_process_requ" [java] Detail: Key (ad_process_request_id)=(A4A686C15C074C80982C31D6943F46AB) is not present in table "ad_process_request". [java] 87785 WARN - -- END [java] ALTER TABLE AD_PROCESS_RUN [java] ADD CONSTRAINT AD_PROCESS_RUN_AD_PROCESS_REQU FOREIGN KEY (AD_PROCESS_REQUEST_ID) REFERENCES AD_PROCESS_REQUEST (AD_PROCESS_REQUEST_ID) ON DELETE CASCADE | ||||||||||||||||||
| Proposed Solution | |||||||||||||||||||
| Additional Information | |||||||||||||||||||
| Tags | No tags attached. | ||||||||||||||||||
| Relationships |
| ||||||||||||||||||
| Attached Files | |||||||||||||||||||
| Issue History | |||||||||||||||||||
| Date Modified | Username | Field | Change | ||||||||||||||||
| 2015-03-05 13:11 | alostale | New Issue | |||||||||||||||||
| 2015-03-05 13:11 | alostale | Assigned To | => alostale | ||||||||||||||||
| 2015-03-05 13:11 | alostale | Modules | => Core | ||||||||||||||||
| 2015-03-05 13:11 | alostale | Triggers an Emergency Pack | => No | ||||||||||||||||
| 2015-03-05 13:11 | alostale | Relationship added | related to 0029127 | ||||||||||||||||
| 2015-03-05 13:11 | alostale | Status | new => acknowledged | ||||||||||||||||
| 2015-03-13 12:09 | alostale | Relationship added | related to 0029270 | ||||||||||||||||
| 2015-03-17 14:38 | alostale | Assigned To | alostale => platform | ||||||||||||||||
| 2015-11-11 11:34 | alostale | Priority | normal => high | ||||||||||||||||
| 2015-11-11 12:36 | alostale | Type | defect => design defect | ||||||||||||||||
| 2022-02-01 08:09 | alostale | Assigned To | platform => Triage Platform Base | ||||||||||||||||
| There are no notes attached to this issue. |