Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0012286Openbravo ERPA. Platformpublic2010-02-16 14:202010-03-10 18:30
Reportershuehner 
Assigned Toshuehner 
PriorityurgentSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version2.50MP12 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0012286: Audit Trail does not work on c_invoicetax based based , instead an exception is shown
DescriptionThis exception is shown when opening the audit trail popup on the invoice tax tab

ce8e1878 14:07:20 [http-8880-1] ERROR org.openbravo.erpCommon.businessUtility.AuditTrailPopup - Error captured:
org.hibernate.NonUniqueResultException: query did not return a unique result: 2
        at org.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:820)
        at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
        at org.openbravo.dal.service.OBQuery.uniqueResult(OBQuery.java:80)
        at org.openbravo.erpCommon.businessUtility.AuditTrailPopup.getElementNameForTable(AuditTrailPopup.java:395)
        at
Steps To Reproduce
Proposed Solutionad_element.columnname is not unique, so don't expect a unique result but pick for value found.
Additional Information
TagsAudit trial
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2010-02-16 14:20shuehnerNew Issue
2010-02-16 14:20shuehnerAssigned To => shuehner
2010-02-16 14:21shuehnerTag Attached: Audit trial
2010-02-16 15:00hgbotCheckin
2010-02-16 15:00hgbotNote Added: 0024412
2010-02-16 15:00hgbotStatusnew => resolved
2010-02-16 15:00hgbotResolutionopen => fixed
2010-02-16 15:00hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/195dda7f410b7aec6ed34084a3b0fab775f2d629 [^]
2010-02-16 15:47alostaleStatusresolved => closed
2010-02-16 15:47alostaleFixed in Version => 2.50MP12
2010-02-17 00:01anonymoussf_bug_id0 =>
2010-02-18 00:31hudsonbotCheckin
2010-02-18 00:31hudsonbotNote Added: 0024538
2010-03-10 18:30anonymoussf_bug_id => 2968078

Notes
(0024412)
hgbot   
2010-02-16 15:00   
Repository: erp/devel/pi
Changeset: 195dda7f410b7aec6ed34084a3b0fab775f2d629
Author: Stefan Hühner <stefan.huehner <at> openbravo.com>
Date: Tue Feb 16 15:00:50 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/195dda7f410b7aec6ed34084a3b0fab775f2d629 [^]

Fixed 12286, Fixed 12265, fixed to audit trail popup
- don't assume ad_element.columnname is unique
- hide go back link when navigated into a child tab
- format modification time without milliseconds
- small ui fixes

---
M src-db/database/sourcedata/AD_TEXTINTERFACES.xml
M src/org/openbravo/erpCommon/businessUtility/AuditTrailPopup.java
M src/org/openbravo/erpCommon/businessUtility/AuditTrailPopupDeleted.html
M src/org/openbravo/erpCommon/businessUtility/AuditTrailPopupHistory.html
---
(0024538)
hudsonbot   
2010-02-18 00:31   
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/195dda7f410b [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/7c1b489fb0a0 [^]
Tests: http://builds.openbravo.com/view/devel-int/ [^]
OBX: http://builds.openbravo.com/erp/core/obx/OpenbravoERP-2.50CI.16459.obx [^]