Openbravo Issue Tracking System - Openbravo ERP
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0015555Openbravo ERPA. Platformpublic2010-12-30 19:252011-01-20 00:00
Reporterplujan 
Assigned Toalostale 
PriorityimmediateSeveritycriticalReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Versionpi 
Target VersionFixed in Version 
Merge Request Status
Review Assigned To
OBNetwork customer
Web browser
ModulesCore
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0015555: In Oracle, Enterprise Module Management window shows an error message on open
DescriptionWhen going to Enterprise Module Management window, an error is shown:
    
Error: Error
org.hibernate.exception.SQLGrammarException: could not execute query

And nothing else can be done on that page.
Steps To Reproduce1. Login as an Client Admin user, like QAAdmin
2. Go to General Setup > Enterprise > Enterprise Module Management
3. The referred error is shown. See attach.
Proposed Solution
Additional Information
TagsRegression QA
Relationships
related to defect 00151782.50MP25 closed marvintm Users shouldn't be able to apply a dataset if it hasn't changed 
depends on backport 0015557 closed alostale In Oracle, Enterprise Module Management window shows an error message on open 
related to defect 0015556 closed mtaal OBCriteria is not able to filter Oracle's CLOB datatype 
related to design defect 0013153 acknowledged Triage Platform Base DAL queries don't work with CLOB (oracle) 
Attached Filespng screenshot-1.png (16,414) 2010-12-30 19:25
https://issues.openbravo.com/file_download.php?file_id=3454&type=bug
png
Issue History
Date ModifiedUsernameFieldChange
2010-12-30 19:25plujanNew Issue
2010-12-30 19:25plujanAssigned To => alostale
2010-12-30 19:25plujanFile Added: screenshot-1.png
2010-12-30 19:25plujanModules => Core
2010-12-30 19:25plujanTag Attached: Regression QA
2010-12-30 19:26plujanNote Added: 0033486
2010-12-31 08:05alostaleRelationship addedrelated to 0015178
2010-12-31 08:06alostaleNote Added: 0033487
2010-12-31 09:08alostaleNote Added: 0033491
2010-12-31 09:18alostaleRelationship addedrelated to 0015556
2010-12-31 09:18alostaleNote Added: 0033492
2010-12-31 09:22alostaleStatusnew => scheduled
2010-12-31 09:22alostalefix_in_branch => pi
2010-12-31 09:24hgbotCheckin
2010-12-31 09:24hgbotNote Added: 0033493
2010-12-31 09:24hgbotStatusscheduled => resolved
2010-12-31 09:24hgbotResolutionopen => fixed
2010-12-31 09:24hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/cfca6a9741cb077a8f23ce6e9ac0f22ba8c92e2e [^]
2010-12-31 15:20hudsonbotCheckin
2010-12-31 15:20hudsonbotNote Added: 0033506
2011-01-05 08:30alostaleRelationship addedrelated to 0013153
2011-01-19 12:54shuehnerNote Added: 0033764
2011-01-19 12:54shuehnerStatusresolved => closed
2011-01-20 00:00anonymoussf_bug_id0 => 3162068

Notes
(0033486)
plujan   
2010-12-30 19:26   
Note that this issue only applies to Oracle contexts. In PostgreSQL it works fine.
(0033487)
alostale   
2010-12-31 08:06   
Introduced when fixing 0015178
(0033491)
alostale   
2010-12-31 09:08   
It fails in oracle when there is at least a Dataset applied at organization level
(0033492)
alostale   
2010-12-31 09:18   
See technical description of this issue in 0015556
(0033493)
hgbot   
2010-12-31 09:24   
Repository: erp/devel/pi
Changeset: cfca6a9741cb077a8f23ce6e9ac0f22ba8c92e2e
Author: Asier Lostalé <asier.lostale <at> openbravo.com>
Date: Fri Dec 31 09:22:25 2010 +0100
URL: http://code.openbravo.com/erp/devel/pi/rev/cfca6a9741cb077a8f23ce6e9ac0f22ba8c92e2e [^]

fixed issue 15555: In Oracle, Enterprise Module Management window shows an error message on open

  Applied workaround described in issue 0015556: use OBQuery instead of OBCriteria.

---
M src/org/openbravo/erpCommon/modules/ModuleReferenceDataOrgTree.java
---
(0033506)
hudsonbot   
2010-12-31 15:20   
A changeset related to this issue has been promoted to main after passing a series of tests and an OBX has been generated:

Changeset: http://code.openbravo.com/erp/devel/main/rev/cfca6a9741cb [^]
Merge Changeset: http://code.openbravo.com/erp/devel/main/rev/f27092744645 [^]
Tests: http://builds.openbravo.com/view/int/ [^]
(0033764)
shuehner   
2011-01-19 12:54   
Code-change reviewed and opening window tested on oracle & postgres to verify that error happening on window open does not happen anymore. No need to retest functionality as code-change does do the equivalent query as before with just working about the dal/clob/oracle-problem.