0029402: Analytics does not work as real time reporting component

Openbravo Issue Tracking System - Modules

View Issue Details

Project

Category

View Status

Date Submitted

Last Update

0029402

Modules

Analytics

public

2015-03-25 13:08

2015-06-03 11:06

Reporter

jecharri

Assigned To

platform

Priority

high

Severity

major

Reproducibility

always

Status

closed

Resolution

no change required

Platform

OS Version

Product Version

Target Version

Fixed in Version

Merge Request Status

Regression date

Regression introduced by commit

Regression level

Review Assigned To

egoitz

Support ticket

OBNetwork customer

Regression introduced in release

Summary

0029402: Analytics does not work as real time reporting component

Description

Analytics does not work as real time reporting component.

The problem is that Analytics is creating locks in database and for example if you are working with Web POS and analytics at the same time Web POS is not going to work and orders are going to finish in "Errors while importing POS data" window

Steps To Reproduce

-Configure background processes "Update Analytics Fact Tables" or "Mondrian Cache Preload"
-Verify that in table pg_locks there are a lot of different kind of locks related to above processes

This is generating big performance problems if you are executing during working hours and also is creating big problems with Web POS

Proposed Solution

Additional Information