Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0022838Openbravo ERPA. Platformpublic2013-01-18 10:572013-02-21 10:09
ReporterAugustoMauch 
Assigned Toshankarb 
PriorityhighSeveritymajorReproducibilitysometimes
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target Version3.0MP21Fixed in Version3.0MP21 
Merge Request Status
Review Assigned ToAugustoMauch
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0022838: DAL should not be used to update session last ping
DescriptionThe problem occurs when the last ping is updated while the system is being rebuilt.

If in the rebuild i.e. a column in AD_Session is removed, DAL will not be able to update the last ping, and the rebuild process will fail.
Steps To Reproduce- Remove a column from AD_SESSION
- Rebuild
- Sometimes the rebuild process will fail
Proposed SolutionUse xsql instead of DAL to update the last ping.
Additional Information
TagsNo tags attached.
Relationships
related to defect 0021687 closed AugustoMauch Aleatory problem when Updating database through the application 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2013-01-18 10:57AugustoMauchNew Issue
2013-01-18 10:57AugustoMauchAssigned To => AugustoMauch
2013-01-18 10:57AugustoMauchModules => Core
2013-01-18 10:57AugustoMauchOBNetwork customer => No
2013-01-18 10:57AugustoMauchTriggers an Emergency Pack => No
2013-01-18 10:57AugustoMauchRelationship addedrelated to 0021687
2013-01-24 12:00AugustoMauchTarget Version3.0MP20 => 3.0MP21
2013-02-04 13:38AugustoMauchAssigned ToAugustoMauch => shankarb
2013-02-06 07:51shankarbStatusnew => scheduled
2013-02-06 07:51shankarbfix_in_branch => pi
2013-02-06 07:51shankarbFile Added: FixIssue22838.diff
2013-02-12 06:35shankarbIssue Monitored: AugustoMauch
2013-02-12 06:36shankarbReview Assigned To => AugustoMauch
2013-02-12 06:36shankarbfix_in_branchpi =>
2013-02-12 06:37hgbotCheckin
2013-02-12 06:37hgbotNote Added: 0056355
2013-02-12 06:37hgbotStatusscheduled => resolved
2013-02-12 06:37hgbotResolutionopen => fixed
2013-02-12 06:37hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3711ee90ab5f9325755e713089ef5d2e1874639f [^]
2013-02-12 06:40shankarbNote Added: 0056356
2013-02-12 06:40shankarbStatusresolved => new
2013-02-12 06:40shankarbResolutionfixed => open
2013-02-12 06:40shankarbFile Deleted: FixIssue22838.diff
2013-02-12 06:41shankarbStatusnew => scheduled
2013-02-12 06:41shankarbfix_in_branch => pi
2013-02-12 06:42shankarbNote Added: 0056357
2013-02-12 06:42shankarbStatusscheduled => resolved
2013-02-12 06:42shankarbFixed in Version => 3.0MP21
2013-02-12 06:42shankarbResolutionopen => fixed
2013-02-12 06:47hgbotCheckin
2013-02-12 06:47hgbotNote Added: 0056358
2013-02-20 04:49hudsonbotCheckin
2013-02-20 04:49hudsonbotNote Added: 0056573
2013-02-20 04:49hudsonbotCheckin
2013-02-20 04:49hudsonbotNote Added: 0056574
2013-02-21 10:09AugustoMauchNote Added: 0056669
2013-02-21 10:09AugustoMauchStatusresolved => closed

Notes
(0056355)
hgbot   
2013-02-12 06:37   
Repository: erp/devel/pi
Changeset: 3711ee90ab5f9325755e713089ef5d2e1874639f
Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
Date: Tue Feb 12 11:03:34 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/3711ee90ab5f9325755e713089ef5d2e1874639f [^]

Fixes Issue 0022838: DAL should not be used to update session last ping

Changed DAL update code to xsql.

---
M modules/org.openbravo.client.application/src/org/openbravo/client/application/AlertActionHandler.java
A modules/org.openbravo.client.application/src/org/openbravo/client/application/AlertActionHandler_data.xsql
---
(0056356)
shankarb   
2013-02-12 06:40   
Reopened to remove diff file.
(0056357)
shankarb   
2013-02-12 06:42   
Issue resolved
(0056358)
hgbot   
2013-02-12 06:47   
Repository: erp/devel/pi
Changeset: 18b1cbf65c4faa56ad1c3f03e7112fe6749dac6e
Author: Shankar Balachandran <shankar.balachandran <at> openbravo.com>
Date: Tue Feb 12 11:15:39 2013 +0530
URL: http://code.openbravo.com/erp/devel/pi/rev/18b1cbf65c4faa56ad1c3f03e7112fe6749dac6e [^]

Related to Issue 22838 : Updated copyright year

---
M modules/org.openbravo.client.application/src/org/openbravo/client/application/AlertActionHandler_data.xsql
---
(0056573)
hudsonbot   
2013-02-20 04:49   
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/d828167a9e83 [^]

Maturity status: Test
(0056574)
hudsonbot   
2013-02-20 04:49   
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/d828167a9e83 [^]

Maturity status: Test
(0056669)
AugustoMauch   
2013-02-21 10:09   
Code reviewed and verified in pi@9700d819690d