Project:
View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
ID | ||||||||
0020453 | ||||||||
Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
defect | [Openbravo ERP] A. Platform | major | always | 2012-05-09 11:35 | 2012-05-09 13:39 | |||
Reporter | vmromanos | View Status | public | |||||
Assigned To | alostale | |||||||
Priority | immediate | Resolution | duplicate | Fixed in Version | ||||
Status | closed | Fix in branch | Fixed in SCM revision | |||||
Projection | none | ETA | none | Target Version | ||||
OS | Any | Database | Any | Java version | ||||
OS Version | Database version | Ant version | ||||||
Product Version | SCM revision | |||||||
Review Assigned To | ||||||||
Web browser | ||||||||
Modules | Core | |||||||
Regression level | ||||||||
Regression date | ||||||||
Regression introduced in release | ||||||||
Regression introduced by commit | ||||||||
Triggers an Emergency Pack | No | |||||||
Summary | 0020453: Error in Accounting Schema | Account Schema Tables | |||||||
Description | Using 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 Reproduce | Using F&B client, go to Accounting Schema window and select *Dollar Acct. schema. Now go to Accounting Schema Tables tab | |||||||
Proposed Solution | The 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. | |||||||
Tags | Regression QA | |||||||
Attached Files | ||||||||
Relationships [ Relation Graph ] [ Dependency Graph ] | ||||||||
|
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 |