Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0029142 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| design defect | [Openbravo ERP] A. Platform | major | sometimes | 2015-03-05 13:11 | 2022-02-01 08:09 | ||||||
| Reporter | alostale | View Status | public | ||||||||
| Assigned To | Triage Platform Base | ||||||||||
| Priority | high | Resolution | open | Fixed in Version | |||||||
| Status | acknowledged | Fix in branch | Fixed in SCM revision | ||||||||
| Projection | none | ETA | none | Target Version | |||||||
| OS | Any | Database | Any | Java version | |||||||
| OS Version | Database version | Ant version | |||||||||
| Product Version | SCM revision | ||||||||||
| Review Assigned To | |||||||||||
| Web browser | |||||||||||
| Modules | Core | ||||||||||
| 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 | ||||||||||
| Tags | No tags attached. | ||||||||||
| Attached Files | |||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|||||||||||||||
|
|||||||||||||||
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
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 |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |