Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0037467
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] 00. Application dictionaryminoralways2017-12-13 01:462022-02-01 08:05
ReporterrbianchiniView Statuspublic 
Assigned ToTriage Platform Base 
PrioritynormalResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0037467: subtab in "Purchasing Plan" with a tableDir FK to header fails

DescriptionWhen 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 Reproduce1. 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
TagsNo tags attached.
Attached Files? file icon org.openbravo.plaform.issue37467-0.0.0.obx [^] (9,678 bytes) 2017-12-14 10:26

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
There are no notes attached to this issue.

- 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


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker