Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0020449Openbravo ERPA. Platformpublic2012-05-08 17:382012-05-28 10:34
Reporteriperdomo 
Assigned Toalostale 
PriorityurgentSeveritymajorReproducibilityalways
StatusclosedResolutionfixed 
PlatformOS30OS Version3.3.4-2-ARCH
Product Versionpi 
Target VersionFixed in Version3.0MP12 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browserGoogle Chrome
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0020449: Error when navigating to a Template record
DescriptionWhen nagivating to a Template record, you get an error in the Template Dependency tab. See attached files.
Steps To Reproduce* Login with System Administrator Role
* Open the Datasource window
* Pick Custom Query Selector DataSource record
* Navigate to Template (Datasource Template)
* See the error in the Template Dependency Tab

Notes:
* OBCLKER_Template_Dependency has no "name" column
* The OBCLKER_Template_Dependency table has 2 columns as identifier: Obclker_Template_ID, Dependson_Template_ID
* Dependson_Template_ID is a TableDir pointing to OBCLKER_Template table who has "name" column as part of the identifier
* The generated hql order by: "e.name,e.id" should be "e.template.name, e.id"
Proposed Solution
Additional Information
TagsRegression QA
Relationships
has duplicate defect 0020453 closed alostale Error in Accounting Schema | Account Schema Tables 
has duplicate defect 0020456 closed alostale An error appears in Module window 
blocks design defect 00203863.0MP15 closed AugustoMauch Filter by Financial Account it does not work in grid view 
Attached Fileslog error.log (13,825) 2012-05-08 17:38
https://issues.openbravo.com/file_download.php?file_id=5201&type=bug
png error-template-record.png (86,066) 2012-05-08 17:43
https://issues.openbravo.com/file_download.php?file_id=5202&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2012-05-08 17:38iperdomoNew Issue
2012-05-08 17:38iperdomoAssigned To => alostale
2012-05-08 17:38iperdomoFile Added: error.log
2012-05-08 17:38iperdomoWeb browser => Google Chrome
2012-05-08 17:38iperdomoModules => Core
2012-05-08 17:43iperdomoFile Added: error-template-record.png
2012-05-09 10:41alostaleRelationship addedblocks 0020386
2012-05-09 10:42alostaleNote Added: 0048492
2012-05-09 10:43hgbotCheckin
2012-05-09 10:43hgbotNote Added: 0048494
2012-05-09 10:43hgbotStatusnew => resolved
2012-05-09 10:43hgbotResolutionopen => fixed
2012-05-09 10:43hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/1582d1dc7250976053698019f0fd68481743ed2b [^]
2012-05-09 13:39alostaleRelationship addedhas duplicate 0020453
2012-05-09 13:40alostaleRelationship addedhas duplicate 0020456
2012-05-09 17:53plujanTag Attached: Regression QA
2012-05-25 12:11hudsonbotCheckin
2012-05-25 12:11hudsonbotNote Added: 0049076
2012-05-28 10:34AugustoMauchNote Added: 0049341
2012-05-28 10:34AugustoMauchStatusresolved => closed
2012-05-28 10:34AugustoMauchFixed in Version => 3.0MP12

Notes
(0048492)
alostale   
2012-05-09 10:42   
Introduced by fix for 0020386. Reverting it.
(0048494)
hgbot   
2012-05-09 10:43   
Repository: erp/devel/pi
Changeset: 1582d1dc7250976053698019f0fd68481743ed2b
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Wed May 09 10:43:24 2012 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/1582d1dc7250976053698019f0fd68481743ed2b [^]

fixed bug 20449, related to bug 20386

Revert original fix for 0020386 as it causes 0020449

---
M modules/org.openbravo.service.json/src/org/openbravo/service/json/JsonUtils.java
---
(0049076)
hudsonbot   
2012-05-25 12:11   
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/5401e185a8b0 [^]

Maturity status: Test
(0049341)
AugustoMauch   
2012-05-28 10:34   
Code reviewed and verified in pi@520938516719