CMDBuild Forum

Problem with big delay in history tab

Old Versions
#1

Hello CMDBuild team!

I have installed openMAINT and have inserted data for about 30 buildings and about 700 offices (rooms).

However, whenever I select the history tab in the buildings (or rooms or floors or complex) I have to wait more than 1 minute (!) to show the history!

Is this normal? I copy and paste from my cmdbuild.log file:

Regards, Dimitris

 

WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInBuilding#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInFloor#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInRoom#Description'
WARN  2016-08-22 19:32:03 [sql     ] cannot get content of column 'Building HISTORY#IsInUnit#Description'

#2

No, it is not normal.

In version 2.3.1 of our base environment CMDBuild on which is built openMAINT had been introduced a performance problem that has been fixed in later versions 2.3.x.

Now it is available CMDBuild version 2.4.1, on which will be based openMAINT 1.1 whose release is expected in October.

CMDBuild Team