Openbravo Issue Tracking System - Openbravo ERP | ||||||||||||
| View Issue Details | ||||||||||||
| ID | Project | Category | View Status | Date Submitted | Last Update | |||||||
| 0004253 | Openbravo ERP | A. Platform | public | 2008-07-01 18:20 | 2008-09-03 22:01 | |||||||
| Reporter | plujan | |||||||||||
| Assigned To | cromero | |||||||||||
| Priority | immediate | Severity | critical | Reproducibility | have not tried | |||||||
| Status | closed | Resolution | fixed | |||||||||
| Platform | OS | 10 | OS Version | XPsp2 | ||||||||
| Product Version | 2.40beta | |||||||||||
| Target Version | Fixed in Version | 2.40 | ||||||||||
| Merge Request Status | ||||||||||||
| Review Assigned To | ||||||||||||
| OBNetwork customer | No | |||||||||||
| Web browser | ||||||||||||
| Modules | Core | |||||||||||
| Support ticket | ||||||||||||
| Regression level | ||||||||||||
| Regression date | ||||||||||||
| Regression introduced in release | ||||||||||||
| Regression introduced by commit | ||||||||||||
| Triggers an Emergency Pack | No | |||||||||||
| Summary | 0004253: AT240beta - Using Oracle, AD_TABLE_POST_V view is in an invalid state | |||||||||||
| Description | I try to launch the Reset Accounting process, but when opening the window I had a java exception page. The error pointed to an invalid query. Following the logs, I found that the problem is that AD_TABLE_POST_V view is in an invalid state. | |||||||||||
| Steps To Reproduce | Browse database schema and view status of AD_TABLE_POST_V | |||||||||||
| Proposed Solution | At line 5, change: SELECT ad_table.ad_table_id, (COALESCE(w2.name, '') || by: SELECT ad_table.ad_table_id, (COALESCE(to_char(w2.name), '') || and at line 17, change: SELECT ad_table.ad_table_id, (COALESCE(to_char(w2.name), '') || by: SELECT ad_table.ad_table_id, (COALESCE(to_char(w2.name), '') || | |||||||||||
| Additional Information | ||||||||||||
| Tags | No tags attached. | |||||||||||
| Relationships |
| |||||||||||
| Attached Files | ||||||||||||
| Issue History | ||||||||||||
| Date Modified | Username | Field | Change | |||||||||
| 2008-07-01 18:20 | plujan | New Issue | ||||||||||
| 2008-07-01 18:20 | plujan | Assigned To | => cromero | |||||||||
| 2008-07-01 18:20 | plujan | sf_bug_id | 0 => 2007998 | |||||||||
| 2008-07-01 18:20 | plujan | OBNetwork customer | => No | |||||||||
| 2008-07-01 18:23 | cromero | Status | new => scheduled | |||||||||
| 2008-07-01 18:23 | cromero | fix_in_branch | => trunk | |||||||||
| 2008-07-01 18:25 | svnbot | Checkin | ||||||||||
| 2008-07-01 18:25 | svnbot | Note Added: 0008111 | ||||||||||
| 2008-07-01 18:25 | svnbot | Status | scheduled => resolved | |||||||||
| 2008-07-01 18:25 | svnbot | Resolution | open => fixed | |||||||||
| 2008-07-01 18:25 | svnbot | svn_revision | => 5532 | |||||||||
| 2008-09-03 22:01 | psarobe | Regression testing | => No | |||||||||
| 2008-09-03 22:01 | psarobe | Status | resolved => closed | |||||||||
| 2008-09-03 22:01 | psarobe | Fixed in Version | => 2.40 | |||||||||
| Notes | |||||
|
|
|||||
|
|
||||