Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | ||||||||||
| ID | |||||||||||
| 0037467 | |||||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | ||||||
| defect | [Openbravo ERP] 00. Application dictionary | minor | always | 2017-12-13 01:46 | 2022-02-01 08:05 | ||||||
| Reporter | rbianchini | View Status | public | ||||||||
| Assigned To | Triage Platform Base | ||||||||||
| Priority | normal | 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 | 0037467: subtab in "Purchasing Plan" with a tableDir FK to header fails | ||||||||||
| Description | When adding a child tab in "Purchasing Plan", with a FK to MRP_Run_Purchase set as "link to parent column" with TableDir reference. It is not possible to add/edit records in that new tab. | ||||||||||
| Steps To Reproduce | 1. Install attached module which: - Adds a new table with a MRP_Run_Purchase_ID column being a FK to MRP_Run_Purchase with TableDir referece - Adds a new "Test" tab to "Purchasing Plan" window with that table 2. Open "Purchasing Plan" window 3. Create a record 4. Click on new in Test tab -> ERRORS: * Parent record is not selected in child one * An error can be see in logs: 595dbc4c 330110 [http-bio-8080-exec-1] ERROR org.openbravo.erpCommon.utility.ComboTableData - Error in query SELECT td0.MRP_Run_Purchase_ID AS ID, (COALESCE(TO_CHAR(COALESCE(TO_CHAR(td0.Name),'')),'') || ' - ' || COALESCE(TO_CHAR(COALESCE(TO_CHAR(td1.Name),'')),'') || ' - ' || COALESCE(TO_CHAR(COALESCE(TO_CHAR(td2.Name),'')),'') || ' - ' || COALESCE(TO_CHAR((CASE WHEN td_trl4.Name IS NULL THEN COALESCE(TO_CHAR(td3.Name),'') ELSE COALESCE(TO_CHAR(td_trl4.Name),'') END)),'') || ' - ' || COALESCE(TO_CHAR((CASE WHEN td_trl6.Name IS NULL THEN COALESCE(TO_CHAR(td5.Name),'') ELSE COALESCE(TO_CHAR(td_trl6.Name),'') END)),'') || ' - ' || COALESCE(TO_CHAR(COALESCE(TO_CHAR(td7.Name),'')),'')) AS NAME, '' AS DESCRIPTION FROM MRP_Run_Purchase td0 left join MRP_Planner td1 on td0.MRP_Planner_ID = td1.MRP_Planner_ID AND td1.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389') AND td1.AD_Org_ID IN ('E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','19404EAD144C49A0AF37D54377CF452D','0') left join C_BPartner td2 on td0.Vendor_ID = td2.Vendor_ID AND td2.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389') AND td2.AD_Org_ID IN ('E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','19404EAD144C49A0AF37D54377CF452D','0') left join M_Product_Category td3 on td0.M_Product_Category_ID = td3.M_Product_Category_ID AND td3.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389') AND td3.AD_Org_ID IN ('E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','19404EAD144C49A0AF37D54377CF452D','0') left join M_Product_Category_Trl td_trl4 on td3.M_Product_Category_ID = td_trl4.M_Product_Category_ID AND td_trl4.AD_Language = ? left join M_Product td5 on td0.M_Product_ID = td5.M_Product_ID AND td5.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389') AND td5.AD_Org_ID IN ('E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','19404EAD144C49A0AF37D54377CF452D','0') left join M_Product_Trl td_trl6 on td5.M_Product_ID = td_trl6.M_Product_ID AND td_trl6.AD_Language = ? left join C_BPartner td7 on td0.C_BPartner_ID = td7.C_BPartner_ID AND td7.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389') AND td7.AD_Org_ID IN ('E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','19404EAD144C49A0AF37D54377CF452D','0') WHERE td0.AD_Client_ID IN ('0','23C59575B9CF467C9620760EB255B389') AND td0.AD_Org_ID IN ('E443A31992CB4635AFCAEABE7183CE85','B843C30461EA4501935CB1D125C9C25A','19404EAD144C49A0AF37D54377CF452D','0') AND (td0.isActive = 'Y' OR td0.MRP_Run_Purchase_ID = (?) ) AND td0.MRP_Run_Purchase_ID=(?) ORDER BY 2, 2, 2, 2, 2, 2 org.postgresql.util.PSQLException: ERROR: column td2.vendor_id does not exist Position: 950 | ||||||||||
| Tags | No tags attached. | ||||||||||
| Attached Files |  org.openbravo.plaform.issue37467-0.0.0.obx [^] (9,678 bytes) 2017-12-14 10:26 | ||||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
| There are no notes attached to this issue. |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2017-12-13 01:46 | rbianchini | New Issue | |
| 2017-12-13 01:46 | rbianchini | Assigned To | => platform |
| 2017-12-13 01:46 | rbianchini | Modules | => Core |
| 2017-12-13 01:46 | rbianchini | Triggers an Emergency Pack | => No |
| 2017-12-13 09:03 | Practics | Issue Monitored: Practics | |
| 2017-12-14 10:26 | alostale | File Added: org.openbravo.plaform.issue37467-0.0.0.obx | |
| 2017-12-14 10:30 | alostale | Description Updated | View Revisions |
| 2017-12-14 10:30 | alostale | Steps to Reproduce Updated | View Revisions |
| 2017-12-14 10:31 | alostale | Status | new => acknowledged |
| 2017-12-14 12:19 | alostale | Summary | Adding adding child tab in "Purchasing Plan" => subtab in "Purchasing Plan" with a tableDir FK to header fails |
| 2022-02-01 08:05 | alostale | Assigned To | platform => Triage Platform Base |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |