Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0004254 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| backport | [Openbravo ERP] A. Platform | critical | have not tried | 2008-07-01 18:23 | 2008-07-02 11:25 | |||
| Reporter | plujan | View Status | public | |||||
| Assigned To | cromero | |||||||
| Priority | immediate | Resolution | fixed | Fixed in Version | 2.40beta | |||
| Status | closed | Fix in branch | 2.40beta | Fixed in SCM revision | 5533 | |||
| Projection | none | ETA | none | Target Version | ||||
| OS | Windows | Database | Oracle | Java version | don't know | |||
| OS Version | XPsp2 | Database version | XE | Ant version | don't know | |||
| Product Version | 2.40beta | SCM revision | ||||||
| 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 | 0004254: 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), '') || | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
||||||||
|
||||||||
 Relationships |
|
Notes |
|
|
(0008112) svnbot (viewer) 2008-07-01 18:25 |
Repository: openbravo Revision: 5533 Author: cromeroherrero Date: 2008-07-01 18:25:56 +0200 (Tue, 01 Jul 2008) Fixed bug 4254: AT240beta - Using Oracle, AD_TABLE_POST_V view is in an invalid state --- U branches/r2.40beta/src-db/database/model/views/AD_TABLE_POST_V.xml --- https://dev.openbravo.com/websvn/openbravo/?rev=5533&sc=1 [^] |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2008-07-01 18:23 | cromero | New Issue | |
| 2008-07-01 18:23 | cromero | Assigned To | => cromero |
| 2008-07-01 18:23 | cromero | Status | new => scheduled |
| 2008-07-01 18:25 | svnbot | Checkin | |
| 2008-07-01 18:25 | svnbot | Note Added: 0008112 | |
| 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 | => 5533 |
| 2008-07-02 11:25 | plujan | Status | resolved => closed |
| 2008-07-02 11:25 | plujan | Fixed in Version | => 2.40beta |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |