Anonymous | Login
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] 02. Master data managementminorhave not tried2014-04-04 10:082022-02-01 08:09
ReporterjonalegriaesarteView Statuspublic 
Assigned ToTriage Platform Base 
PriorityhighResolutionopenFixed in Version
StatusacknowledgedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo

0026176: When deleting a business partner with elements related the message shown is not correct

DescriptionWhen deleting a business partner with elements related the message shown is not correct
Steps To Reproduce- Create a business partner. Add a location
- Create a sales invoice
- Delete the business partner

Depending on the case the message can be:
ERROR: null value in column "c_bpartner_location_id" violates not-null constraint


Error: Document posted/processed
Proposed SolutionError message should be standard when the element to delete has elements related
TagsNo tags attached.
Attached Files

- Relationships Relation Graph ] Dependency Graph ]

-  Notes
rafaroda (developer)
2014-06-19 15:22


1) When trying to delete a Business Partner: Document posted/processed

2014-06-18 19:13:24,127 [http-8787-6] ERROR org.hibernate.util.JDBCExceptionReporter - Batch entry 0 update C_Invoice set Updated='2014-06-18 19:13:23.939000 +02:00:00', C_BPartner_Location_ID=NULL, AD_User_ID=NULL where C_Invoice_ID='02AB2F6DA9714BE4B9687149371EC183' was aborted. Call getNextException to see the cause.
2014-06-18 19:13:24,128 [http-8787-6] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: @20501@

2) When trying to delete a Price List: This record cannot be deleted because it is associated with other existing elements. Please see Linked Items

2014-06-18 19:14:04,462 [http-8787-5] ERROR org.hibernate.util.JDBCExceptionReporter - Batch entry 0 delete from M_PriceList where M_PriceList_ID='1D8D2464FE974C41812CF0128C160CB3' was aborted. Call getNextException to see the cause.
2014-06-18 19:14:04,462 [http-8787-5] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: update or delete on table "m_pricelist" violates foreign key constraint "c_invoice_m_pricelist" on table "c_invoice"
  Detail: Key (m_pricelist_id)=(1D8D2464FE974C41812CF0128C160CB3) is still referenced from table "c_invoice".

3) When trying to delete a Product: It is not possible to delete a permanent cost.

2014-06-18 19:12:34,917 [http-8787-3] ERROR org.hibernate.util.JDBCExceptionReporter - Batch entry 0 delete from M_Costing where M_Costing_ID='C045B4CA6EB4406C8ACEA5B3E27434F3' was aborted. Call getNextException to see the cause.
2014-06-18 19:12:34,917 [http-8787-3] ERROR org.hibernate.util.JDBCExceptionReporter - ERROR: @CannotDeletePermanentCost@
alostale (manager)
2014-06-20 10:16

When a record is deleted it no checks are done at OB level, DAL object is tried to be deleted, at this point Hibernate tries to delete its children executing
delete statement in DB for all of them and finally for parent object.

In case any of these delete statements fails the message is parsed and shown to the user. So if one of the children executes a trigger which sends a message this one is shown and the transaction is aborted.

- Issue History
Date Modified Username Field Change
2014-04-04 10:08 jonalegriaesarte New Issue
2014-04-04 10:08 jonalegriaesarte Assigned To => pramakrishnan
2014-04-04 10:08 jonalegriaesarte Modules => Core
2014-04-04 10:08 jonalegriaesarte Resolution time => 1402869600
2014-04-04 10:08 jonalegriaesarte Triggers an Emergency Pack => No
2014-06-16 08:33 rafaroda Assigned To pramakrishnan => rafaroda
2014-06-16 08:33 rafaroda Status new => scheduled
2014-06-19 15:22 rafaroda Note Added: 0068171
2014-06-19 16:03 rafaroda Assigned To rafaroda => alostale
2014-06-20 10:16 alostale Note Added: 0068211
2014-06-30 10:12 jonalegriaesarte Resolution time 1402869600 =>
2014-06-30 10:12 jonalegriaesarte Type defect => design defect
2014-06-30 13:09 jonalegriaesarte Target Version PR14Q3 =>
2017-03-31 14:36 alostale Status scheduled => acknowledged
2017-04-10 14:33 alostale Assigned To alostale => platform
2022-02-01 08:09 alostale Assigned To platform => Triage Platform Base

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker