Project:
| View Issue Details[ Jump to Notes ] | [ Issue History ] [ Print ] | |||||||
| ID | ||||||||
| 0035895 | ||||||||
| Type | Category | Severity | Reproducibility | Date Submitted | Last Update | |||
| defect | [Retail Modules] StoreServer | major | have not tried | 2017-05-02 17:01 | 2017-05-29 17:43 | |||
| Reporter | AugustoMauch | View Status | public | |||||
| Assigned To | AugustoMauch | |||||||
| Priority | normal | Resolution | fixed | Fixed in Version | RR17Q3 | |||
| Status | closed | Fix in branch | Fixed in SCM revision | 3af52a62c6c2 | ||||
| Projection | none | ETA | none | Target Version | ||||
| OS | Any | Database | Any | Java version | ||||
| OS Version | Database version | Ant version | ||||||
| Product Version | SCM revision | |||||||
| Merge Request Status | ||||||||
| Review Assigned To | mtaal | |||||||
| OBNetwork customer | No | |||||||
| Support ticket | ||||||||
| Regression level | ||||||||
| Regression date | ||||||||
| Regression introduced in release | ||||||||
| Regression introduced by commit | ||||||||
| Triggers an Emergency Pack | No | |||||||
| Summary | 0035895: validate.store.server task cannot be run in Oracle: user needs to be granted permission to create materialized views | |||||||
| Description | One 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 Reproduce | In 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 Solution | In Oracle, grant users permission to create materialized views. | |||||||
| Tags | No tags attached. | |||||||
| Attached Files | ||||||||
 Relationships [ Relation Graph ]
[ Dependency Graph ]
|
|
 Relationships |
|
Notes |
|
|
(0096355) hgbot (developer) 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 (administrator) 2017-05-03 16:07 |
The fix has passed Try |
|
(0096357) AugustoMauch (administrator) 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 (viewer) 2017-05-15 11:34 |
Reviewed and is part of ci store server |
|
(0096931) hudsonbot (viewer) 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 |
|
Notes |
|
Issue History |
|||
| Date Modified | Username | Field | Change |
| 2017-05-02 17:01 | AugustoMauch | New Issue | |
| 2017-05-02 17:01 | AugustoMauch | Assigned To | => AugustoMauch |
| 2017-05-02 17:01 | AugustoMauch | OBNetwork customer | => No |
| 2017-05-02 17:01 | AugustoMauch | Triggers an Emergency Pack | => No |
| 2017-05-03 16:02 | AugustoMauch | Review Assigned To | => mtaal |
| 2017-05-03 16:06 | hgbot | Checkin | |
| 2017-05-03 16:06 | hgbot | Note Added: 0096355 | |
| 2017-05-03 16:06 | hgbot | Status | new => resolved |
| 2017-05-03 16:06 | hgbot | Resolution | open => fixed |
| 2017-05-03 16:06 | hgbot | Fixed in SCM revision | => http://code.openbravo.com/erp/devel/pi/rev/3af52a62c6c27f29b019284cde766cb43be379f7 [^] |
| 2017-05-03 16:07 | AugustoMauch | Note Added: 0096356 | |
| 2017-05-03 16:47 | AugustoMauch | Note Added: 0096357 | |
| 2017-05-15 11:34 | mtaal | Note Added: 0096585 | |
| 2017-05-15 11:34 | mtaal | Status | resolved => closed |
| 2017-05-15 11:34 | mtaal | Fixed in Version | => RR17Q3 |
| 2017-05-29 17:43 | hudsonbot | Checkin | |
| 2017-05-29 17:43 | hudsonbot | Note Added: 0096931 | |
|
Issue History |
| Copyright © 2000 - 2009 MantisBT Group |
 |