Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0004254Openbravo ERPA. Platformpublic2008-07-01 18:232008-07-02 11:25
Reporterplujan 
Assigned Tocromero 
PriorityimmediateSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS10OS VersionXPsp2
Product Version2.40beta 
Target VersionFixed in Version2.40beta 
Merge Request Status
Review Assigned To
OBNetwork customerNo
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0004254: AT240beta - Using Oracle, AD_TABLE_POST_V view is in an invalid state
DescriptionI 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 ReproduceBrowse database schema and view status of AD_TABLE_POST_V
Proposed SolutionAt 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
TagsNo tags attached.
Relationships
blocks defect 0004253 closed cromero AT240beta - Using Oracle, AD_TABLE_POST_V view is in an invalid state 
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2008-07-01 18:23cromeroNew Issue
2008-07-01 18:23cromeroAssigned To => cromero
2008-07-01 18:23cromeroStatusnew => scheduled
2008-07-01 18:25svnbotCheckin
2008-07-01 18:25svnbotNote Added: 0008112
2008-07-01 18:25svnbotStatusscheduled => resolved
2008-07-01 18:25svnbotResolutionopen => fixed
2008-07-01 18:25svnbotsvn_revision => 5533
2008-07-02 11:25plujanStatusresolved => closed
2008-07-02 11:25plujanFixed in Version => 2.40beta

Notes
(0008112)
svnbot   
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 [^]