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

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0012319
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] B. User interfaceminoralways2010-02-17 12:032010-05-18 12:12
ReporternetworkbView Statuspublic 
Assigned Toshuehner 
PriorityhighResolutionno change requiredFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version2.50MP17
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version2.50MP11SCM revision 
Merge Request Status
Review Assigned To
OBNetwork customerOBPS
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0012319: Confuse error when inserting a record from a PL with wrong referenced value

DescriptionIf you have a PL which executes INSERT statements to a certain table and you set a wrong value in a column defined as foreign key from another one, you will get the following error when executing your process from the application:

Error:
No se puede eliminar el registro porque existen elementos asociados. Por favor consulte Referencia
    
This error is confused for end-user.
Steps To Reproduce1. Modify any of existent PL adding an INSERT clause trying to set a non-existent value in a column defined as foreign key
2. Execute modified procedure from application.

(For example, you can try to add a record into m_product_uom table setting a wrong value in C_UOM_ID column, by copying this statement into M_INOUT_POST procedure:

insert into m_product_uom values (1000005, 1000000, 1000002,'Y',sysdate,100,sysdate,100,888888,1000067);
 )
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to feature request 0012792 newTriage Platform Base Review and improve error handling 

-  Notes
(0025699)
shuehner (administrator)
2010-03-24 12:25

 Some questions..

The issue with the error handling is clear, and currently not fixable easily, as at the time of the error message generating we don't have the info if the statement leading to the problem is an insert, update or delete.

However please state a valid use-case where this error might happen in any 'correct' pl-code.
(0025704)
shuehner (administrator)
2010-03-24 15:01

 Hi,

i agree that the complexity should not reject an issue out of the box (just because its complex), but it could/should perhaps affect priority when viewed together with the severity (i.e. common case or only happen if some i.e. pl code is not working correctly).

My request for info here is just to get this severity clarified, as i have some possible change in mind but need to worry about regressions vs. rejecting a change.
(0025707)
networkb (viewer)
2010-03-24 17:55

 After evaluating effort for this solution, FR 12792 has been created.

Regards
(0025708)
shuehner (administrator)
2010-03-24 17:58

 Rejecting after ok from support team. Issue should only happen with incorrect code, and effort/risk in changed involved is too high with respect to benefit.

However feature request to improve the situation later if its easier to implement is created to track the possible improvement.

- Issue History
Date Modified Username Field Change
2010-02-17 12:03 networkb New Issue
2010-02-17 12:03 networkb Assigned To => dbaz
2010-02-17 12:03 networkb OBNetwork customer => Yes
2010-02-17 12:07 dbaz Assigned To dbaz => alostale
2010-02-22 08:21 alostale Status new => scheduled
2010-02-22 08:21 alostale Assigned To alostale => shuehner
2010-02-22 08:21 alostale fix_in_branch => pi
2010-03-08 16:05 jpabloae Target Version 2.50MP14 => 2.50MP15
2010-03-24 12:25 shuehner Note Added: 0025699
2010-03-24 12:25 shuehner Status scheduled => feedback
2010-03-24 13:55 networkb Status feedback => new
2010-03-24 13:55 networkb fix_in_branch pi =>
2010-03-24 15:01 shuehner Note Added: 0025704
2010-03-24 17:54 networkb Relationship added related to 0012792
2010-03-24 17:55 networkb Note Added: 0025707
2010-03-24 17:58 shuehner Note Added: 0025708
2010-03-24 17:58 shuehner Status new => closed
2010-03-24 17:58 shuehner Resolution open => no change required
2010-03-25 00:00 anonymous sf_bug_id 0 => 2976198
2010-05-18 12:12 gorka_gil Target Version 2.50MP15 => 2.50MP17

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker