No response after creating a date interval

Problem

Whenever a date interval is created and this date interval has date attributes as <Start> and/or <End> assigned, LUY might not any longer respond and an error appears. This is only the case when date attributes are not activated for the same building block types as the date interval itself. 

Solution

You can use the following SQL statements to fix the problem:

MySQL

UPDATE ATTR SET LAST_MOD_USER='-', LAST_MOD_TIME='2000-01-01 00:00:00' WHERE LAST_MOD_USER is NULL or LAST_MOD_TIME is NULL;

Oracle

UPDATE "ATTR" SET LAST_MOD_USER = '-', LAST_MOD_TIME = TO_TIMESTAMP('2000-01-01 00:00:00.000000000', 'YYYY-MM-DD HH24:MI:SS.FF') WHERE LAST_MOD_TIME is NULL or LAST_MOD_USER is NULL;

MS SQL

UPDATE ATTR SET LAST_MOD_USER='-', LAST_MOD_TIME='2000-01-01 00:00:00' WHERE LAST_MOD_USER is NULL or LAST_MOD_TIME is NULL;

When LUY is running again, please check if the <End> date attribute of the date interval was set.