Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0017903Openbravo ERPA. Platformpublic2011-07-05 16:302011-08-12 10:39
Reporteralostale 
Assigned Toalostale 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP2Fixed in Version3.0MP2 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0017903: Error when displaying a record created/modified by a deleted user
DescriptionIn DB there's not FK from audit columns (createdBy and updatedBy) to AD_User. This makes possible to delete a User that has created or updated records.

When one of these records is tried to be opened in grid an org.hibernate.ObjectNotFoundException exception is shown and the record is not loaded.
Steps To Reproduce-Create a user
-Create an invoice with this user
-Delete the user
-Try to load the created invoice with another user
Proposed SolutionDo not fail in this case. Load the record and for these fields display UUID or something else.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2011-07-05 16:30alostaleNew Issue
2011-07-05 16:30alostaleAssigned To => alostale
2011-07-05 16:30alostaleModules => Core
2011-07-05 16:30alostaleOBNetwork customer => No
2011-07-06 11:05hgbotCheckin
2011-07-06 11:05hgbotNote Added: 0038894
2011-07-06 11:05hgbotStatusnew => resolved
2011-07-06 11:05hgbotResolutionopen => fixed
2011-07-06 11:05hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/d9a6f9688511b12523e21251c85ff940f6566fa1 [^]
2011-07-06 20:41hudsonbotCheckin
2011-07-06 20:41hudsonbotNote Added: 0038910
2011-08-12 10:39jonalegriaesarteNote Added: 0040140
2011-08-12 10:39jonalegriaesarteStatusresolved => closed
2011-08-12 10:39jonalegriaesarteFixed in Version => 3.0MP2

Notes
(0038894)
hgbot   
2011-07-06 11:05   
Repository: erp/devel/pi
Changeset: d9a6f9688511b12523e21251c85ff940f6566fa1
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed Jul 06 11:01:20 2011 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/d9a6f9688511b12523e21251c85ff940f6566fa1 [^]

fixed bug 17903: Error when displaying a record created/modified by a deleted user

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/DataToJsonConverter.java
---
(0038910)
hudsonbot   
2011-07-06 20:41   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/7aa2bbafa595 [^]

Maturity status: Test
(0040140)
jonalegriaesarte   
2011-08-12 10:39   
Verified