Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
0013226Openbravo ERP05. Production managementpublic2010-05-05 10:522010-05-18 21:44
harikrishnan 
harikrishnan 
normalmajoralways
closedfixed 
5
 
 
Core
No
0013226: When completing or processing documents the updatedby column is not updated properly
These are the places where the audit fields are not properly updated.

1.Internal Consumption
-Create a document with one user
Process or complete with other user
See that the updatedby is not properly updated.
No tags attached.
depends on backport 0013242 closed harikrishnan When completing or processing documents the updatedby column is not updated properly 
Issue History
2010-05-05 10:52harikrishnanNew Issue
2010-05-05 10:52harikrishnanAssigned To => adrianromero
2010-05-06 13:00harikrishnanStatusnew => scheduled
2010-05-06 13:00harikrishnanfix_in_branch => pi
2010-05-07 05:32harikrishnanAssigned Toadrianromero => harikrishnan
2010-05-07 05:36hgbotCheckin
2010-05-07 05:36hgbotNote Added: 0027012
2010-05-07 05:36hgbotStatusscheduled => resolved
2010-05-07 05:36hgbotResolutionopen => fixed
2010-05-07 05:36hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/4335281c5d182e5c9e366a808e3db0944da90bb7 [^]
2010-05-07 05:36harikrishnanNote Added: 0027014
2010-05-14 12:23arunkumarNote Added: 0027238
2010-05-14 12:23arunkumarStatusresolved => closed
2010-05-16 00:00anonymoussf_bug_id0 => 3002204
2010-05-18 21:44hudsonbotCheckin
2010-05-18 21:44hudsonbotNote Added: 0027490

Notes
(0027012)
hgbot   
2010-05-07 05:36   
Repository: erp/devel/pi
Changeset: 4335281c5d182e5c9e366a808e3db0944da90bb7
Author: Harikrishnan Raja <harikrishnan.raja <at> openbravo.com>
Date: Fri May 07 09:05:21 2010 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/4335281c5d182e5c9e366a808e3db0944da90bb7 [^]

Fixes Issue 13226: When completing or processing documents the updated-by column is not updated properly.

---
M src-db/database/model/functions/M_INTERNAL_CONSUMPTION_POST.xml
---
(0027014)
harikrishnan   
2010-05-07 05:36   
Steps to test:
*Create two new user.
    1.UserA
    2.userB
*Login as UserA
*Create new record in each above mentioned section(Don't complete it or process it)
*Login as UserB and complete all the record above created.


Root cause & solution:
Audit fields are not properly updated.Hence the user id is taken from the pinstance table and used in update and insert statement.

Impact:
Their is no impact other then these files.
(0027238)
arunkumar   
2010-05-14 12:23   
Tested working fine
(0027490)
hudsonbot   
2010-05-18 21:44   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/4335281c5d18 [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/aa11838d5f80 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.17380.obx [^]