Openbravo Issue Tracking System - Openbravo ERP | ||||||||||||
| View Issue Details | ||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
| 0020453 | Openbravo ERP | A. Platform | public | 2012-05-09 11:35 | 2012-05-09 13:39 | |||||||
| Reporter | vmromanos | |||||||||||
| Assigned To | alostale | |||||||||||
| Priority | immediate | Severity | major | Reproducibility | always | |||||||
| Status | closed | Resolution | duplicate | |||||||||
| Platform | OS | 5 | OS Version | |||||||||
| Product Version | ||||||||||||
| Target Version | Fixed in Version | |||||||||||
| Merge Request Status | ||||||||||||
| Review Assigned To | ||||||||||||
| OBNetwork customer | ||||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Support ticket | ||||||||||||
| 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. | |||||||||||
| Additional Information | ||||||||||||
| Tags | Regression QA | |||||||||||
| Relationships |
| |||||||||||
| Attached Files | ||||||||||||
| 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 | |||||||||
| There are no notes attached to this issue. |