Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue DetailsJump to Notes ] Issue History ] Print ]
ID
0020453
TypeCategorySeverityReproducibilityDate SubmittedLast Update
defect[Openbravo ERP] A. Platformmajoralways2012-05-09 11:352012-05-09 13:39
ReportervmromanosView Statuspublic 
Assigned Toalostale 
PriorityimmediateResolutionduplicateFixed in Version
StatusclosedFix in branchFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product VersionSCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0020453: Error in Accounting Schema | Account Schema Tables

DescriptionUsing F&B client (tested in PI livebuilds Oracle), go to Accounting Schema window and select *Dollar Acct. schema. Now go to Accounting Schema Tables tab. The following error is shown:

Exception when creating query select e from FinancialMgmtAcctSchemaTable as e where ( ( e.accountingSchema.id = :alias_0 ) ) and e.organization.id in ('E443A31992CB4635AFCAEABE7183CE85', '0', 'DC206C91AA6A4897B44DA897936E0EC3', '7BABA5FF80494CAFA54DEBD22EC46F01', 'BAE22373FEBE4CCCA24517E23F0C8A48', '19404EAD144C49A0AF37D54377CF452D', 'B843C30461EA4501935CB1D125C9C25A', '2E60544D37534C0B89E765FE29BC0B43') and e.client.id in ('23C59575B9CF467C9620760EB255B389', '0')order by e.name,e.id

See http://pastebin.com/Vtz72Ypi [^] for a complete log.
The cause is:
org.hibernate.QueryException: could not resolve property: name of: FinancialMgmtAcctSchemaTable [select e from FinancialMgmtAcctSchemaTable as e where ( ( e.accountingSchema.id = :alias_0 ) ) and e.organization.id in ('4F68EB1C1B734E79B27DE9D2DF56089F', '0', '0D8E225ADA6E425E98EAA0F34E5912D7', '90A1F59849E84AFABD04814B3D15A691', 'B9C7088AB859483A9B1FB342AC2BE17A', '378AF0EAE1A2479EAAA33436645E9433', '3C816D72B14D4BBCB8571404B794AB84', '7A8E888A4B4C4E638CD5EB3A41A3289A') and e.client.id in ('FF8080812AFBCB14012AFBD3E373001F', '0')order by e.name,e.id]

I have also tested in 3.0MP10.1 and the error is not reproducible. It looks like a regression.
Steps To ReproduceUsing F&B client, go to Accounting Schema window and select *Dollar Acct. schema. Now go to Accounting Schema Tables tab
Proposed SolutionThe Query is using the name property of the FinancialMgmtAcctSchemaTable, but there this property is not defined in the table.
Probably there is something wrong in the code that generates the Query.
TagsRegression QA
Attached Files

- Relationships Relation Graph ] Dependency Graph ]
duplicate of defect 0020449 closedalostale Error when navigating to a Template record 

-  Notes
There are no notes attached to this issue.

- Issue History
Date Modified Username Field Change
2012-05-09 11:35 vmromanos New Issue
2012-05-09 11:35 vmromanos Assigned To => alostale
2012-05-09 11:35 vmromanos Modules => Core
2012-05-09 12:31 vmromanos Tag Attached: Regression QA
2012-05-09 13:39 alostale Relationship added duplicate of 0020449
2012-05-09 13:39 alostale Status new => closed
2012-05-09 13:39 alostale Resolution open => duplicate


Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker