Openbravo Issue Tracking System - Retail Modules
View Issue Details
IDProjectCategoryView StatusDate SubmittedLast Update
0035895Retail ModulesStoreServerpublic2017-05-02 17:012017-05-29 17:43
ReporterAugustoMauch 
Assigned ToAugustoMauch 
PrioritynormalSeveritymajorReproducibilityhave not tried
StatusclosedResolutionfixed 
PlatformOS5OS Version
Product Version 
Target VersionFixed in VersionRR17Q3 
Merge Request Status
Review Assigned Tomtaal
OBNetwork customerNo
Support ticket
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary0035895: validate.store.server task cannot be run in Oracle: user needs to be granted permission to create materialized views
DescriptionOne of the first steps of the validate.store.server task is to created some materialized views that are used to improve the performance of the validation.

The problem is that in Oracle this step fails because users need explicit access to be able to create materialized views.
Steps To ReproduceIn a multiserver environment running in Oracle, invoke the validate.store.server task. Validation will not succeed and the following error (full log in [1]) will be shown:

[SynchronizationStoreDataValidationTask] Creating materialized view materialized_AD_User
[SynchronizationStoreDataValidationTask] 19739 [pool-3-thread-1] ERROR org.hibernate.util.JDBCExceptionReporter - ORA-01031: insufficient privileges

[1] http://ci.openbravo.com/view/storeserver/job/ret-ms-mix-db-central-oracle/158/console [^]
Proposed SolutionIn Oracle, grant users permission to create materialized views.
Additional Information
TagsNo tags attached.
Relationships
Attached Files
Issue History
Date ModifiedUsernameFieldChange
2017-05-02 17:01AugustoMauchNew Issue
2017-05-02 17:01AugustoMauchAssigned To => AugustoMauch
2017-05-02 17:01AugustoMauchOBNetwork customer => No
2017-05-02 17:01AugustoMauchTriggers an Emergency Pack => No
2017-05-03 16:02AugustoMauchReview Assigned To => mtaal
2017-05-03 16:06hgbotCheckin
2017-05-03 16:06hgbotNote Added: 0096355
2017-05-03 16:06hgbotStatusnew => resolved
2017-05-03 16:06hgbotResolutionopen => fixed
2017-05-03 16:06hgbotFixed in SCM revision => http://code.openbravo.com/erp/devel/pi/rev/3af52a62c6c27f29b019284cde766cb43be379f7 [^]
2017-05-03 16:07AugustoMauchNote Added: 0096356
2017-05-03 16:47AugustoMauchNote Added: 0096357
2017-05-15 11:34mtaalNote Added: 0096585
2017-05-15 11:34mtaalStatusresolved => closed
2017-05-15 11:34mtaalFixed in Version => RR17Q3
2017-05-29 17:43hudsonbotCheckin
2017-05-29 17:43hudsonbotNote Added: 0096931

Notes
(0096355)
hgbot   
2017-05-03 16:06   
Repository: erp/devel/pi
Changeset: 3af52a62c6c27f29b019284cde766cb43be379f7
Author: Augusto Mauch <augusto.mauch <at> openbravo.com>
Date: Wed May 03 16:02:06 2017 +0200
URL: http://code.openbravo.com/erp/devel/pi/rev/3af52a62c6c27f29b019284cde766cb43be379f7 [^]

Fixes issue 35895: Grants permission to create materialized views in Oracle

The org.openbravo.replication.symmetricds module uses materialized views (see [1]) to validate the data of a store. In Oracle, users need to be given explicit permission to create materialized views in the database.

[1] https://code.openbravo.com/erp/pmods/org.openbravo.replication.symmetricds/file/d3e746082b6f/src/org/openbravo/replication/symmetricds/validation/SynchronizationStoreDataValidator.java#l201 [^]

---
M src-db/database/build-create.xml
---
(0096356)
AugustoMauch   
2017-05-03 16:07   
The fix has passed Try
(0096357)
AugustoMauch   
2017-05-03 16:47   
This fix will only grant permission to create materialized views for new Openbravo installations (when install.source is run).

Applying this change to an existing environment will not have any effect. This is assumed as a known issue.
(0096585)
mtaal   
2017-05-15 11:34   
Reviewed and is part of ci store server
(0096931)
hudsonbot   
2017-05-29 17:43   
A changeset related to this issue has been promoted main and to the
Central Repository, after passing a series of tests.

Promotion changeset: https://code.openbravo.com/erp/devel/main/rev/1ee70113bdc4 [^]
Maturity status: Test